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
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21341778