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

Monday 13 April 2015

SharePoint 2013 IIS Application Pool detailed Information using Powershell.

Steps:


  1. Run Powershell as an administrator.
  2. Copy the below powershell command and execute.


Get-SPServiceApplication | Select Name, @{Name="SPAppPoolName"; Expression={$_.ApplicationPool.Name}},  @{Name="IISAppPoolName"; Expression={$_.ApplicationPool.Id}}, @{Name="ProcessAccountName"; Expression={$_.ApplicationPool.ProcessAccountName}}