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.
