If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Print Error IBM Cognos 8

Started by Comp011, 10 Dec 2019 02:42:44 PM

Previous topic - Next topic

Comp011

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)...

Andrei I

It seems an Oracle Datasource error.

Did these reports run fine before?
Did you upgrade an Oracle DB version recently by any chance?

Comp011

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.



Andrei I

Analyze Oracle error: ORA-01036: illegal variable variable/name.
Possibly some recently loaded data  is the reason?

Comp011

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.

Andrei I

Can you try to create a new report and run it?