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

Author Topic: Print Error IBM Cognos 8  (Read 3564 times)

Offline Comp011

  • Associate
  • **
  • Join Date: Dec 2019
  • Posts: 3
  • Forum Citizenship: +0/-0
Print Error IBM Cognos 8
« on: 10 Dec 2019 02:42:44 pm »
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)...
« Last Edit: 16 Dec 2019 07:38:58 am by MFGF »

Offline Andrei I

  • Community Leader
  • *****
  • Join Date: Jan 2006
  • Posts: 195
  • Forum Citizenship: +7/-0
Re: Print Error IBM Cognos 8
« Reply #1 on: 11 Dec 2019 12:02:58 pm »
It seems an Oracle Datasource error.

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

Offline Comp011

  • Associate
  • **
  • Join Date: Dec 2019
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: Print Error IBM Cognos 8
« Reply #2 on: 11 Dec 2019 12:45:09 pm »
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.



Offline Andrei I

  • Community Leader
  • *****
  • Join Date: Jan 2006
  • Posts: 195
  • Forum Citizenship: +7/-0
Re: Print Error IBM Cognos 8
« Reply #3 on: 12 Dec 2019 06:07:55 am »
Analyze Oracle error: ORA-01036: illegal variable variable/name.
Possibly some recently loaded data  is the reason?

Offline Comp011

  • Associate
  • **
  • Join Date: Dec 2019
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: Print Error IBM Cognos 8
« Reply #4 on: 17 Dec 2019 10:49:04 am »
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.

Offline Andrei I

  • Community Leader
  • *****
  • Join Date: Jan 2006
  • Posts: 195
  • Forum Citizenship: +7/-0
Re: Print Error IBM Cognos 8
« Reply #5 on: 17 Dec 2019 02:20:41 pm »
Can you try to create a new report and run it?