We can't print/run all reports via Advanced Reporting. Error 'RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status= '28'. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0107 A general exception has occurred during operation "execute". ORA-01036: illegal variable variable/name RSV-SRV-0042 Trace back: RSReportService.cpp(771)...
It seems an Oracle Datasource error.
Did these reports run fine before?
Did you upgrade an Oracle DB version recently by any chance?
Hello Andrei,
Yes prior to mid-October 2019 all reports; Basic/Consumer and Custom ran without any faults. Currently some reports run and print from the Print/Reports Server thru Oracle DB Server and the Application Server. I have not found any reason why what type of reports run and why others don't.
No DB upgrades applied. The attachment is a screen shot of a print/report request that returns the RQP-DEF-0177 error.
We are using Cognos 8 with Infor EAM v8.5.
Take care,
Mike J.
Analyze Oracle error: ORA-01036: illegal variable variable/name.
Possibly some recently loaded data is the reason?
Andrei, thanks for most recent reply. I have an additional attachment that might assist. I didn't see any recent updates that might have affected Cognos/java events.
Thanks again,
Mike J.
Can you try to create a new report and run it?