Saturday, November 16, 2013
Error communicating with Excel Services Application - Event ids 5231 5239 5240
SharePoint monitoring is very necessary and should be done on regular basis as it will give complete idea about any exceptions/errors/if any services are /if any servers are not responding etc. so while monitoring the servers, I came these following errors in viewer-
Event 5239 (Excel Services Application) of severity 'Error' occurred 10 more time(s) and was suppressed in the event log
Event 5231 (Excel Services Application) of severity 'Error' occurred 10 more time(s) and was suppressed in the event log
To verify this, I tried opening excel dashboards on each servers (WFE’s) to find out which server is the culprit. Before doing this, make sure that excel service application is in started mode as well as app pool is running.
Coming back to dashboard point, you will find the culprit server. Just that specific server and check the results. In my case, it fixed and reference is as below:
The above article will be indeed helpful in many scenarios as-
1. Delayed load times for workbooks.
2. Workbooks fail to load.
3. This event appears in the event log: Event ID: 5231 Description:
[Session: to reach Excel Server User: ]
1) Restart excel services
2) Recycle app pool
3) Make sure that you are using for excel calculation service is working properly i.e. not locked!
4) Reboot the server
I hope the above info is helpful and will give some to resolve the issue.
If you have any queries/issues regarding the above mentioned information then please let me know, Thank you.
Location: Birmingham, West Midlands, UK