If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

PL/SQL based crosstab report error

Started by kalyan_sekhar1, 08 Sep 2005 02:05:54 PM

Previous topic - Next topic

kalyan_sekhar1

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

sir_jeroen

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.