Error with Select & Search prompt

[cog8user]

Hi All,

I have a report with optional Select & Search prompt that runs perfectly when run ignoring the parameter. But when I try to search a value in the parameter with '%', it throws following error. Report validation is also fine. The parameter query is using a data item from a view in oracle db. I have been unable to trace the problem.
ERROR DETAILS:

RQP-DEF-0177

An error occurred while performing operation 'sqlOpenResult' status='-28'.

Details

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0023 The connection to the "Oracle Live Database" database has been terminated due to an unrecoverable error. ORA-03113: end-of-file on communication channel RSV-SRV-0042 Trace back: RSReportService.cpp(595): QFException: CCL_CAUGHT: RSReportService:rocess() RSReportServiceMethod.cpp(177): QFException:


Any ideas or solution is appreciated very much.

Thanks in Advance.

 

[CognosProfessional]

Did you test this problem in Framework manager first? Do you have it set up for the select and search prompt there? Try it there.

CP