Hi,
I am having an issue running a SQL view based report via report studio. I have a report that is DMR and generates a temp cube which it builds off. The reports are being migrated from 8.1.2 to 8.4.1. The report works on 8.1.2 but fails with the full error below. Any assistance would be welcomed.
RSV-SRV-0042 Trace back:RSReportService.cpp(779): QFException: CCL_CAUGHT: RSReportService:rocess()RSReportServiceMethod.cpp(265): QFException: CCL_RETHROW: RSReportServiceMethod:rocess(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(788): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(838): QFException: CCL_RETHROW: RSASyncExecutionThread:rocessCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(606): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(277): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(176): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(300): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(173): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(135): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSQueryMgr.cpp(1076): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1241): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1555): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(187): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(167): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(305): QFException: CCL_RETHROW: RSQFSession:oRequestQFSSession.cpp(719): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSSession.cpp(717): QFException: CCL_CAUGHT: QFSSession:rocessDoRequest()QFSSession.cpp(662): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSSession.cpp(637): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSConnection.cpp(751): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4299): QFException: CCL_THROW: CoordinationPlanner
I am having an issue running a SQL view based report via report studio. I have a report that is DMR and generates a temp cube which it builds off. The reports are being migrated from 8.1.2 to 8.4.1. The report works on 8.1.2 but fails with the full error below. Any assistance would be welcomed.
RSV-SRV-0042 Trace back:RSReportService.cpp(779): QFException: CCL_CAUGHT: RSReportService:rocess()RSReportServiceMethod.cpp(265): QFException: CCL_RETHROW: RSReportServiceMethod:rocess(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(788): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(838): QFException: CCL_RETHROW: RSASyncExecutionThread:rocessCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(606): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(277): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(176): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(300): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(173): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(135): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSQueryMgr.cpp(1076): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1241): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1555): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(187): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(167): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(305): QFException: CCL_RETHROW: RSQFSession:oRequestQFSSession.cpp(719): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSSession.cpp(717): QFException: CCL_CAUGHT: QFSSession:rocessDoRequest()QFSSession.cpp(662): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSSession.cpp(637): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSConnection.cpp(751): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4299): QFException: CCL_THROW: CoordinationPlanner