Symptoms

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-56'. 

UDA-SQL-0115 Inappropriate SQL request. 

UDA-SQL-0564 Deferred prepare could not be completed. 

UDA-SQL-0564 Statement(s) could not be prepared. (SQLSTATE=42000, SQLERRORCODE=8180) 

UDA-SQL-0564 Incorrect syntax near 'udfcode'. (SQLSTATE=42000, SQLERRORCODE=102) 


Reason

SQL query contains comments starting with "--" or "/*".

Even though the query runs in Query Analyzer it fails in Cognos.

Resolution

Remove the comments.