an error occurred during local report processing
Hi,
I am very new to Report Builder 3.0
I am getting the following error
Exception of type 'System.OutOfMemoryException' was thrown.
----------------------------
An error has occurred during report processing.
----------------------------
An error occurred during local report processing.
Any help would be appreciated.
ThanksDavid
May 16th, 2011 12:06am
Hello,
I think it is one of hot file prob please go through below link
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-2008-cumulative-update-1-is-a
You can request this SQL Server 2008 Cumulative Update here:
http://support.microsoft.com/default.aspx/kb/956717
subu
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 12:59am
Hi KIWI,
Generally, Reporting Services responds to system resource constraints by adjusting the amount of memory that is allocated to specific applications and types of processing requests. If the records are too large, it will cause the system out of memory exception.
In order to deal with this issue, you can reduce memory consumption by redesigning the report queries in the following ways:
• Return less data in the report queries
• Move complex aggregations to the data source.
• Use a better restriction on the WHERE clause of the report queries.
For more information, please refer to the article and blog below:
Configuring Available Memory for Report Server Applications
Memory Management in Reporting Services 2008
If you have any questions, please feel free to ask.
Thanks,
Bin Long
May 18th, 2011 5:39am