Troubleshooting PowerPivot on SharePoint

I recently had a battle with a SharePoint 2010 farm and PowerPivot. Customer reported “weird things are going on”, and that was an understatement. This blog post is a transcript of the errors and what I did to resolve them. I hope this helps someone else in the future.

First off, I checked the server’s status (Central Administration > Manage Servers in this Farm) and saw that an upgrade was available. I tackled the upgrade first.

Now that I know my farm is happier, I continued dealing with PowerPivot. First thing I did was go to the service application to view if it was even running properly. When I clicked on the service application I got a nice generic error, but the ULS logs told me more

03/30/2012 12:37:07.88 w3wp.exe (0x2B10) 0x23C4 SharePoint Server Logging Correlation Data xmnv Medium Result=Id=OpenWorkbookAccessDenied; Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: You do not have permissions to open this file. —> Microsoft.Office.Excel.Server.Host.HostFileException at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity) at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.CheckForPermissions(IClaimsIdentity claimsIdentity) at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.<>c__DisplayClass4.<TryExecuteWithUserContext>b__2() at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.WithEnsureClaimsIdentitySetOnThread(IClaimsIdentity claimsIdentity, MethodToRun action) at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.TryExecuteWithUserConte 6a104842-30b5-4ca9-b27a-e1f454312700
03/30/2012 12:37:07.88 w3wp.exe (0x2B10) 0x23C4 Excel Services Application Excel Calculation Services ech0 Medium ExcelService.PostProcessRequest: web method: OpenWorkbook, got exception Id=OpenWorkbookAccessDenied; Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: You do not have permissions to open this file. —> Microsoft.Office.Excel.Server.Host.HostFileException at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity) at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.CheckForPermissions(IClaimsIdentity claimsIdentity) at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.<>c__DisplayClass4.<TryExecuteWithUserContext>b__2() at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.WithEnsureClaimsIdentitySetOnThread(IClaimsIdentity claimsIdentity, MethodToRun action) at Microsoft.Office.E… 6a104842-30b5-4ca9-b27a-e1f454312700
03/30/2012 12:37:07.88* w3wp.exe (0x2B10) 0x23C4 Excel Services Application Excel Calculation Services ech0 Medium …xcel.Server.MossHost.MossHostHelperMethods.TryExecuteWithUserContext(IIdentity userIdentity, Action`1 method) at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.Init(Uri uri, Guid requestSiteId, IIdentity currentIdentity, IExcelServerDocumentContext documentContext, FileLoaderHostInfo& outFileLoaderHostInfo) at Microsoft.Office.Excel.Server.CalculationServer.SharePointFileLoader.Init(Uri uri, Guid requestSiteId, IExcelServerDocumentContext documentContext) — End of inner exception stack trace — at Microsoft.Office.Excel.Server.CalculationServer.SharePointFileLoader.Init(Uri uri, Guid requestSiteId, IExcelServerDocumentContext documentContext) at Microsoft.Office.Excel.Server.CalculationServer.FileLoader.CreateFromTrustedLocationAndInit(Uri uri, TrustedLoca… 6a104842-30b5-4ca9-b27a-e1f454312700
03/30/2012 12:37:07.88* w3wp.exe (0x2B10) 0x23C4 Excel Services Application Excel Calculation Services ech0 Medium …tion trustedLocationSettings, Guid requestSiteId, IExcelServerDocumentContext documentContext) at Microsoft.Office.Excel.Server.CalculationServer.BaseWorkbookManager.GetBaseWorkbookAndMarkUsedAsync(AsyncHandler`1 callback, Object userState, Request request, Uri uri, Boolean newWorkbook, Boolean useCollection, Boolean loadedOnDemand) at Microsoft.Office.Excel.Server.CalculationServer.Session.OpenWorkbookAsync(AsyncHandler`1 callback, Object userState, Request request, Uri url, Boolean loadedOnDemand) at Microsoft.Office.Excel.Server.CalculationServer.Operations.OpenWorkbookOperation.StartExecution() at Microsoft.Office.Excel.Server.CalculationServer.Operations.Operation.RunOperationAsync() at Microsoft.Office.Excel.Server.CalculationServer.Operations.OperationSite.Prepar… 6a104842-30b5-4ca9-b27a-e1f454312700
03/30/2012 12:37:07.88* w3wp.exe (0x2B10) 0x23C4 Excel Services Application Excel Calculation Services ech0 Medium …eComplete(PrepareAsyncArgs args) 6a104842-30b5-4ca9-b27a-e1f454312700
03/30/2012 12:37:07.88 w3wp.exe (0x2B10) 0x23C4 Excel Services Application Excel Calculation Services 2018 Information Failed to load ‘http://SHAREPOINT:25557/1033/Server%20Health.xlsx&#8217; with error: ‘Access is denied to the specified file.’. [Session: 1.V21.67MiloLbpn+Z+LMu/ertG90.5.en-US5.en-US73.+0300#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.c63405b0-88db-466c-a8d9-f2d11f672c6d1.N User: 0#.w|domain\sp_admin] 6a104842-30b5-4ca9-b27a-e1f454312700
03/30/2012 12:37:07.88 w3wp.exe (0x2B10) 0x23C4 Excel Services Application Excel Calculation Services ech8 Medium ExcelService.PostProcessRequest: Excel Server Recoverable Exception: Id=OpenWorkbookAccessDenied; Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: You do not have permissions to open this file. —> Microsoft.Office.Excel.Server.Host.HostFileException at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity) at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.CheckForPermissions(IClaimsIdentity claimsIdentity) at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.<>c__DisplayClass4.<TryExecuteWithUserContext>b__2() at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.WithEnsureClaimsIdentitySetOnThread(IClaimsIdentity claimsIdentity, MethodToRun action) at Microsoft.Office.Excel… 6a104842-30b5-4ca9-b27a-e1f454312700
03/30/2012 12:37:07.88* w3wp.exe (0x2B10) 0x23C4 Excel Services Application Excel Calculation Services ech8 Medium ….Server.MossHost.MossHostHelperMethods.TryExecuteWithUserContext(IIdentity userIdentity, Action`1 method) at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.Init(Uri uri, Guid requestSiteId, IIdentity currentIdentity, IExcelServerDocumentContext documentContext, FileLoaderHostInfo& outFileLoaderHostInfo) at Microsoft.Office.Excel.Server.CalculationServer.SharePointFileLoader.Init(Uri uri, Guid requestSiteId, IExcelServerDocumentContext documentContext) — End of inner exception stack trace — at Microsoft.Office.Excel.Server.CalculationServer.SharePointFileLoader.Init(Uri uri, Guid requestSiteId, IExcelServerDocumentContext documentContext) at Microsoft.Office.Excel.Server.CalculationServer.FileLoader.CreateFromTrustedLocationAndInit(Uri uri, TrustedLocation… 6a104842-30b5-4ca9-b27a-e1f454312700
03/30/2012 12:37:07.88* w3wp.exe (0x2B10) 0x23C4 Excel Services Application Excel Calculation Services ech8 Medium … trustedLocationSettings, Guid requestSiteId, IExcelServerDocumentContext documentContext) at Microsoft.Office.Excel.Server.CalculationServer.BaseWorkbookManager.GetBaseWorkbookAndMarkUsedAsync(AsyncHandler`1 callback, Object userState, Request request, Uri uri, Boolean newWorkbook, Boolean useCollection, Boolean loadedOnDemand) at Microsoft.Office.Excel.Server.CalculationServer.Session.OpenWorkbookAsync(AsyncHandler`1 callback, Object userState, Request request, Uri url, Boolean loadedOnDemand) at Microsoft.Office.Excel.Server.CalculationServer.Operations.OpenWorkbookOperation.StartExecution() at Microsoft.Office.Excel.Server.CalculationServer.Operations.Operation.RunOperationAsync() at Microsoft.Office.Excel.Server.CalculationServer.Operations.OperationSite.PrepareCom… 6a104842-30b5-4ca9-b27a-e1f454312700
03/30/2012 12:37:07.88* w3wp.exe (0x2B10) 0x23C4 Excel Services Application Excel Calculation Services ech8 Medium …plete(PrepareAsyncArgs args) 6a104842-30b5-4ca9-b27a-e1f454312700

I couldn’t find much on this error online so I went ahead and deleted the service application. I then tried to add a new one back but received another error

Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.GeminiCreate’

I wasn’t pleased to see this one. I checked the solutions (Central Admin > System Settings > Manage farm solution) and confirmed both powerpivotfarm.wsp and powerpivotwebapp.wsp were both deployed. I retracted both solutions and then repaired the SQL installation for POWERPIVOT instance (Control Panel > Programs and Features, select SQL Server. During the repair process, select the instance for POWERPIVOT).

I deployed the two solutions, and had to deploy the powerpivotwebapp.wsp a second time to include Central Admin. Tried to add the service application again and it worked.

I logged into the PowerPivot site and was able to open up files and use the PowerPivot functionality.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s