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

**Error RQP-DEF-0177 appear after upgrade from v.8 to v.10.1.1

Started by namekt24, 25 Nov 2013 09:17:49 PM

Previous topic - Next topic

namekt24

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.

Grim

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)