July 22, 2015 at 5:04 pm
I have a workstation running the vs 2010 shell for developing ssrs reports. In task manger I am using 10 gig of RAM and have 30 gig available. I created a report that downloads about 900,000 rows of data. I try to preview the report and memory usage goes from 10 gig to about 11.5 gig and then I get an error;
An error has occurred in report processing, Exception of type ‘Sytem.outofmemoryException’ was thrown.
There are 28.5 gig of available memory.
Thanks
David
July 23, 2015 at 1:16 am
If I'm not mistaken VS2010 is a 32-bit application, so there is a 4GB limit. Have you tried to filter the report to reduce the number of rows of data?
July 23, 2015 at 8:08 am
Our user would like to be able to drill down to the detail. I could create subreports and filter the parent report. However, being that there are gigabyte and gigabytes of available memory available, it seems that subreports are a lot of effort without too much return on time invested.
July 23, 2015 at 8:58 am
Do you get the error when you preview the report in VS2010? Or is it when the user is running it from Reporting Services, which hopefully is a 64-bit installation?
July 23, 2015 at 9:02 am
It is in preview mode on my PC that I am getting the error.
Both my workstation and the server I hope to publish it to are 64 bit.
July 23, 2015 at 9:20 am
If you have a 64-bit installation of SSRS on your workstation you should deploy and view it there. Otherwise to the server and then view the report.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy