While working with a user yesterday, i have noticed that users could not view Excel files in browser and getting the below mentioned error message:
Error Message:
An error has occurred.
Please contact your system administrator if this problem persists.
ULS Logs shows the following entry:
There was an error in communicating with Excel Calculation Services http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized.
Checked the event viewer and found the following:
Event Viewer entries:
Event Type: Error
Event Source: Office SharePoint Server
Event Category: Excel Services Web Front End
Event ID: 5234
Date: 12/7/2012
Time: 2:50:06 PM
User: N/A
Computer: XXX
Description:
No Excel Calculation Services is available in the farm.[User:
SHAREPOINT\system]
Event Type: Error
Event Source: Office SharePoint Server
Event Category: Excel Services Web Front End
Event ID: 5239
Date: 12/7/2012
Time: 2:50:06 PM
User: N/A
Computer: XXX
Description:
There was an error in communicating with Excel Calculation Services
http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx
exception: Unable to connect to the remote server
[Session: (null)
User: SHAREPOINT\system].
Troubleshooting Done:
1-checked this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/8bba2694-7276-4505-85a5-02f91b92bb1d which states that find the ssp which is giving the problem and recycle the app pool to which the ssp is referrencing.
2-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/321cb536-39d6-4ee9-b9ef-65db9e133d97but cannot apply this resolution as in my case the excel services are running fine for other portals and not working for only one web application.
3-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/5968cb82-2e65-44c0-bfa8-ce05d70154ff this article has mentioned 3 fixes which will varies from the farm to farm i.e. enviornment to enviornment.
4-Checked alternate access mappings as per this article:http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/c0c59a6a-1cf6-4280-a2ca-9667b2cadd33/ but AAM seetings are fine in our enviornment.
5-Ran this below mentioned commands but no results:
stsadm -o setsharedwebserviceauthn -negotiate
stsadm -o execadmsvcjobs
6-checked SSP pool account is running or not as per this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/85310dd3-a7e7-4673-b258-b0fec7823b8d but it is fine and no problems
7-excel services are running or not is already checked: http://njbblog.blogspot.com/2008/04/sharepoint-v3-error-excel-services.html
Resolution that fix our issue:
If you get this problem the solution in my case was to by pass the proxy for local requests, this was done by editting the web.config for the relevant web app & adding:
<system.net>
<defaultProxy>
<proxy proxyaddress="http://<ProxyServer>:<port>" bypassonlocal = "true"/>
</defaultProxy>
</system.net>
------------------------------------------
what we have added in this: bypassonlocal = "true"
Issue has been resolved and excel services started working without any issues, Thank you
If you have any queries/questions regarding the above mentioned information then please let me know.
I would be more than happy to help you as well as resolves your issues, Thanks
