Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: shital kumar on 14 Oct 2015 01:44:43 AM

Title: Error RSV-SRV-0042 when try to run report.
Post by: shital kumar on 14 Oct 2015 01:44:43 AM
Hi,

I have value prompt with multiple selection. When I select all the value in the prompt and try to run the report its throwing error RSV-SRV-0042. Any thought or suggestion? Details are as below

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(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): RSQFCommandException: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/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/RSCrosstabAssembly.cpp(1340): RSQFCommandException: CCL_THROW: RSCrosstabAssembly::getIterator.



Thanks,
Shital
Title: Re: Error RSV-SRV-0042 when try to run report.
Post by: BigChris on 14 Oct 2015 02:12:13 AM
Haven't come across it myself, but a quick Google search threw up these:

http://goo.gl/KsOliR
https://goo.gl/WlRmNQ
Title: Re: Error RSV-SRV-0042 when try to run report.
Post by: Lynn on 14 Oct 2015 02:19:49 AM
Quote from: shital kumar on 14 Oct 2015 01:44:43 AM
Hi,

I have value prompt with multiple selection. When I select all the value in the prompt and try to run the report its throwing error RSV-SRV-0042. Any thought or suggestion? Details are as below

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(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): RSQFCommandException: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/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/RSCrosstabAssembly.cpp(1340): RSQFCommandException: CCL_THROW: RSCrosstabAssembly::getIterator.



Thanks,
Shital

I see several other posts from you where you don't give very much detail and people need to draw it out of you inch by inch. Please read the forum etiquette post (http://www.cognoise.com/index.php/topic,24030.0.html) to learn how you can better articulate your questions.

What is your data source? From what little you post I'd ask how many choices are presented in the value prompt and what is the size of the "use" value for each? Are you blowing things up trying to send a massive request?

I'd also suggest that you make the prompt optional since selecting every single possible value is the same as selecting none of them and omitting it from the resulting where clause.



Text only | Text with Images