Excel Services: First time opening an excel file gives error

Hi all,

When we open any excel file for the first time that day, we have the error:

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

When we wait a few minutes, the excel file, and any other excel file in the same web application, opens without a problem. Excel files in other web applications still have the error until they also wait a few minutes after their first attempt of the day.

In the ULS-logs I find this message:

Result=Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession+RetryException: RetryException ---> Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSessionException: Unable to process the request. ---> System.Net.WebException: The remote server returned an error: (503) Server Unavailable.    
 at System.Net.HttpWebRequest.GetResponse()    
 at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)     -
 -- End of inner exception stack trace ---     -
 -- End of inner exception stack trace ---    
 at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.ExecuteWebMethodCore(WebMethodType webMethodType, WebMethodBehaviorAttribute webMethodBehavior, CommandParameter parameter, CoreWebMethod coreWebMe


Is there anyone who had the same problem and managed to solve this problem? Should we consider some sort of Wake-up script?

Any help would be appreciated. 

Kind regards,
Frederik

September 10th, 2015 3:07am

Hi,

From the error message, I searched form the internet, the issue may be resulted form that the web site used for the SharePoint Web Services had the ASP.NET Impersonation Authentication method enabled.

Try to disable the ASP.NET Impersonation again.

Open up the  IIS Manager on the SharePoint server

  1. Expand Sites.
  2. Expand  SharePoint Web Services and select Excel Services Application(you can choose Excel  Services Application from the id: CA->Application Management->Manage service application->Click Excel Services Service  Application->you can find the id from the URL).
  3. Double click on Authentication(under IIS).
  4. Disable ASP.NET impersonation.
  5. IISRESET.

For more detailed information, refer to the following article:

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

Besides, here is a similar issue article, you can take a look at:

http://sharepointfarmer.com/excel-services-is-unable-to-process-the-request-wait-a-few-minutes-and-try-performing-this-operation-again/

Best Regards

Lisa Chen

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 3:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics