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

Need Solution for the error message

Started by satheeshgouda, 30 Jan 2008 07:58:04 AM

Previous topic - Next topic

satheeshgouda

I am facing the below error message while running a report where as view tabular data of the report query fetching me the data.

Report Ran fine for first 2 times. The database used is Oracle 10 g .

Error Message:
QE-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation 'sqlOpenResult' is inactive.
ORA-03113: end-of-file on communication channel
UDA-SQL-0023 The connection to the 'Oracle' database has been terminated due to an unrecoverable error.

Tried the below solution given in the support.cognos.com but it didnot help.
increased OPEN_CURSORS parameter in SPFILECOGNOS.ORA from the value 3000 to 9000.
Also tried another solution: For the required query in the report, changed the processing to Limited Local in the properties pane, this solution also didnot help

Any body faced This error ?



Anuya

Hi Saathesh,

Me getting the same error as well.....did u get any solution yet?