Showing posts with label An error has occurred. Please contact your system administrator if this problem persists. ; Event ID-5239. Show all posts
Showing posts with label An error has occurred. Please contact your system administrator if this problem persists. ; Event ID-5239. Show all posts

08 December, 2011

An error has occurred. Please contact your system administrator if this problem persists.

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