COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bbrooksux on 29 Mar 2010 09:09:59 AM

Title: Oracle report validation errors
Post by: bbrooksux on 29 Mar 2010 09:09:59 AM
We're in the process of validating our report library (which was built against a SQL database/framework) against an Oracle database in preparation for a release.  About half of the reports are running great, but several reports are failing validation with 3 key errors:
ORA-00942: table or view does not exist                                 
ORA-03113: end-of-file on communication channel                         
ORA-00600: internal error code, arguments: [qcscpqbTxt], [907], [], [], [], [], [], []
We've tried to ensure that the reports themselves (and the underlying framework) are dbms agnostic.  Looking through the IBM site, I'm not able to track down any resolution for any of these error messages.  Have any of you come across these error messages in Cognos/Oracle, and how do you tackle them?

Currently using Cognos 8.4 FP2, running against an Oracle 10g instance.
Title: Re: Oracle report validation errors
Post by: blom0344 on 29 Mar 2010 04:21:35 PM
Wild guesses:

1. Schemas (any diffs between Oracle / SQL ?)
2. Connection type (OR for Oracle / OL for SQL)