Excel Web Services error in SharePoint
Unable to process the request. Wait a few minutes and try performing this operation again – Event Viewer Error 5231, 5239, 5240
Version: 1.5, Created: 11/20/2014, Last Updated: 12/15/2014
Error:
When you click on an excel file to open it in Excel web services, you get this error:
Unable to process the request. Wait a few minutes and try performing this operation again.
 |
| SharePoint Excel Services – Unable to Process Request Error |
Few Suggestions from other sources:
1. Stopped and started Excel Calculation services from SharePoint Central Admin > Servers in Farm page > ServerName > Services
2. Make sure Excel Service app is associated with the SharePoint web app
3. Under CA > SA > Excel Services > Global Settings > Load Balancing Scheme > change the settings from ‘Workbook URL’ to ‘Local’. but same issue
5. Excel Service Account for CDB permisions
http://support.microsoft.com/kb/981293
6. Edit host entry and loopback FQDN
7. IISReset
8. Reboot
9. Re-run psconfigui
10 no route site collection had been create when testing the service. https://<your application name>/_layouts/EwaStringsHandler.ashx/
11. Disable ASP.Net Impersonation in IIS http://blog.armgasys.com/?p=133
ULS Log Errors:
System.TypeInitializationException: The type initializer for ‘Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp’ threw an exception. —> System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401) at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException,
TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock) at Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag(UInt32 tagID, ULSCatBase categoryID, String output, Boolean
fRethrowException, TryBlock tryBlock, CatchBlock catchBlock, FinallyBlock finallyBlock) at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp..ctor() at Mic…
There was an error in communicating with Excel Calculation Services
http://SPAppServer013:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx exception: An error has occurred. [Session: User: domainSPFarmAdmSvcAct].
ServerSession.ProcessServerSessionException: An exception thrown during ExecuteWebMethod failed to convert to ECSException for server:
http://SPAppServer013:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx, method: GetHealthScore, ex:
Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSessionException: An error has occurred. —>
System.ServiceModel.FaultException: The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the se…..
Event Viewer Logs
I saw this error logged every 5 mins in on a WFE server.
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Server
Date: 12/15/2014 1:04:20 PM
Event ID: 2159
Task Category: Unified Logging Service
Level: Error
Keywords:
User: companySPFarmSvcAct
Computer: SPWFEServer01.company.com
Description:
Event 5240 (Excel Services Application) of severity ‘Error’ occurred 10 more time(s) and was suppressed in the event log
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
<System>
<Provider Name=”Microsoft-SharePoint Products-SharePoint Server” Guid=”{C33B4F2A-64E9-4B39-BD72-F0C2F27A619A}” />
<EventID>2159</EventID>
<Version>14</Version>
<Level>2</Level>
<Task>31</Task>
<Opcode>0</Opcode>
<Keywords>0x4000000000000000</Keywords>
<TimeCreated SystemTime=”2014-12-15T19:04:20.673990100Z” />
<EventRecordID>510279</EventRecordID>
<Correlation />
<Execution ProcessID=”7012″ ThreadID=”6000″ />
<Channel>Application</Channel>
<Computer>SPWFEServer01.company.com</Computer>
<Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
</System>
<EventData>
<Data Name=”int0″>5240</Data>
<Data Name=”string1″>Excel Services Application</Data>
<Data Name=”int2″>10</Data>
</EventData>
</Event>
Error 2:
On WFe 3 server:
Log Name: Application
Source: Microsoft-SharePoint Products-Excel Services Application
Date: 12/15/2014 1:13:41 PM
Event ID: 5240
Task Category: Web Front End
Level: Error
Keywords:
User: companySPFarmSvcAct
Computer: SPWFEServer03.company.com
Description:
There was an error in communicating with Excel Calculation Services
http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx exception: An error has occurred.
[Session:
User: companySPFarmSvcAct].
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
<System>
<Provider Name=”Microsoft-SharePoint Products-Excel Services Application” Guid=”{278E40D0-FDAA-4EB4-AB6B-9E0AD6BDBE79}” />
<EventID>5240</EventID>
<Version>14</Version>
<Level>2</Level>
<Task>8</Task>
<Opcode>0</Opcode>
<Keywords>0x8000000000000000</Keywords>
<TimeCreated SystemTime=”2014-12-15T19:13:41.610718500Z” />
<EventRecordID>529546</EventRecordID>
<Correlation />
<Execution ProcessID=”5588″ ThreadID=”7280″ />
<Channel>Application</Channel>
<Computer>SPWFEServer03.company.com</Computer>
<Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
</System>
<EventData>
<Data Name=”string0″>http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx</Data>
<Data Name=”string1″>An error has occurred.</Data>
<Data Name=”string2″>
</Data>
<Data Name=”string3″>companySPFarmSvcAct</Data>
</EventData>
</Event>
Error 3:
Log Name: Application
Source: Microsoft-SharePoint Products-Excel Services Application
Date: 12/15/2014 11:28:31 AM
Event ID: 5239
Task Category: Web Front End
Level: Error
Keywords:
User: companySPFarmSvcAct
Computer: SPWFEServer02.company.com
Description:
There was an error in communicating with Excel Calculation Services
http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx exception: The remote server returned an error: (503) Server
Unavailable.
[Session:
User: companySPFarmSvcAct].
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
<System>
<Provider Name=”Microsoft-SharePoint Products-Excel Services Application” Guid=”{278E40D0-FDAA-4EB4-AB6B-9E0AD6BDBE79}” />
<EventID>5239</EventID>
<Version>14</Version>
<Level>2</Level>
<Task>8</Task>
<Opcode>0</Opcode>
<Keywords>0x8000000000000000</Keywords>
<TimeCreated SystemTime=”2014-12-15T17:28:31.611714800Z” />
<EventRecordID>502287</EventRecordID>
<Correlation />
<Execution ProcessID=”2068″ ThreadID=”8976″ />
<Channel>Application</Channel>
<Computer>SPWFEServer02.company.com</Computer>
<Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
</System>
<EventData>
<Data Name=”string0″>http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx</Data>
<Data Name=”string1″>The remote server returned an error: (503) Server Unavailable.</Data>
<Data Name=”string2″>
</Data>
<Data Name=”string3″>companySPFarmSvcAct</Data>
</EventData>
</Event>
Error 4:
Log Name: Application
Source: Microsoft-SharePoint Products-Excel Services Application
Date: 12/15/2014 11:28:31 AM
Event ID: 5231
Task Category: Web Front End
Level: Error
Keywords:
User: companySPFarmSvcAct
Computer: SPWFEServer02.company.com
Description:
Unable to reach Excel Calculation Services http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx.
[Session:
User: companySPFarmSvcAct]
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
<System>
<Provider Name=”Microsoft-SharePoint Products-Excel Services Application” Guid=”{278E40D0-FDAA-4EB4-AB6B-9E0AD6BDBE79}” />
<EventID>5231</EventID>
<Version>14</Version>
<Level>2</Level>
<Task>8</Task>
<Opcode>0</Opcode>
<Keywords>0x8000000000000000</Keywords>
<TimeCreated SystemTime=”2014-12-15T17:28:31.611714800Z” />
<EventRecordID>502286</EventRecordID>
<Correlation />
<Execution ProcessID=”2068″ ThreadID=”8976″ />
<Channel>Application</Channel>
<Computer>SPWFEServer02.company.com</Computer>
<Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
</System>
<EventData>
<Data Name=”string0″>http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx</Data>
<Data Name=”string1″>
</Data>
<Data Name=”string2″>companySPFarmSvcAct</Data>
</EventData>
</Event>
Resolution:
There are few different resolutions you can try. In my case mostly restarting the Excel Calculation Services resolved the issue.
1. Restart excel calculations services
2. Recycle app pool
3. Make sure the account running excel calculation service is not locked
4. Reboot the server
1. Restart excel calculations services
I stopped and started the Excel Calculation services from within SharePoint Central Administration on following servers in this order:
SPAppServer01 – App
SPAppServer02 – App
SPAppServer03 – App
To stop and then start the Excel Calculation Services follow steps:
1. Go to SharePoint Central Admin site
2. Click System Settings > Manage Servers in This Farm
3. Find the servers in the farm that are running ‘Excel Calculation Services’
4. Click on one server name from that list that is running the service. Start with Web Server (if one is running the service),
5. On next page titled ‘Services on Server: servername ‘ locate the ‘Excel Calculation Services’ and click stop under action column
 |
