Excel Services: Unable to process the request. Wait a few minutes and try performing this operation again.

Error

This error message appeared in a SharePoint 2010 farm/environment when trying to use Excel Services to display a Excel spreadsheet in SharePoint 2010.

Screenshot in English: Excel. Unable to process the request. Wait a few minutes and try performing this operation again.

Screenshot in Swedish: Excel. Det går inte att behandla begäran. Vänta några minuter innan du försöker utföra den här åtgärden igen.

After reviewing the Events and log files and finding error messages such as theese:

Event Viewer: Event 5239, Excel Services Application. There was an error in communicating with Excel Calculation Service (server address on port 32843, standard port for web services address ending with /ExcelService*.asmx) exception: The underlying connection was closed: An unexpected error occurred on a receive.

Issue

The issue was that the web site used for the SharePoint Web Services had the ASP.NET Impersonation Authentication method enabled.

Solution

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.

Screenshot: IIS Manager, Authentication settings for the SharePoint Web Services.

More errors from the SharePoint logs

Might help folks searching

03/09/2013 19:29:43.48     w3wp.exe (0x1A28)                           0x1868    Excel Services Application        Excel Calculation Services        5229    Information    Excel Services Application service is starting.    cf5ec594-acae-442b-845f-073ddf637e30
03/09/2013 19:29:43.49     w3wp.exe (0x1A28)                           0x1868    Excel Services Application        Excel Calculation Services        3sle    Medium      ExcelServerApp.Initialize(): Excel Server belonging to SSP Excel Services Service Application was initialized with AccessModel: Claims    cf5ec594-acae-442b-845f-073ddf637e30
03/09/2013 19:29:43.49     w3wp.exe (0x1A28)                           0x1868    Excel Services Application        Excel Calculation Services        5ox6    Medium      ExcelServerApp.ClearTempPath: The Ecs temp path is set to: C:WindowsTEMPExcel ServerFileCachefc338153-e33b-476b-86a9-6d5119953b33    cf5ec594-acae-442b-845f-073ddf637e30
03/09/2013 19:29:43.49     w3wp.exe (0x1A28)                           0x1868    Excel Services Application        Excel Calculation Services        5ox7    Medium      ExcelServerApp.ClearTempPath: An Ecs temp path already exists, attempting to delete it.    cf5ec594-acae-442b-845f-073ddf637e30
03/09/2013 19:29:43.50     w3wp.exe (0x1A28)                           0x1868    Excel Services Application        Excel Calculation Services        5ox8    High        ExcelServerApp.ClearTempPath: Failed to delete existing temp path. Exception: System.IO.IOException: Access to the path ‘C:WindowsTEMPExcel ServerFileCachefc338153-e33b-476b-86a9-6d5119953b33Images’ is denied.     at System.IO.Directory.DeleteHelper(String fullPath, String userPath, Boolean recursive)     at System.IO.Directory.Delete(String fullPath, String userPath, Boolean recursive)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp.ClearTempPath()    cf5ec594-acae-442b-845f-073ddf637e30
03/09/2013 19:29:43.87     w3wp.exe (0x0D18)                           0x19C0    SharePoint Portal Server          Runtime                           8gp7    Medium      Topology cache updated. (AppDomain: /LM/W3SVC/159103254/ROOT-1-130073271066577798)
03/09/2013 19:29:44.13     w3wp.exe (0x1A28)                           0x1868    Excel Services Application        Excel Calculation Services        qwdq    Medium      EngineInterop::LoadDll: Failed to load our engine (xlsrv.dll). GetLastError: 126    cf5ec594-acae-442b-845f-073ddf637e30
03/09/2013 19:29:44.13     w3wp.exe (0x1A28)                           0x1868    Excel Services Application        Excel Calculation Services        qwdx    Unexpected    EngineInterop::LoadDll: Failed to load our engine (xlsrvol.dll). GetLastError: 126    cf5ec594-acae-442b-845f-073ddf637e30
03/09/2013 19:29:44.16     w3wp.exe (0x1A28)                           0x1868    Excel Services Application        Excel Calculation Services        89rs    Exception    ExcelServerApp..ctor: An unhandled exception occurred during boot. Shutting down the server. Microsoft.Office.Excel.Server.CalculationServer.Interop.LoadDllException: Failed to load engine dll.The specified module could not be found.       at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.LoadDll(EngineFlags engineFlags, String binPath, String muiPath)     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)    cf5ec594-acae-442b-845f-073ddf637e30
03/09/2013 19:29:44.16     w3wp.exe (0x1A28)                           0x1868    SharePoint Server                 Unified Logging Service           c91s    Monitorable    Watson bucket parameters: SharePoint Server 2010, ULSException14, 5f9be61a “excel services application”, 0e00178d “14.0.6029.0”, 69f888f4 “microsoft.office.excel.server.calculationserver.interop”, 0e00177f “14.0.6015.0”, 4d10e600 “tue dec 21 18:38:08 2010”, 00000323 “00000323”, 00000012 “00000012”, 46bf6b31 “loaddllexception”, 38397273 “89rs”    cf5ec594-acae-442b-845f-073ddf637e30
03/09/2013 19:29:44.17     w3wp.exe (0x1A28)                           0x1868    Excel Services Application        Excel Calculation Services        7c4s    Unexpected    HandleShutdown: Initiating shutdown sequence – if there’s enough memory, the logs will now contain information about what went wrong.    cf5ec594-acae-442b-845f-073ddf637e30
w3wp.exe (0x1A28)                           0x1868    Excel Services Application        Excel Calculation Services        7c4t    Unexpected    HandleShutdown: Shutdown was initiated due to an error. Exception was: Microsoft.Office.Excel.Server.CalculationServer.Interop.LoadDllException: Failed to load engine dll.The specified module could not be found.       at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.LoadDll(EngineFlags engineFlags, String binPath, String muiPath)     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)    HandleShutdown: HandleShutdown was called from:    at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp.<.ctor>b__1(Exception e)     at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)     at Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag(UInt32 tagID, ULSCatBase categoryID, String output, Boolean fRethrowException, TryBlock tryBlock, CatchBlock catchBlock, FinallyBlock finallyBlock)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp..ctor()     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp..cctor()     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.SafeSetContext(…    at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.BeginProcessOperation(CommandParameter parameter, WebMethodBehaviorAttribute webMethodBehavior, WebMethodType webMethodType, AsyncCallback callback, Object state, UserOperation operation)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.BeginGetHealthScore(AsyncCallback callback, Object asyncState)     at AsyncInvokeBeginBeginGetHealthScore(Object , Object[] , AsyncCallback , Object )     at System.ServiceModel.Dispatcher.AsyncMethodInvoker.InvokeBegin(Object instance, Object[] inputs, AsyncCallback callback, Object state)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceHostFactory.OperationInvokerExceptionWrapper.InvokeBegin(Object instance, Object[] inputs, AsyncCallback callback, Object state)     at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)     at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)     at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)     at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)     at System.ServiceModel.Dispatcher.ChannelHandler.DispatchAndReleasePump(RequestContext request, Boolean cleanThread, OperationContext currentOperationContext)     at System.ServiceModel.Dispatcher.ChannelHandler.HandleRequest(RequestContext request, OperationContext currentOperationContext)     at System.ServiceModel.Dispatcher.ChannelHandler.AsyncMessagePump(IAsyncResult result)     at System.Servi…    …ceModel.Diagnostics.Utility.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)     at System.ServiceModel.AsyncResult.Complete(Boolean completedSynchronously)     at System.ServiceModel.Channels.SecurityChannelListener`1.ReceiveItemAndVerifySecurityAsyncResult`2.InnerTryReceiveCompletedCallback(IAsyncResult result)     at System.ServiceModel.Diagnostics.Utility.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)     at System.ServiceModel.AsyncResult.Complete(Boolean completedSynchronously)     at System.ServiceModel.Channels.InputQueue`1.AsyncQueueReader.Set(Item item)     at System.ServiceModel.Channels.InputQueue`1.EnqueueAndDispatch(Item item, Boolean canDispatchOnThisThread)     at System.ServiceModel.Channels.InputQueue`1.EnqueueAndDispatch(T item, ItemDequeuedCallback deque…    …uedCallback, Boolean canDispatchOnThisThread)     at System.ServiceModel.Channels.InputQueueChannel`1.EnqueueAndDispatch(TDisposable item, ItemDequeuedCallback dequeuedCallback, Boolean canDispatchOnThisThread)     at System.ServiceModel.Channels.SingletonChannelAcceptor`3.Enqueue(QueueItemType item, ItemDequeuedCallback dequeuedCallback, Boolean canDispatchOnThisThread)     at System.ServiceModel.Channels.SingletonChannelAcceptor`3.Enqueue(QueueItemType item, ItemDequeuedCallback dequeuedCallback)     at System.ServiceModel.Channels.HttpChannelListener.HttpContextReceived(HttpRequestContext context, ItemDequeuedCallback callback)     at System.ServiceModel.Activation.HostedHttpTransportManager.HttpContextReceived(HostedHttpRequestAsyncResult result)     at System.ServiceModel.Activation.H…    Unexpected    …ostedHttpRequestAsyncResult.BeginRequest()     at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.OnBeginRequest(Object state)     at System.ServiceModel.PartialTrustHelpers.PartialTrustInvoke(ContextCallback callback, Object state)     at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.OnBeginRequestWithFlow(Object state)     at System.ServiceModel.Channels.IOThreadScheduler.CriticalHelper.WorkItem.Invoke2()     at System.ServiceModel.Channels.IOThreadScheduler.CriticalHelper.WorkItem.Invoke()     at System.ServiceModel.Channels.IOThreadScheduler.CriticalHelper.ProcessCallbacks()     at System.ServiceModel.Channels.IOThreadScheduler.CriticalHelper.CompletionCallback(Object state)     at System.ServiceModel.Channels.IOThreadScheduler.CriticalHelper.ScheduledOverlapp…    …ed.IOCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)     at System.ServiceModel.Diagnostics.Utility.IOCompletionThunk.UnhandledExceptionFrame(UInt32 error, UInt32 bytesRead, NativeOverlapped* nativeOverlapped)     at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)

