Hi Folks,
I have a report which is fetching and displaying around 100K records in a list.
When I run this report in HTML with 50, 100, 500 rows per page it is running fine though it takes some time to run.
But when I say run in PDF that’s where prblem comes, since it has to load all the 100K records in a single shot to PDF, it is failing with error CCLOutOfMemoryError:0:Fatal: RSV-SRV-0042 Trace back:RSReportService.cpp(740): CCLOutOfMemoryError: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(263): CCLOutOfMemoryError: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(828): CCLOutOfMemoryError: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(277): CCLOutOfMemoryError: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRun_RequestRSASyncExecutionThread.cpp(884): CCLOutOfMemoryError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestExecution/RSRenderExecution.cpp(670): CCLOutOfMemoryError: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(292): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): CCLOutOfMemoryError: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(359): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(179): CCLOutOfMemoryError: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(309): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(303): CCLOutOfMemoryError: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(309): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): CCLOutOfMemoryError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(309): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(137): CCLOutOfMemoryError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(359): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(309): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSDocAssemblyDispatch.cpp(309): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSDocAssemblyDispatch.cpp(359): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(309): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSDocAssemblyDispatch.cpp(309): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyRSEdge.cpp(709): CCLOutOfMemoryError: CCL_RETHROW: RSEdge::iterateRSEdge.cpp(761): CCLOutOfMemoryError: CCL_RETHROW: RSDataRowCopy.cpp(60): CCLOutOfMemoryError: CCL_RETHROW: RSDataRowCopy::RSDataRowCopyQFSEdgeIterator.cpp(613): CCLOutOfMemoryError: CCL_RETHROW: QFSEdgeIterator::GetRowCopyQFSEdgeIterator.cpp(720): CCLOutOfMemoryError: CCL_RETHROW: QFSEdgeIterator::ProviderGetRowCopyQFSEdgeIterator.cpp(544): CCLOutOfMemoryError: CCL_RETHROW: QFSEdgeIterator::GetColumnQFSEdgeIterator.cpp(544): CCLOutOfMemoryError: CCL_RETHROW: QFSEdgeIterator::GetColumnQFSEdgeIterator.cpp(374): CCLOutOfMemoryError: CCL_RETHROW: QFSEdgeIterator::GotoMPCAQuery.cpp(420): CCLOutOfMemoryError: CCL_THROW:
’.
Tried adjusting some configuration settings on Number of requests, queue length and time but no use. Can you guys guide me if you have come across this kind of this situation.
Any help is greatly appreciated.
cheers,
ucn