Author Topic: **Error RQP-DEF-0177 appear after upgrade from v.8 to v.10.1.1  (Read 2475 times)

Offline namekt24

  • Associate
  • **
  • Join Date: Nov 2013
  • Posts: 1
  • Forum Citizenship: +0/-0
Hi All,

I have been facing with this issue after upgrade Cognos v.8 to v.10.1.1
I could only be able to burst out with only ‘Run Report in HTML format’ but not for another formats (ie. PDF and Excel 2007) and also it couldn't be sent out by email function and any automatic running functions. It still happens with the same errors as the error details below.

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 the operation "open result". ORA-01722: invalid number

This error has never happened on v.8 before.
If anyone has experienced this error please guide.

Thank you.

Offline Grim

  • Honorary Master of IBM Links
  • Statesman
  • ******
  • Join Date: Nov 2011
  • Posts: 688
  • Forum Citizenship: +58/-7
Re: **Error RQP-DEF-0177 appear after upgrade from v.8 to v.10.1.1
« Reply #1 on: 26 Nov 2013 12:25:17 pm »
Had these types of issues with 10.1.1 GA, fix for us was included in the 10.1.1 Fix Packs. Have you updated to the latest Fix Pack?

If yes, then I'd look at tracking down the Oracle error as it is most likely the root of the issue. That said with the release of 10 they tightened up on security and items that were previously possible in older versions are no longer possible as they were not intended in the first place. Same thing happened with 8.3 > 8.4.1. :\
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)