Troubleshooting
Problem
After importing metadata from IBM DB2 database, attempt to test the query subjects show the following error message.
Symptom
Framework Manager:
The query contains an error and can not be executed.
It is recommended that you view the query feedback on the
"Query Information" tab.
QE-DEF-0177 An error occurred while
performing operation 'sqlPrepareWithOptions' status='16'.
UDA-SQL-0353
An error was detected while processing the SQL request.
[IBM][CLI
Driver][DB2/6000] SQL0206N "column name" is not valid in the context
where it is used. SQLSTATE=42703
Additionally, Report Viewer, when attempting to run report based on above model shows:
QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'.
Details show:
UDA-SQL-0196 The table or view
"column name" was not found in the
dictionary.
RSV-SRV-0042 Trace back: <trace back to the offending
function call>
Log InLog in to view more of this document
Historical Number
1019199
Was this topic helpful?
Document Information
More support for:
Cognos Business Intelligence
Software version:
10.2.2, 10.2.1, 10.2, 10.1.1, 10.1
Operating system(s):
Windows
Document number:
367817
Modified date:
07 May 2025
UID
swg21339555