03/09/2013 19:29:44.18 w3wp.exe (0x1A28) 0x1868 Excel Services Application Excel Calculation Services 2026 Warning An internal error occurred. at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.LoadDll(EngineFlags engineFlags, String binPath, String muiPath) 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) cf5ec594-acae-442b-845f-073ddf637e30

And

03/09/2013 19:31:42.34     w3wp.exe (0x0D18)                           0x19C0    Excel Services Application        Web Front End                     g0pd    Medium      ServerSession.GetHealthScoreCallback: Failed to get health score for server http://sp:32843/a9fbf9a5b4bb404981c7bcb2c901a01b/ExcelService*.asmx [id: fc338153-e33b-476b-86a9-6d5119953b33] due to the connection timing out. Exception: System.TimeoutException: The request channel timed out while waiting for a reply after 00:00:19.9980468. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout. —> System.TimeoutException: The HTTP request to ‘http://sp:32843/a9fbf9a5b4bb404981c7bcb2c901a01b/ExcelService.asmx’ has exceeded the allotted timeout of 00:00:20. The time allotted to this operation may have been a portion of a longer timeout. —> System.Net.WebException…
03/09/2013 19:31:42.34*    w3wp.exe (0x0D18)                           0x19C0    Excel Services Application        Web Front End                     g0pd    Medium      …: The operation has timed out     at System.Net.HttpWebRequest.GetResponse()     at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)     — End of inner exception stack trace —     at System.ServiceModel.Channels.HttpChannelUtilities.ProcessGetResponseWebException(WebException webException, HttpWebRequest request, HttpAbortReason abortReason)     at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)     at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)     — End of inner exception stack trace —    Server stack trace:      at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout) …
03/09/2013 19:31:42.34*    w3wp.exe (0x0D18)                           0x19C0    Excel Services Application        Web Front End                     g0pd    Medium      …   at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.Request(Message message, TimeSpan timeout)     at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)     at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)     at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)     at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)    Exception rethrown at [0]:      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)     at System.Runtime.Remoting.Proxies.RealProxy.Private…
03/09/2013 19:31:42.34*    w3wp.exe (0x0D18)                           0x19C0    Excel Services Application        Web Front End                     g0pd    Medium      …Invoke(MessageData& msgData, Int32 type)     at Microsoft.Office.Excel.Server.CalculationServer.Proxy.IExcelServiceSoap.GetHealthScore()     at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.GetServerHealthScore()     at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.<>c__DisplayClass17d.<ExecuteWithSecurityContext>b__17c()     at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.ExecuteWithSecurityContext(Boolean forceRevert, CoreWebMethod coreWebMethod, CommandParameter parameter)     at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.GetHealthScoreCallback(Object state)

And