Report Timeout problem ;Out of memory exception

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trupti - 31 Mar 2005 08:55 GMT

I am having a problem with report rendering.

The MSSRS Report runs for around 15 minutes and then the report page times
out giving the error as

"Out of memory exception. Server application unavailable".

When i check the query execution time in query analyser, query returns
results in 10 minutes.

There are about 3 groups in the RDL design.

Please provide any suggestions to overcome this problem.

Thanks in advance.

Thanks and Cheers,
Trupti

Reply to this Message

Adrian M. - 31 Mar 2005 14:32 GMT

Sounds like your report is just too big. RS renders reports in memory, thus
the 'Out of memory exception'. Try redesigning the report or adding more
memory to your machine/server.

Also, if you get the report to successfully run you can try to pin point
what's taking so long. Look in the ReportServer database; the ExecutionLog
table. It shows what report ran, when, the amount of time for data
retrieval, processing time, and rendering time. It also shows what render
format, render status (fail or success), query row count and byte size of
the rendered file.

Signature

Adrian M.
MCP

>I am having a problem with report rendering.
>
[quoted text clipped - 14 lines]
> Thanks and Cheers,
> Trupti

Reply to this Message