Print Page - PL/SQL based crosstab report error

Title: PL/SQL based crosstab report error
Post by: kalyan_sekhar1 on 08 Sep 2005 02:05:54 PM

Hi ,

I created a report basing on PL/SQL stored Procedure, when i ran the report if i give the same parameters as given in Frame Work Manager while publishing its generating the report. But If i pass the different values its giving wiered error

Here is the Error Description:

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.

RSV-SRV-0025 Unable to execute this request.

Trace back:

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

WPReportExecutionMethod.cpp(180): QSException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

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

WPEngine.cpp(946): QSException:

WPController.cpp(263): QSException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(785): QSException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets

Source/QEDmResultSet.cpp(76): QSException: CCL_THROW: QE

---------------------------------------------

If any body can provide info on how to solve will be great helpful

Thanks

Title: Re: PL/SQL based crosstab report error
Post by: sir_jeroen on 14 Sep 2005 02:40:36 PM

Have you checked if it's text or numeric. I have had an error like that and in FM i passed numeric but RS passed it as text.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: kalyan_sekhar1 on 08 Sep 2005 02:05:54 PM