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?
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
18 People are following this question.