| SharePoint Excel Services Restart Excel Calculation Services in Central Admin |
6. Refresh the page after few seconds and make sure the service is in stopped status
7. Once the Service show stopped status, click on Start under action column to start the service
8. Refresh the page for few seconds to make sure the Excel Calculation Service shows Started under status column
9. Go back to the page under step 2 above and follow steps for next server
10. Test one Excel file on the Sharepoint site by opening it in browser
Instead of restarting the servers or performing doing IISReset, stopping and starting the Excel service helped resolve the issue. Due to farm serving other critical apps out of SharePoint, server reboot and IISReset were not an option.
References:
- Error communicating with Excel Services Application – Events 5231 5239 5240
- Stefan Johansson – http://www.stefanjohansson.org/2013/03/excel-services-unable-to-process-the-request-wait-a-few-minutes-and-try-performing-this-operation-again/
- Armgasys – http://blog.armgasys.com/?p=133
- SharePoint Unable to process the request
- Excel Unable to process the request
- error in communicating with Excel Calculation Services
- Excel Services Unable to process the request
- SharePoint farm Unable to process the request
- SharePoint Excel Services Gotchas
- SharePoint Excel Services issues
- SharePoint Excel Services remedies
- SharePoint Excel Services fixes
- Event Viewer Error 5231
- Event Viewer Error 5239
- Event Viewer Error 5240
- Event Viewer Error 2159
- Event ID 5231
- Event ID 5239
- Event ID 5240
- Event ID 2159
- Fix for Event Viewer Error 5231
- Fix for Event Viewer Error 5239
- Fix for Event Viewer Error 5240
- Fix for Event Viewer Error 2159