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
(http://i773.photobucket.com/albums/yy17/namekt24/NPBS-Error_StandardReport_detail_zps15cf2829.jpg) (http://s773.photobucket.com/user/namekt24/media/NPBS-Error_StandardReport_detail_zps15cf2829.jpg.html)
This error has never happened on v.8 before.
If anyone has experienced this error please guide.
Thank you.
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. :\