RQP-DEF-0177An erroroccured whileperforming operation'SqlOpenresult'status='-28'

[srivalli]

Hi all,

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..

Thanks
Sri Valli.

[cbyrne]

Hi I get this error usually when there is a null field in the table and this is why the error says open result.  Usually when i have operators using the system and they don't enter information into a required field.  Try entering IS NULL maybe in your expressions to see if this fixes this.


Chris