SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Out of Memory in SSRS 2008


Out of Memory in SSRS 2008

Author
Message
h.yasmine82
h.yasmine82
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 75
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

ohio_bear_1234
ohio_bear_1234
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 84
I have same problem getting Outofmemory at SSRS2008.
Report Server at SQL2005 did work fine istead.
Silverfox
Silverfox
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6476 Visits: 1161
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

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
shahm10
shahm10
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1394 Visits: 844
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
ben.rosato
ben.rosato
Mr or Mrs. 500
Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)

Group: General Forum Members
Points: 567 Visits: 1566
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.
mathinabeevi.m
mathinabeevi.m
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 16
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?
ohio_bear_1234
ohio_bear_1234
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 84
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
mathinabeevi.m
mathinabeevi.m
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 16
Hi. Do u have any idea to solve memory related issues in SSRS 2008?
tkruse
tkruse
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 90
Never seen this issue in SSRS 2008, but i found this

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


Bajrang
Bajrang
SSC Eights!
SSC Eights! (884 reputation)SSC Eights! (884 reputation)SSC Eights! (884 reputation)SSC Eights! (884 reputation)SSC Eights! (884 reputation)SSC Eights! (884 reputation)SSC Eights! (884 reputation)SSC Eights! (884 reputation)

Group: General Forum Members
Points: 884 Visits: 248
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search