August 20, 2007 at 7:34 am
Hi,
I have some problems with a Reporting Services 2000 installation...
Not every day but once or twice per week we get some errors:
Server Error in '/Report Server' Application
Server application unavailable
When we receive these errors we cannot run Reporting Services, but if we wait for a couple of minutes it works fine again. Sometime it helps to restart the application pool in IIS.
I don’t know what could cause these errors to appear. Has anyone had the same problems and what could it be... it is quite frustrating...
It is often on Monday when there is the most activity going on the database server.
Best regards,
Nicklas
August 20, 2007 at 7:48 am
August 20, 2007 at 8:21 am
Hi James
I cannot find anything in the iis log.
In the event log I found "Report Server faild to write to trace log.".
In the ReportServer log i found some info:
ERROR: Internal error: System.OutOfMemoryException: Exception of type System.OutOfMemoryException was thrown.
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.OutOfMemoryException: Exception of type System.OutOfMemoryException was thrown.
Is there some limits on how much memory Reporting Services can use?
Best regards,
Nicklas
August 20, 2007 at 8:27 am
I would turn on perfmon and monitor reporting services' and SQL Servers memory usage and see if it peaks just before a crash happens. There might be a report which returns too many rows etc which when run causes the problem - if this is the case then I would put on SQL Profiler and capture the queries which take longer than 0.5 seconds to run and see if you can find the query which causes the problem.
James
--
James Moore
Red Gate Software Ltd
August 21, 2007 at 12:17 am
I will try to monitor this... I know that some reports return a lot of data.
Thank you for your advice.
Best regards,
Nicklas
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply