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
are u using tabular sql or tabular model?
Srik
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
Little reminder: close the topic if it's been solved/closed (see board rules)