Wednesday, April 13, 2011

Configuring SSRS Report Timeout in SharePoint

In My Project, we have integrated the Report(SSRS) with Sharepoint site. One of the report takes long time to display the data due to huge data.

When I tried to access that report, It throws the below error:

If you check the report thru Native Mode, then its default timeout limit is 9000 secods(2.5 hrs). If the report is integrate with SharePoint, Then Default Timeout limit is reduced to 120 seconds(2 minutes). If any report exceeds this limit, then  the Sharepoint server throws the timeout error as exhibit above.

To Solve this issue, We've increased the timeout limit of the Sharepoint by following the steps listed here:

1.Locate web.config for the SharePoint site you have configured for SSRS integration (in my case I used the default site, so the file is located at C:\inetpub\wwwroot\wss\VirtualDirectories\8080)
Note:8080 is a portNumber used in the Sharepoint, so you check the correspoing port that used in your project
2.Open the file in an XML or text editor

3.Look for "httpRuntime" (easiest thing to do is use the FIND functionality of your editor - ctrl F in most cases)

4.Inside the tag, add executionTimeout="1800" (30 Minutes)
(The end result will look like this: <httpRuntime maxRequestLength=”51200” executionTimeout=”1800” />)

5. Close and save the file

6.Restart IIS

Hope this helps you!

No comments:

Post a Comment