19 November, 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 not running/if any servers are not responding etc. so while monitoring the servers, I came these following errors in the event 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 restart that specific server and check the results. In my case, it fixed the issue 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: Unable to reach Excel Calculation Server <URL of machine> [Session: <session ID> User: <username>]

Possible resolutions-
1)   Restart excel calculations services
2)   Recycle app pool
3)   Make sure that the account 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 directions to resolve the issue.

If you have any queries/issues regarding the above mentioned information then please let me know, Thank you.

2 comments:

  1. "Possible Resolutions" - works for me! Thanks.

    ReplyDelete
  2. I had a similar issue, the fix I found was to check the App Pool, and restart it.
    Thanks.

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.