[Solved] Error Trapping

[kalyan_sekhar1]

Hi All,

As you know when something wrong happens the Cognos Display an error message something like

"QE-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.

UDA-SQL-0283 Metadata describing "PKG_MBU" does not match results from the database.

Trace back:

WPBIBusMethod.cpp(190): WPDataRetrievalException: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(174): WPDataRetrievalException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(169): WPDataRetrievalException: WPExecuteRequestThread::checkException

WPEngine.cpp(946): WPDataRetrievalException: "

Can any one please suggest on how trap this error and redirect another report which say some fancy message? is that possible in Cognos Report Net

Thanks

[sir_jeroen]

In what context? While running a report/starting CRN/....
Do you know what PKG_MBU is? Is this a Query Item in your package or a stored procedure?

[kalyan_sekhar1]

Hi,

While running the report , i need to get rid of those weird error messages for the end user. PKG_MBU is a stored procedure. As u see in the JAVA/.net where u can trap the error messages and redirect to other page. Can we have such redirection if there is any error message. My report contains Storeprocedures, Query Items etc.

Thanks

[sir_jeroen]

There's something wrong with your Stp.

"Metadata describing "PKG_MBU" does not match results from the database" This means (i think) something like your query items don't match the columns return from the stp. Error trapping is only possible from the SDK.

[kalyan_sekhar1]

i posted this error as a sample, i already rectified the procedure and report works fine, but only i want to find is there any possibility to trap an erro in the report?

Thanks

[sir_jeroen]

Be more specific next time... because this wasn't clear....

[kalyan_sekhar1]

Please go thru my posting agn ... the error i kept only for sample