Error with Refcursor

[aamuktha]

Hi

The following Error i am getting while validating the report.Please send me the solution as early as possible.it is very urgent


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

UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.

UDA-SQL-0446 Oracle returned an error message.

ORA-24338: statement handle not executed

UDA-SQL-0107 A general exception has occurred during the operation "{0}".

Trace back:

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

WPEngine.cpp(472): WPDataRetrievalException:

WPEngine.cpp(946): WPDataRetrievalException:

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

LWDataRetrievalEngine.cpp(305): WPDataRetrievalException: CCL_RETHROW: LWDataRetrievalEngine::prepare

LWDataRetrievalEngine.cpp(1838): WPDataRetrievalException: CCL_THROW: LWDataRetrievalEngine::runQSQuery

WPQueryCacheMgr.cpp(433): QSException: CCL_RETHROW:

WPQueryCacheMgr.cpp(639): QSException: CCL_RETHROW:

WPQueryCacheMgr.cpp(749): QSException: CCL_RETHROW:

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


thanks
Aamuktha

[BIsrik]

are u using tabular sql or tabular model?

Srik

[BIsrik]

i feel u might be using TM. check out the functions (if any) used in ur calculation...check the data types in the calcultion. this is error comes from the database when the report executes. i think ur report gets validated successfully but u get this error in runtime...

Srik

[sir_jeroen]

Little reminder: close the topic if it's been solved/closed (see board rules)