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.!!!
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.!!!