locked
System Out Of Memory Exception In SSRS RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi i have a requirement where i have to create a report for like 6.8 million record
    all the records should be  aggregated and should put them in the report  and render that to a PDF, the report was runnign fine( i am doing it on preview mode in Business Intelligence development Studio 2008) but when i render it to PDF i am getting an out of memory exception , i saw there is a 160 page limit for PDF rendering but my report has like 30 pages MAX i dont understand why the rendering has a Out oF memory could some one please help me out with this thanks
    Monday, July 23, 2012 2:19 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

    Reporting services has a MemoryThreshold, which specifies a percentage ofWorkingSetMaximum that defines the boundary between high and medium pressure scenarios, if you rendering large amount records, you could also configure settings that control memory allocation for the report server include WorkingSetMaximum, WorkingSetMinimum,MemorySafetyMargin, and MemoryThreshold. Configuration settings are specified in the RSReportServer.config file.

    For more information about Configuring Available Memory for Report Server, please see:
    http://msdn.microsoft.com/en-us/library/ms159206.aspx

    Hope this helps.

    Regards,
    Charlie Liao

    • Proposed as answer by Syed Qazafi Anjum Thursday, July 26, 2012 12:59 AM
    • Marked as answer by Mike Yin Monday, July 30, 2012 10:08 AM
    Wednesday, July 25, 2012 6:26 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    It seems your report server does not have enough memory to suport the operation. 
    Monday, July 23, 2012 2:38 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    It seems your report server does not have enough memory to suport the operation. 

    Is there any way i can increse the memory on the report server  so the rendering can go fine.
    Monday, July 23, 2012 3:16 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    What are your server specifications? CPU, RAM, Windows, SQL Edition?
    • Edited by irusul Tuesday, July 24, 2012 8:20 AM
    Tuesday, July 24, 2012 8:20 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

    Reporting services has a MemoryThreshold, which specifies a percentage ofWorkingSetMaximum that defines the boundary between high and medium pressure scenarios, if you rendering large amount records, you could also configure settings that control memory allocation for the report server include WorkingSetMaximum, WorkingSetMinimum,MemorySafetyMargin, and MemoryThreshold. Configuration settings are specified in the RSReportServer.config file.

    For more information about Configuring Available Memory for Report Server, please see:
    http://msdn.microsoft.com/en-us/library/ms159206.aspx

    Hope this helps.

    Regards,
    Charlie Liao

    • Proposed as answer by Syed Qazafi Anjum Thursday, July 26, 2012 12:59 AM
    • Marked as answer by Mike Yin Monday, July 30, 2012 10:08 AM
    Wednesday, July 25, 2012 6:26 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Reporting services has a MemoryThreshold, which specifies a percentage ofWorkingSetMaximum that defines the boundary between high and medium pressure scenarios, if you rendering large amount records, you could also configure settings that control memory allocation for the report server include WorkingSetMaximum, WorkingSetMinimum,MemorySafetyMargin, and MemoryThreshold. Configuration settings are specified in the RSReportServer.config file.

    For more information about Configuring Available Memory for Report Server, please see:
    http://msdn.microsoft.com/en-us/library/ms159206.aspx

    Hope this helps.

    Regards,
    Charlie Liao


    will try this
    Wednesday, July 25, 2012 6:10 PM