IBM Support

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.

Troubleshooting


Problem

Unable to create a Query Subject with a SQL statement or adding the same type of filter to a query subject in Framework Manager or adding a filter to simple list report throws error. [

]The same SQL can be executed successfully executed in the SQL Client. (Query Analyzer/SQL Plus)

Symptom

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.

Other errors which may accompany the QE-DEF-0177 error depending on environment or product version are:

UDA-SQL-0357 a syntax error was detected near SQL request
UDA-SQL-0358 Zeile 1: Syntaxfehler bei "outer".
QE-DEF-0177 Fehler beim Ausfuehren der Operation 'sqlPerpareWithOptions' Status='-16'

Cause

The SQL created by the addition of the filter does not pass edit checks built into the UDA (Universal Data Access) layer of IBM Cognos.

Environment

Microsoft SQL Server
Oracle

Resolving The Problem

Change the SQL Type from Cognos to Pass-Through will send the SQL to the database and will not be checked by the Cognos UDA layer.

Steps:In Framework Manager:
1) Query Subject Definition
2) Options ("Options" can be found in the Test or Query Information tabs of the query subject definition)
3) SQL Settings
4) SQL Type change to Pass-Through.

Related Information

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Viewer","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21341778