Monthly Archives: March 2013

Migrating to TFS, Team Foundation Service

As part of the Easter holiday time abundance I am migrating some projects to the TFS service at http://tfs.visualstudio.com/. This is part of the evaluation to see if it works for some of the more complex scenarios we face when developing BI solutions.

Once a project is created the following message greets the creator:

“Your project is created and your team is going to absolutely love this.”

BIFrameworkprojectcreated

So at least we are off to a good start.

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.

image

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

image

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:

image

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.

image

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

Continue reading