none
Unable to reach Excel Calculation Services

    Question

  • I have try everything from : http://sharepoint-community.net/profiles/blogs/excel-services-application-issues-sp-2010-2013

    There was an error in communicating with Excel Calculation Services http://portal1:32843/885a86d8efc7475bb7ca1d920626e293/ExcelService*.asmx exception: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. [Session:  User: home\SVCSP15AppPool].

    ExcelServerApp..ctor: An unhandled exception occurred during boot. Shutting down the server. Microsoft.Office.Excel.Server.CalculationServer.Interop.LoadDllException: Failed to load engine dll.Access is denied.       at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.LoadDll(EngineFlags engineFlags, String binPath, String muiPath, String ppPath, IRequestTelemetryEvents requestTelemetryEvents)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp.Initialize()     at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock) StackTrace:  at Microsoft.Office.Server.Native.dll: (sig=678c0f87-966f-4d99-9c94-b49e788d2672|2|microsoft.office.server.native.pdb, offset=131CE) at Microsoft.Office.Server.Native.dll: (offset=21BE5)

    Faulting application name: w3wp.exe, version: 8.5.9600.16384, time stamp: 0x5215df96
    Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
    Exception code: 0x80131623
    Fault offset: 0x00007ff85fe615d3
    Faulting process id: 0x8c8
    Faulting application start time: 0x01cfaa7cfb35c101
    Faulting application path: c:\windows\system32\inetsrv\w3wp.exe
    Faulting module path: unknown
    Report Id: 4042aab1-1670-11e4-80d3-00505695796f
    Faulting package full name: 
    Faulting package-relative application ID: 

    An internal error occurred.
       at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.LoadDll(EngineFlags engineFlags, String binPath, String muiPath, String ppPath, IRequestTelemetryEvents requestTelemetryEvents)
       at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp.Initialize()
       at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)


    BlatniS

    Monday, July 28, 2014 4:10 PM

Answers

  • Hi BlatniS ,

    According to your description, my understanding is that you encountered the error “The underlying connection was closed: A connection that was expected to be kept alive was closed by the server” when you try to use Excel Calculation Services.

    The error message “Microsoft.Office.Excel.Server.CalculationServer.Interop.LoadDllException: Failed to load engine dll. Access is denied.”  says that  loading engine DLL was access denied.  The issue was that the web site used for the SharePoint Web Services had the ASP.NET Impersonation Authentication method enabled. The solution is to disable the ASP.NET Impersonation again.

    Go to IIS Manager (Start, Administrative Tools, Internet Information Services (IIS) Manager). Expand the Sites node on the server running the Excel Services Service Application. Choose the Authentication icon in the IIS area. Choose ASP.NET Impersonation in the list and disable it using the action link on the right hand side.

    Reference: http://www.stefanjohansson.org/2013/03/excel-services-unable-to-process-the-request-wait-a-few-minutes-and-try-performing-this-operation-again/

    Best Regards,

    Eric


    Eric Tao
    TechNet Community Support

    • Marked as answer by Borut2009 Wednesday, July 30, 2014 2:23 PM
    Tuesday, July 29, 2014 2:58 AM

All replies

  • Hi BlatniS ,

    According to your description, my understanding is that you encountered the error “The underlying connection was closed: A connection that was expected to be kept alive was closed by the server” when you try to use Excel Calculation Services.

    The error message “Microsoft.Office.Excel.Server.CalculationServer.Interop.LoadDllException: Failed to load engine dll. Access is denied.”  says that  loading engine DLL was access denied.  The issue was that the web site used for the SharePoint Web Services had the ASP.NET Impersonation Authentication method enabled. The solution is to disable the ASP.NET Impersonation again.

    Go to IIS Manager (Start, Administrative Tools, Internet Information Services (IIS) Manager). Expand the Sites node on the server running the Excel Services Service Application. Choose the Authentication icon in the IIS area. Choose ASP.NET Impersonation in the list and disable it using the action link on the right hand side.

    Reference: http://www.stefanjohansson.org/2013/03/excel-services-unable-to-process-the-request-wait-a-few-minutes-and-try-performing-this-operation-again/

    Best Regards,

    Eric


    Eric Tao
    TechNet Community Support

    • Marked as answer by Borut2009 Wednesday, July 30, 2014 2:23 PM
    Tuesday, July 29, 2014 2:58 AM
  • Hi Eric,

    THX. I forget to do IIS reset. Now it works.  It look like everything is ok,  except I can not deploy site colection for enterprise search…. But  original problem is fixed.

    Best regard BlatniS


    BlatniS

    Tuesday, July 29, 2014 8:27 AM
  • Thanks - finally working!!!!
    Monday, April 04, 2016 8:12 PM