I'm having problems with existing reports in CRN 1.1. Has anyone else experienced issues like this? This affects multiple reports (which I have no time or desire to create from scratch, they're somewhat complex).
Upgraded CRN and FM to 1.1. Opened project, verified model. Saved project and published package. Opened report and got the following error in report validation:
QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. UDA-SQL-0446 Oracle returned an error message. ORA-00904: invalid column name UDA-SQL-0450 An unexpected error encountered during the 'prepare'
operation.
Received the same error when I attempted to run the report.
Next, on recommendation from Cognos support, I tried deleting and re-creating the joins in the model in Framework
Manager. (?!) Then when I published the model, I deleted all the previous versions of the model. I opened the report in Report Studio, and validated. Still got the error:
QE-DEF-0177 An error occurred while performing operation
'sqlPrepareWithOptions' status='-9'. UDA-SQL-0446 Oracle returned an error message. ORA-00904: invalid column name UDA-SQL-0450 An unexpected error encountered during the "prepare" operation.
I saved the report. Upon attempting to run it, I now get the following error:
An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is
inactive.
UDA-SQL-0446 Oracle returned an error message.
ORA-01722: invalid number
UDA-SQL-0450 An unexpected error encountered during the "AOpen" operation.
RSV-SRV-0025 Unable to execute this request.
Upgraded CRN and FM to 1.1. Opened project, verified model. Saved project and published package. Opened report and got the following error in report validation:
QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. UDA-SQL-0446 Oracle returned an error message. ORA-00904: invalid column name UDA-SQL-0450 An unexpected error encountered during the 'prepare'
operation.
Received the same error when I attempted to run the report.
Next, on recommendation from Cognos support, I tried deleting and re-creating the joins in the model in Framework
Manager. (?!) Then when I published the model, I deleted all the previous versions of the model. I opened the report in Report Studio, and validated. Still got the error:
QE-DEF-0177 An error occurred while performing operation
'sqlPrepareWithOptions' status='-9'. UDA-SQL-0446 Oracle returned an error message. ORA-00904: invalid column name UDA-SQL-0450 An unexpected error encountered during the "prepare" operation.
I saved the report. Upon attempting to run it, I now get the following error:
An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is
inactive.
UDA-SQL-0446 Oracle returned an error message.
ORA-01722: invalid number
UDA-SQL-0450 An unexpected error encountered during the "AOpen" operation.
RSV-SRV-0025 Unable to execute this request.