I am new to cognos. I need your help in solving this issue.
Report is working fine when all products are selected but throwing the following error when any one of the products is selected.
RQP-DEF-0177An erroroccured whileperforming operation’SqlOpenresult’status=’-28’
Details of the error:
UDA-SQL-0114 The cursor supplied to the operation “SqlOpenResult” is inactive. UDA-SQL-0023 The connection to the database has been terminated due to an unrecoverable error. ORA-03113: end-of-file on communication channel.
I guess this is database error due to timeout operation. But it is working fine for bulk retrieval (of all products) where as timeout is occuring for less retrieval of only one product…
What is the reason and how to solve this…