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)".
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
100K rows in a PDF? Really? Why?? No offense, but I would have to question why do this at all.
When you render to PDF, I believe the whole thing is rendered in memory. So Cognos has to retrieve all the data, then build all of the pages in memory before writing out the file. Ergo, the out of memory error.
I think the only way around that will be to give more memory to Cognos, choose another format (CSV would probably work), or think about whether Cognos is even a tool to do what you are attempting.
Quote from: bdbits on 01 Aug 2014 05:40:30 PM
100K rows in a PDF? Really? Why?? No offense, but I would have to question why do this at all.
When you render to PDF, I believe the whole thing is rendered in memory. So Cognos has to retrieve all the data, then build all of the pages in memory before writing out the file. Ergo, the out of memory error.
I think the only way around that will be to give more memory to Cognos, choose another format (CSV would probably work), or think about whether Cognos is even a tool to do what you are attempting.
I couldn't have put this any better! I'm with Bob all the way here!
MF.
Aw gosh, kudos from the Muppet. It just doesn't get any better than this. 8)
The idea of dumping {insert very large number} records using Cognos seems to come up a lot. Honestly I do not understand why anyone would even think about doing it this way. I guess when you are using Cognos, everything looks like a report. ::)