Error RSV-SRV-0042 when try to run report.

[shital kumar]

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

[BigChris]

Haven't come across it myself, but a quick Google search threw up these:

http://goo.gl/KsOliR
https://goo.gl/WlRmNQ

[Lynn]

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 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.