I’ve seen this issue twice on production systems now, and have a solution that has worked in both cases. From http://technet.microsoft.com/en-us/library/ee513104.aspx
Symptoms: One or more of the following symptoms might appear:
- Delayed load times for workbooks.
- Workbooks fail to load.
- 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>].
- This event appears in the event log: Event ID: 5239 Description: There was an error in communicating with Excel Calculation Server <URL of machine> exception: <exception message> [Session: <session ID> User: <username>].
- This event appears in the event log: Event ID: 5240 Description: There was an error in communicating with Excel Calculation Server <URL of machine> exception: <exception message> [Session: <session ID> User: <username>].
The Technet article somewhat unhelpfully suggests a reboot. I’ve tried that and it works for a while then fails again. However I have found the following to be effective:
- Log on to the SharePoint server(s) using the service account that is running the Excel Services Service Application
- Log off
It seems that this creates a user profile for the service application account, which fixed the problem for me straight away, without a reboot.
0 Responses to “Error communicating with Excel Services Application – Events 5231 5239 5240 (SharePoint Server 2010)”