COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: a.info on 28 May 2013 08:41:28 AM

Title: Error when run report In Report Studio
Post by: a.info on 28 May 2013 08:41:28 AM
Hello everyone,

I run a report in format Excel and I get the following error:

CCLOutOfMemoryError:0:Fatal: RSV-SRV-0042 Parcours arrière :RSReportService.cpp(797): CCLOutOfMemoryError: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265): CCLOutOfMemoryError: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(788): CCLOutOfMemoryError: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): CCLOutOfMemoryError: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_RequestRSASyncExecutionThread.cpp(838): CCLOutOfMemoryError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(606): CCLOutOfMemoryError: CCL_RETHROW: RSRenderExecution::executeExecution/RSRenderExecution.cpp(1031): CCLOutOfMemoryError: CCL_RETHROW: RSRenderExecution::processActiveDocumentsRSXls2007OutputDispatch.cpp(291): CCLOutOfMemoryError: CCL_RETHROW: CCLFixedMemoryPool.cpp(208): CCLOutOfMemoryError: CCL_THROW:


If I run the report in PDF format, I have no error.

Do you have any idea?

Thank you
Title: Re: Error when run report In Report Studio
Post by: aruler on 07 Dec 2015 01:48:09 PM
I know this thread is a couple years old.

Did you find a solutions for this error?
Anyone, can you help?

I am having a similar issue exporting 90K records to Excel 2007 Data.
Title: Re: Error when run report In Report Studio
Post by: BigChris on 08 Dec 2015 02:05:33 AM
I'm afraid I can't answer your question (it looks vaguely hardware related...?), but a more fundamental question what's the user going to do with 90,000 records? They aren't going to read through them all - are they looking for a particular set of conditions? Do they want to see the top 10 / bottom 50, only those where the description contains xyz? You could build a flexible report that gives them all of those options and more which would save them having to trawl through a vast spreadsheet like that...
Title: Re: Error when run report In Report Studio
Post by: Lynn on 08 Dec 2015 02:25:14 AM
Everyone repeat after me....



....COGNOS IS NOT AN ETL TOOL.....COGNOS IS NOT AN ETL TOOL.....COGNOS IS NOT AN ETL TOOL....COGNOS IS NOT AN ETL TOOL....

Title: Re: Error when run report In Report Studio
Post by: BigChris on 08 Dec 2015 03:02:41 AM
 ;D 8) ;D

You put it much more elegantly and succinctly than I ever could!
Title: Re: Error when run report In Report Studio
Post by: Lynn on 08 Dec 2015 04:57:20 AM
Quote from: BigChris on 08 Dec 2015 03:02:41 AM
;D 8) ;D

You put it much more elegantly and succinctly than I ever could!

Although perhaps a tad more obnoxiously
::)
Title: Re: Error when run report In Report Studio
Post by: bdbits on 08 Dec 2015 05:30:23 PM
I literally laughed out loud, Lynn. Thanks!  ;D
Title: Re: Error when run report In Report Studio
Post by: cognostechie on 08 Dec 2015 06:48:48 PM
Hilarious  !!   ;D   ;D
Title: Re: Error when run report In Report Studio
Post by: MFGF on 14 Dec 2015 11:07:31 AM
 ;D ;D ;D