September 22, 2009 at 4:27 am
We are using Report Control to load the reports in Asp.net Web Application, In one of the report we are getting System.OutofMemory Exception" while exporting to excel or PDF.
Problem faced in the report : "System.OutofMemory Exception" while exporting to excel or PDF.
No:of Sub Report's in the problem faced report : 14 Sub Reports
Total No:of pages of the generated report : 2027
Configuration:
Hardware/ Software in the Development Environment
Windows 2003 Standard Edition
SQL Server 2005 / SQL Server 2008
IIS 6.0
Visual Studio 2008
3 GB RAM
Solutions Tried :
1) Increased the Recycling worker process size in the application pool in IIS
2) Increased the max server memory of SQL Server by enabling AWE and set the memory limit to 3 GB
3) Increased the memory limit settings in RSReportServer.Config file
4) Checked in both SQL Server 2005 SSRS and SQL Server 2008 SSRS
From Microsoft forum ( http://support.microsoft.com/kb/909678 ), i came to know about certain work arounds and tried.But still facing the same exception.My requirement is such that i will not be able to breakup or redesign my reports.So Please clarify me
1) whether its an tool limitation ?
2) If so is there any workarounds ?
It would be very helpful if any help is provided on this.
September 22, 2009 at 2:04 pm
Have you updated the web.config for your site and changed the maxRequestLength value in the HTTPRuntime section? I believe that the default is 4MB. We had a report export that was very large and would bomb when the users tried to export it to Excel from the report viewer. After upping the value to 50MB users could export the report without any issues.
September 23, 2009 at 12:48 am
Thanks for ur reply.i tried with the solution but still getting the same error "System.Outof Memory exception".I think the RAM is overloaded when am trying to export the report to excel or PDF.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply