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 ?
Hi Saathesh,
Me getting the same error as well.....did u get any solution yet?