Error with PowerPivot Management Dashboard

7/22/2011: This issue is resolved in SQL Server 2008 R2 SP1 (applied to the PowerPivot instance on SharePoint).

I have an ongoing issue where the PowerPivot Management Dashboard in the Silverlight control just displays a Red X, and the Activity List is blank, no matter how many PowerPivot-enabled workbooks you interact with. When viewing the Management Dashboard, the following error in the ULS log is present:

03/24/2011 14:18:57.16 w3wp.exe (0x0DFC) 0x0598 SSAS Mid-Tier Service Request Processing 106 High Error loading history for workbook history bubble chart eb9fce20-5fa7-4395-b7c5-03a79648e8cf

03/24/2011 14:18:57.16 w3wp.exe (0x0DFC) 0x0598 SSAS Mid-Tier Service Request Processing 99 High EXCEPTION: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.AnalysisServices.AdomdClient.AdomdDataReader.GetString(Int32 ordinal) at Microsoft.AnalysisServices.SharePoint.Integration.WorkbookHistoryDataProvider.GetHistory(WorkbookHistoryDataSet& historyDataSet) at Microsoft.AnalysisServices.SharePoint.Integration.WebServices.PowerPivotOperationsServiceImpl.GetWorkbookHistory(WorkbookHistoryDataSet& history) eb9fce20-5fa7-4395-b7c5-03a79648e8cf

In speaking with MS PSS, they let me know that this is an issue if you installed any SharePoint Cumulative Updates prior to installing PowerPivot. If you install SharePoint RTM, then PowerPivot, then any updates, this error will not appear. PSS is working with development and product managers to resolve the issue (namely being certain tables in the Usage database do not contain primary keys).

Trevor Seward is a Microsoft Office Apps and Services MVP who specializes in SharePoint Server administration, hybrid scenarios, and SharePoint Online. He has been working with SharePoint for 16 years from SharePoint 2003 on up, managing environments with terabytes of content for 150,000+ user organizations. Trevor is an author of Deploying SharePoint 2016 and Deploying SharePoint 2019. You can find him on Twitter and in /r/sharepoint.