Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / productivity / SharePoint / SharePoint2013

When Exporting Large Data from SSRS Report to Excel, Getting Error Message as Request Timeout in Sharepoint 2013

0.00/5 (No votes)
23 Jul 2018CPOL 19.2K  
This tip will help you to resolve issue when exporting large data from SSRS report to Excel, getting error message Request timeout in SharePoint 2013.

Introduction

This tip will help you to resolve the request timeout error when you export the data from SSRS report to Excel.

How to reproduce the issue:

  1. Navigate to SharePoint Site--> library where you hosted SSRS report
  2. Click on the report and select Actions-->Export to Excel
  3. Then, the report will take some time and returns error message as "Request Timeout"

 

Solution

To fix this issue, we need to make change on the web.config file. Please follow the below steps:

  1. Open web.config file from: Drive:\inetpub\wwwroot\wss\VirtualDirectories\Virtual Directory Name
  2. Take a copy of existing web.config file
  3. Add the below entries in web.config file, You need to set the SharePoint site timeout from 110 seconds to 9000 seconds <httpRuntime maxRequestLength="100000" executionTimeout="9000" />
  4. On SP app server, open web.config file from: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\Reporting <httpRuntime executionTimeout="9000" maxRequestLength="409600" />

History

  • 5th July, 2016 : Initial version created

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)