question

JohnVolf avatar image
JohnVolf asked

Report Server returning "Operation Timed Out" error too quickly to be a timeout error

We have an internal website where users can generate reports that normally take 10 - 20 seconds to render which is not a problem. But occasionally we get the "The operation timed out" error. However, we get this error very quickly, usually within 5 seconds. Running the report again is usually successful. The timeout is set to an hour. How do I find out where the timeout is?
serverreporttimeout
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
sp_lock avatar image
sp_lock answered
I would start by checking the reporting services error logs "%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles" If there is nothing obvious in the logs you could run the query below SELECT C.Description , EL.TimeStart , EL.TimeEnd , EL.Parameters , EL.UserName , EL.TimeDataRetrieval / 1000.0 AS [Data] , EL.TimeRendering / 1000.0 AS [Render] , EL.TimeProcessing / 1000.0 AS [Process] , EL.Status , EL.[RowCount] FROM dbo.ExecutionLog AS EL LEFT JOIN dbo.Catalog AS C ON EL.ReportID = C.ItemID WHERE EL.TimeStart BETWEEN '2015-10-30 00:50:31' AND '2015-10-30 23:00:30' **Change the date range to what you need** Further details on the results can be found [here][1]. You are looking for looong durations within the Data, Render and Process fields. Also check the Status/Rowcount as these could also help with debugging. If all the times seems OK, then you may want to look at: - Network settings/performance - Check if you have RecycleTime set within rsreportserver.config - "Warm up" script for the web site. Related to the point above [1]: https://msdn.microsoft.com/en-GB/library/ms159110.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.