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

3 comments:

  1. Nice Posting Amol

    ReplyDelete
  2. http://practicalguidetosharepoint.com

    A PRACTICAL GUIDE TO SHAREPOINT

    Learn SharePoint using this practical guide! This is a complete practical guide. It’s full of useful tips and exercises to get you started in no time! It has no fluff, just practical exercises that will provide you the knowledge and know-how to implement SharePoint solutions easily and professionally. SharePoint has a steep learning curve. Without a book like this in your hands, it will probably take you months to learn SharePoint. Learn from others experiences. You don’t have to take the pain to learn SharePoint on your own. Learn from the experts! Make good use of your time! This book has everything that you need to equip yourself to work professionally on SharePoint projects. Regardless if you are a seasoned professional or a beginner willing to learn SharePoint, this book has it all.

    User level: Intermediate - Advanced
    ISBN-13: 978-0-9915203-0-5
    ISBN-10: 0991520300
    Library of Congress Control Number: 2014902311
    Copyright:©2014 Saifullah Shafiq
    Language: English
    Country: United States
    Published by: Wali Systems, Inc.
    Publication Date: Feb 06, 2014

    Page Count: 378 pages
    Size: Crown Quarto (7.44 x 9.68 in)
    Binding: Perfect bound
    Price (Paperback): $23.95

    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.