Print Page - [Solved] Error Trapping

Title: [Solved] Error Trapping
Post by: kalyan_sekhar1 on 24 Oct 2005 04:55:06 AM

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

Title: Re: Error Trapping
Post by: sir_jeroen on 24 Oct 2005 06:14:57 AM

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?

Title: Re: Error Trapping
Post by: kalyan_sekhar1 on 24 Oct 2005 08:20:55 AM

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

Title: Re: Error Trapping
Post by: sir_jeroen on 24 Oct 2005 09:40:35 AM

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.

Title: Re: Error Trapping
Post by: kalyan_sekhar1 on 24 Oct 2005 11:42:29 AM

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

Title: Re: Error Trapping
Post by: sir_jeroen on 24 Oct 2005 11:55:30 AM

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

Title: Re: [Solved] Error Trapping
Post by: kalyan_sekhar1 on 24 Oct 2005 12:16:54 PM

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

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: kalyan_sekhar1 on 24 Oct 2005 04:55:06 AM