Thursday 23 April 2015

Export to excel large file failed in SSRS 2012 SharePoint 2013 integrated mode

we need to perform below changes in SharePoint Environment.

Server : SharePoint WFE server.

Step 1. Open the web.config file(\inetpub\wwwroot\wss\VirtualDirectories\Virtual Directory Name)

Step 2: Backup of Web.config Web application of affected site.

Step 3: Search below tag in web.config

<httpRuntime maxRequestLength="51200" requestValidationMode="2.0" />

and comment the tag like for e.g

<!-<httpRuntime maxRequestLength="51200" requestValidationMode="2.0" />->

and  add below code in web.config

<httpRuntime maxRequestLength="100000" executionTimeout="9000" />

save the file and close.

Server : SharePoint Application server

Step 1. Open the web.config file(\inetpub\wwwroot\wss\VirtualDirectories\Virtual Directory Name)

Step 2: Backup of Web.config Web application of affected site.

Step 3: Search below tag in web.config

<httpRuntime maxRequestLength="51200" />

and comment the tag like for e.g

<!-<httpRuntime maxRequestLength="51200" />->

and  add below code in web.config

<httpRuntime executionTimeout="9000" maxRequestLength="409600" />

save the file and close.

Repeat the steps for all the WFE and App servers.

Refresh the site and try to export.!!!

No comments:

Post a Comment