Hi all, I am getting the generic RSV-SRV-0042 Trace Back error when I try to run a package against my Prod data source. It works totally fine against my Test data source. But every query subject and item (all of them, every single one) throws this error when run against Prod. So it makes me think that the data sources might be configured differently, since it runs perfectly fine against Test.
I'm checking with my dba guys to see if anything could be different between the two. But I thought I should ask here too just to see if there's anything else that could be at fault.
RSV-SRV-0042
RSReportService.cpp(747): RSQFCommandException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): RSQFCommandException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_RequestRSASyncExecutionThread.cpp(854): RSQFCommandException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): RSQFCommandException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(910): RSQFCommandException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(585): RSQFCommandException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(325): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): RSQFCommandException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(178): RSQFCommandException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(369): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(314): RSQFCommandException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(369): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): RSQFCommandException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(369): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): RSQFCommandException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(369): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSAssembly.cpp(686): RSQFCommandException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(746): RSQFCommandException: CCL_THROW: RSAssembly::createListIterator.
Are the data source names identical in both environment? Keep in mind data source names are case sensitive.
Sent from my iPhone using Tapatalk
Yep datasources were named fine. It ended up being a few database views that weren't updated in the Prod environment. But I had no way of knowing that by the error message. I wish Cognos error messages were more descriptive (i.e. useful)
If you have access to the Cognos server log, you can often get more detail there. Otherwise, unfortunately you are usually looking at a java stack dump, which is not exactly intuitive most of the time.