An error occured during local report processing. Exception of type 'System.OutOfMemoryException' Was Thrown
I've been getting this error, randomly when previewing two reports. It does not seem to be based on report complexity, size, subreports etc. When reports are deployed to server, they all run fine. I just get the out of memory error locally. 1. I have one version with 2 datasets, and a number of matrix, table and list data regions. 2. I have a second version with only one table data region. 3. There is no custom code, variables, prompts or generally anything other than basic formatting in the report. 4. Both reports are based on the same SQL table. I can seem to run the two reports (both based on same SQL table) a few times, and then they start giving the out of memory error. I can open other other reports and they preview fine locally. What I've tried so far to no avail: 1. Deleted the downloaded data before refreshing the two reports. 2. Tried building the two reports before running. 3. Tried changing the process priority to high for devenv.exe. 4. Removed filters in the reports. 5. Changed the physical order of the underlying table. 6. Closed the reports and then re-opened them. 7. Close Visual Studio and Re-Open. This seems to work for a while and then the two reports start giving the error messages again. 8. Copied reports to a different project with the same data source. 9. Removed fields not used in report from the dataset query. The problem seems to be isolated to the table the reports are based on. Wondering if anyone has any suggestions at all on this, it's particularly problematic as the table these reports are based on will be used in numerous reports in the future. Machine and other information: 1. HP Laptop, 4GB of RAM, Windows XP 32Bit, All Current Service Packs 2. When report is previewed, downloaded data is about 35mb, free disk space 97gb 3. SQL table that the reports are based on is only 15,250 rows 4. Every time I run these reports, the MemUsage for devenv.exe seems to increase. This does not appear to be consistent. I recently installed Visual Studio 2010 but I don't believe this is causing the problem since only two reports are giving this error. Here's info on all of the various versions of locally installed products for Visual Studio 2008: Microsoft Visual Studio 2008 Version 9.0.30729.1 SP Microsoft .NET Framework Version 3.5 SP1 Installed Edition: Professional Microsoft Visual Basic 2008 91605-270-7457282-60518 Microsoft Visual Basic 2008 Microsoft Visual C# 2008 91605-270-7457282-60518 Microsoft Visual C# 2008 Microsoft Visual C++ 2008 91605-270-7457282-60518 Microsoft Visual C++ 2008 Microsoft Visual Studio 2008 Tools for Office 91605-270-7457282-60518 Microsoft Visual Studio 2008 Tools for Office Microsoft Visual Studio Tools for Applications 2.0 91605-270-7457282-60518 Microsoft Visual Studio Tools for Applications 2.0 Microsoft Visual Web Developer 2008 91605-270-7457282-60518 Microsoft Visual Web Developer 2008 Crystal Reports AAJ60-G0MSA4K-68000CF Crystal Reports Basic for Visual Studio 2008 Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB944899) KB944899 This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/944899. Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947171) KB947171 This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947171. Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947180) KB947180 This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947180. Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB948127) KB948127 This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/948127. Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB953256) KB953256 This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/953256. Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971092) KB971092 This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/971092. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB945282) KB945282 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/945282. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946040) KB946040 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946040. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946308) KB946308 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946308. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946344) KB946344 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946344. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946581) KB946581 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946581. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947173) KB947173 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947173. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947540) KB947540 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947540. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947789) KB947789 This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947789. Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB945140) KB945140 This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this service pack will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/945140. Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB947888) KB947888 This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this service pack will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947888. Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB948484) KB948484 This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this service pack will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/948484. Security Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB973675) KB973675 This security update is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this security update will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/973675. Security Update for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB972222) KB972222 This security update is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU. If you later install a more recent service pack, this security update will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/972222. SQL Server Analysis Services Microsoft SQL Server Analysis Services Designer Version 10.50.1600.1 SQL Server Integration Services Microsoft SQL Server Integration Services Designer Version 10.0.4000.0 ((Katmai_PCU_Main).100916-1939 ) SQL Server Reporting Services Microsoft SQL Server Reporting Services Designers Version 10.0.4000.0 Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB956453) KB956453 This update is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this update will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/956453. Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB967143) KB967143 This update is for Microsoft Visual Studio 2008 Professional Edition - ENU. If you later install a more recent service pack, this update will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/967143.
December 22nd, 2010 6:37pm

Hi Brian, To do futher troubleshooting, i would suggest you use less data for these reports to see whether the issue occurs. For example, add top 1000 in the select list or where clause to filter less data for the report to use. From your description, i can't see any exception on these reports. I guess you might need to add more ram for usage. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
December 24th, 2010 3:22am

I have exact the same problem. If I reduce the amount of lines in the dataset, OR EVEN if I reduce the amount of fields to be displayed in the report, the error disappears.
April 9th, 2011 5:42pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics