Hello to all of you guys,
I'm getting the following message when executing a Drill on a report.
RSV-SRV-0042 Trace back:RSReportService.cpp(755): XQEException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(838): XQEException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(553): XQEException: CCL_CAUGHT: RSASyncExecutionThread::handlePromptExceptionExecution/RSRenderExecution.cpp(684): XQEException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(303): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(397): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(179): XQEException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(347): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(303): XQEException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(347): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(347): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(137): XQEException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(397): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(347): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyRSQueryMgr.cpp(581): XQEException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(673): XQEException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(275): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(170): XQEException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1166): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1164): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1125): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(753): XQEException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(135): XQEException: CCL_RETHROW: QFSQuery::Execute v2XQEConnector.cpp(292): XQEException: CCL_THROW: XQEConnector::send
Any help?
Thanks
Quote from: rnn.souza on 18 Feb 2015 07:13:44 AM
Hello to all of you guys,
I'm getting the following message when executing a Drill on a report.
RSV-SRV-0042 Trace back:RSReportService.cpp(755): XQEException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(838): XQEException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(553): XQEException: CCL_CAUGHT: RSASyncExecutionThread::handlePromptExceptionExecution/RSRenderExecution.cpp(684): XQEException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(303): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(397): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(179): XQEException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(347): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(303): XQEException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(347): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(347): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(137): XQEException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(397): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(347): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyRSQueryMgr.cpp(581): XQEException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(673): XQEException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(275): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(170): XQEException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1166): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1164): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1125): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(753): XQEException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(135): XQEException: CCL_RETHROW: QFSQuery::Execute v2XQEConnector.cpp(292): XQEException: CCL_THROW: XQEConnector::send
Any help?
Thanks
Sounds like either a badly defined member set/drill down behaviour or (more likely) an issue in your underlying package. What type of package are you using? It must be dimensional or you wouldn't be able to drill down at all, but what type of dimensional package? Is the underlying source a cube or a relational database?
MF.
Have you a calculated measure in your list/crosstab?
If yes, try to cast to a bigger data type with a *1.0
I had, some months ago, a similar problem and I solve it with this workaround.
Let me know If it works, please