Post reply

Out of Memory in SSRS 2008

  • February 18, 2009 at 4:01 am

    #206627

    Hello,

    I work with SSRS 2008

    When i want to preview my report in SSRS 2008, i have this error message "Out of Memory". i know it's the problem of the memory

    But, i don't understand: when i start with a simple Reports, i preview them in few secondes and when i add one parameter, i preview them too, when i add two other parameters, i have the error message.

    i already worked with SSRS 2005, i didn't have this problem.

    the DBA verify settings in my machie, it's not the problem

    anyone has this problem?

    Have you ideas to resolve this "out of memory"?

    Thanks for your help

  • August 24, 2009 at 3:28 am

    #1043507

    I have same problem getting Outofmemory at SSRS2008.

    Report Server at SQL2005 did work fine istead.

  • August 24, 2009 at 5:49 am

    #1043554

    There are some issues when running SSRS 2008. Have you looked at the logs that reporting services creates. or increasing the memory that report server uses.

    Have a look at this blog and see if it helps.

    http://blogs.msdn.com/lukaszp/archive/2007/01/31/how-to-diagnose-issues-when-running-reports-in-the-report-server.aspx

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • August 26, 2009 at 7:32 pm

    #1045287

    I faced a similar problem but when I deployed that report, it worked without throwing

    any exceptions or errors.

    http://support.microsoft.com/kb/909678

  • August 28, 2009 at 9:57 am

    #1046328

    I was getting out of memory errors even though there is 3.5GB of memory free on the server. After I applied SP1, the errors went away but now the performance is terrible because it's using the pagefile instead of the 3.5GB of free memory. You can watch the memory usage increase till it gets to about 1GB and then it drops suddenly to about 400MB and starts thrashing the pagefile.

  • May 25, 2010 at 2:22 am

    #1171916

    I am developing reports in sqlserver 2008. I am getting similar error i.e, 'System.outofmemory Exception'.

    I tried setting MaxrequestLength as 2097151 in web.config of report server.

    Could you please let me know what would be the possible solution?

  • May 28, 2010 at 1:42 am

    #1173761

    Hi, Reporting Service at SQL2005 does work better than 2008.

    SQL2005 may use temp disk storage. SQL2008 uses on-memory for Reporting

    Service. On-memory work is unstable, I think.

    Ohio_bear_1234

  • June 2, 2010 at 2:56 am

    #1175153

    Hi. Do u have any idea to solve memory related issues in SSRS 2008?

  • June 2, 2010 at 9:58 am

    #1175395

    Never seen this issue in SSRS 2008, but i found this

    http://msdn.microsoft.com/en-us/library/ms159206.aspx

  • June 2, 2010 at 10:09 am

    #1175405

    How much memory do you have on the Server? E.g. If you have 4GB then it doesn't mean 4GB is available for BI!!..

    -RP

  • June 3, 2010 at 6:23 pm

    #1176259

    SQL 2005 server has 32GB. SQL 2008 server has 64GB.

    SQL 2005 does not show any problem using reporting server.

    SQL 2008 does show 'out of memory' even if using same data (imported from SQL2005).

    IIS does good job.

  • June 6, 2010 at 6:55 pm

    #1176913

    test

  • November 1, 2011 at 8:16 am

    #1401637

    Try deploying it to production as suggested above. That worked for me.

  • November 2, 2011 at 3:56 am

    #1402035

    Please check http://support.microsoft.com/kb/958745

    Hope this helps.!!!

    Regards,

    PD

  • July 27, 2012 at 4:57 pm

    #1518807

    http://bidn.com/blogs/MMilligan/bidn-blog/2903/ssrs-gotcha-interactiveheight=0

    Check that the interactive page size height property is not set to 0

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply