Groups | Blog | Home
all groups > sql server reporting services > january 2005 >

sql server reporting services : Out of memory error when running large report


Mike Harbinger
1/6/2005 6:47:55 PM
I have built a large report but when I try to execute inside of the Report
Designer, I get the following error and then an abort:

[An error has occurred during report processing
Exception of type System.OutOfMemoryException was thrown]


I have applied SRS SP1 and here is the MSD info:
Microsoft Visual Basic .NET 69457-005-1826837-18410
Microsoft SQL Server Report Designer Version 8.00.878.00

Running on XP SP2 with 1.25 gig RAM

Is there a work-around for this?

Thanks for any help!

Mike Harbinger
1/7/2005 11:47:07 AM
Thanks for the reponse Brad, but I am not getting the error from the report
server but from inside of the .Net Visual Studio Reporting Services
designer.





[quoted text, click to view]

bradsy NO[at]SPAM Online.Microsoft.com (
1/7/2005 6:43:56 PM
http://support.microsoft.com/?kbid=840709

This article may help you.


--------------------
| From: "Mike Harbinger" <MikeH@Cybervillage.net>
| Subject: Out of memory error when running large report
| Date: Thu, 6 Jan 2005 18:47:55 -0800
| Lines: 18
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#$rvPNG9EHA.1408@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 69.106.50.114
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:38909
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have built a large report but when I try to execute inside of the
Report
| Designer, I get the following error and then an abort:
|
| [An error has occurred during report processing
| Exception of type System.OutOfMemoryException was thrown]
|
|
| I have applied SRS SP1 and here is the MSD info:
| Microsoft Visual Basic .NET 69457-005-1826837-18410
| Microsoft SQL Server Report Designer Version 8.00.878.00
|
| Running on XP SP2 with 1.25 gig RAM
|
| Is there a work-around for this?
|
| Thanks for any help!
|
|
|
John K
3/18/2005 1:29:06 PM
Mike / Brad,

I am experiencing the same issue : "An error occured during report
processing. Exception of type System.OutOfMemoryException was thrown". I can
reproduce this both inside ReportServices IDE or through the manager. I have
SP1 running on a dual CPU server with 6GB of memory and the report I am
running has 800,000 rows. The same report with a different selection in the
parameters returning less rows works fine.

Let me know if you have identified a work around.

Thanks in advance,
John

[quoted text, click to view]
Bruce L-C [MVP]
3/18/2005 7:17:20 PM
RS works in memory. It is inappropriate to be using it to end up with
800,000 rows. That means that the report is not for a person, it must be for
import into someother product. Use a different technology to do this. SQL
Server has other ways of exporting data.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button