locked
out of memory exception RRS feed

  • Question

  • hey! I was trying to display a report with more than half a million rows in SSRS using the report designer. AN error of type

     

    Out of memory exception is throw. How to increase the limit of number of rows in SSRS report designer
    Sunday, November 23, 2008 11:12 PM

Answers

  • Which version of SSRS are you using?  If it is SSRS2005, since the SSRS2005 engine processes the whole report at once, it will run into resource constraints for reports having huge amount of data. In 2008, there have been quite a few scalability enhancements through on-demand procesing and it will be less likely to hit OOM exception.

    http://blogs.msdn.com/robertbruckner/archive/2008/07/20/Scale-up-improvements-in-reporting-services-2008.aspx
    http://blogs.msdn.com/robertbruckner/archive/2008/08/11/on-demand-report-processing-in-rs-2008.aspx


    Monday, November 24, 2008 3:19 AM

All replies

  • Which version of SSRS are you using?  If it is SSRS2005, since the SSRS2005 engine processes the whole report at once, it will run into resource constraints for reports having huge amount of data. In 2008, there have been quite a few scalability enhancements through on-demand procesing and it will be less likely to hit OOM exception.

    http://blogs.msdn.com/robertbruckner/archive/2008/07/20/Scale-up-improvements-in-reporting-services-2008.aspx
    http://blogs.msdn.com/robertbruckner/archive/2008/08/11/on-demand-report-processing-in-rs-2008.aspx


    Monday, November 24, 2008 3:19 AM
  • That is an awful lot of rows.  I generally advise people not to build reports like this.  I'm curious how useful a 500k+ row report is going to be to the consumer.  What rendering extension are you using?  OOM errors may occur in 2005 with report of this magnitude, but in general 2008 handles high memory-consumption reports a lot better.  Can you try on 2008 with the latest cumulative updates applied?

     

    Thanks,

    Chris

    Monday, November 24, 2008 3:28 AM