'System.OutOfMemoryException' SSRS 2005 Error

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

'System.OutOfMemoryException' SSRS 2005 Error

Author

Topic

Danny_SQL_9876
Starting Member

8 Posts

Posted - 2012-02-23 : 17:55:27

Hi All,

When i run a report from visual studio it gives me the following error

"An error occurred during local report processing.
An error has occurred during report processing.
Exception of type 'System.OutOfMemoryException' was thrown"

The query behind it is very simple returning 80000 records.

the server i am running the report on is 64 bit, 14 GB Ram. 3 GH

Note: when i run the query in SSMS it take 1 sec to return results, when i run the query on "Data" tab on the report itself the query takes 1 sec to return all the results. but when i design a table in "Layout" and try to preview the report it keeps rendering for around 2 minutes and throws the error.

Any Help is appreciated. Thanks in advance

Danny

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-23 : 17:57:08

is the report having lots of images ,pictures etc in it?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Danny_SQL_9876
Starting Member

8 Posts

Posted - 2012-02-23 : 18:00:48

Hi Visakh,

Nop. there are no images, no fancy formatting at all. plain table with fields.

Danny

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-23 : 18:33:56

whats the purpose of showing 80,000 records in report? I didnt understand what anyone will do all those rows. You might be better off applying further filters and also paging to show only subset of data and then make report interactive to show rest of data only if user is interested

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Danny_SQL_9876
Starting Member

8 Posts

Posted - 2012-02-24 : 09:45:43

Hi Visakh,

the query behind the report is bringing back 80000 records. but in the design i am grouping them to create a summarized report.

Jayam.cnu
Starting Member

45 Posts

Posted - 2012-02-24 : 09:59:46

Hi... I am not well in reporting services.. but there is an option in that report server setting to avoid that situation...
please follow this link may be it will useful for you query
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/c5955063-8af0-4c31-8da6-b12c42e26b58

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-24 : 10:05:10

quote:
Originally posted by Danny_SQL_9876

Hi Visakh,

the query behind the report is bringing back 80000 records. but in the design i am grouping them to create a summarized report.

if you want summary data alone why not bring data grouped from databse itself? or is it some kind of interactive grouping you're trying to do?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

evjo
Starting Member

20 Posts

Posted - 2012-03-01 : 18:28:40

I've had this before, we fixed it by moving logic / grouping etc out of the report and into the database / cube. You'll find that the report runs quicker as well.

Whenever I see an old lady slip and fall on a wet sidewalk, my first instinct is to laugh. But then I think, what if I was an ant, and she fell on me. Then it wouldn't seem quite so funny.

- Jack Handey

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources