October 7, 2011 at 8:30 am
I have a report that shows pictures in 4 columns and 5 rows on a page, there are 3000 total pictures.
When I do a preview of the report in Visual Studio, I get the message
"an error occurred during local report processing. A generic error occurred in GDI+" after processing around 500 pictures. I have to close all programs, including VS and reopen VS to process even 500 pictures.
I tried exporting to PDF these 3000 pictures, I get error
'an error occurred during local report processing. An unexpected error occurred in report processing, Exception of type ‘System.OutOfMemoryException’ was thrown '
After researching I changed GDIProcessHandleQuota value in registry, increased from 10,000 to 25,000 on my machine, that allowed me to process 200 more pictures before crashing. I can change it upto 65,000, but going that high will make my PC in operable and still may not process all 3000 pictures.
Appreciate any help.
Environment:
PC: Microsoft Windows XP Professional
Version5.1.2600 Service Pack 3 Build 2600
Microsoft Visual Studio 2008
Version 9.0.30729.4462 QFE
Microsoft .NET Framework
Version 3.5 SP1
Installed Edition: Professional
-------
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 10.50.1600.1
running on windows server 2007 standard service pack 2, Microsoft .NET Framework
Version 3.5 SP1
October 7, 2011 at 9:03 am
How large are the pictures combined compared to how much space is on your PC? I think your just running out of memory or hard disk space.
My suggestion is to explore other means for this report or help redefine its purpose to a less intensive report.
An example would be to simply list out the pictures in the report, then make a drill through to another report that will show the picture.
Ultimately if these pictures need to be exported in one PDF document or something SSIS is probably a better delivery tool.
Lastly here is some helpful information on Report Size in memory:
October 7, 2011 at 1:53 pm
On average 300kb/picture, hard disk space is not a problem, I have a new machine with plenty of disk space. Thanks for the link to the report size.
October 7, 2011 at 2:47 pm
I think I'd go with SSIS as well in this case.
How much memory (RAM) do you have? The message indicates that either your RAM or your Video Card memory is running out of memory.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 8, 2011 at 1:10 pm
4GB RAM. I have to look into SSIS, to see how I can do it; I need to be able format and put titles underneath the pictures.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply