Error : The Operation Has Timed Out In SSRS Report Server
1) Set the HttpRuntime ExecutionTimeout value to a greater value (ie 3
hours) on the Report Server
a. Open the ReportServer’s Web.config file by going to Start -> Administrative Tools ->
a. Open the ReportServer’s Web.config file by going to Start -> Administrative Tools ->
Internet Information
Services.
b. From there, expand Web Sites -> Default Web
Site, and click on ReportServer. On the right-h
zand pane, right-click
‘Web.Config’ and select ‘Open’.
c. Locate the HttpRuntime parameter. If it
doesn’t exist, you will have to create it within the
<System.Web>
section.
d. Set the executionTimeout value to ‘10800’ (3
hours) as shown below:
<system.web>
< httpRuntime executionTimeout = "10800" />
< /system.web>
2) Increase the script timeout on the report server
1. Go onto your Reporting Server and open up Internet Information Services; right-click on the
ReportServer and select Properties.
2. Go to the Options tab, and set the ASP Script timeout to 300 seconds as shown below.
3) Set the report to never time out on the server
1. Open your web browser on the server and go to http://localhost/Reports
2. Navigate to the Report location and click on the problem report(s).
3. On the left-hand pane, click on Properties.
4. In the ‘Report Execution Timeout’ click the ‘Do not timeout report execution’.
2. Go to the Options tab, and set the ASP Script timeout to 300 seconds as shown below.
3) Set the report to never time out on the server
1. Open your web browser on the server and go to http://localhost/Reports
2. Navigate to the Report location and click on the problem report(s).
3. On the left-hand pane, click on Properties.
4. In the ‘Report Execution Timeout’ click the ‘Do not timeout report execution’.
Great article,Thank you for sharing this awesome Post.
ReplyDeleteKeep updating....
MSBI Online Training
Thank you for your valuable feedback
Delete