If there is any error trying to load the bubble chart data for the dashboard, instead of getting a page load failure, the bubble chart simply displays a red X. Whenever you get a red X in the bubble chart there will be an associated log entry in the ULS log on the machine running the Central Admin site. It will look something like this:
SSAS Mid-Tier Service Administration 106 High Error loading history for workbook history bubble chart
SSAS Mid-Tier Service Administration 99 High EXCEPTION: Microsoft.AnalysisServices.AdomdClient.AdomdUnknownResponseException: Unsupported data format : application/vnd.ms-excel.12
at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseDataType()
at Microsoft.AnalysisServices.AdomdClient.CompressedStream.GetResponseDataType()
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest()
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Discover(String requestType, String requestNamespace, ListDictionary properties, IDictionary restrictions, Boolean sendNamespacesCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, Boolean sendNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ReadDataSourceInfo()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.AnalysisServices.SharePoint.Integration.WorkbookHistoryDataProvider.GetHistory(WorkbookHistoryDataSet& historyDataSet)
at Microsoft.AnalysisServices.SharePoint.Integration.WebServices.PowerPivotOperationsServiceImpl.GetWorkbookHistory(WorkbookHistoryDataSet& history) 1118bdcb-bf75-4f0d-b560-ede92ed25d1b
The key string that you are looking for is “Error loading history for workbook history bubble chart”. The exception causing the error should immediately follow that entry for logging on that thread and should hopefully give you some indication as to why the chart didn’t load (it is what I look at). In the majority of cases I have seen, the issue is simply not having the latest version of the ADOMD.Net client library and all you need to do is upgrade your version of the library to that of SQL Server 2008 R2 and the error will go away. Our code is actually meant to provide a user friendly error when SQL Server 2008 R2 Analaysis Services ADOMD.Net library is not installed on the server hosting SharePoint’s Central Administration site. However, as of the most recent RC build (and so most probably the RTM build), SharePoint is installing ADOMD.Net from an earlier version of SQL Server and so this user friendly error is not always coming through and users might simply get a red X. To know if that is what you are hitting, you can either look in the Control Panel’s Programs List and see if the SQL Server 2008 R2 Analysis Services ADOMD.Net library is installed (look for a version number of 10.50.XXXX.X … I don’t know what the final RTM version will be) or you can look in the ULS log. The above (cryptic) example is what you will see if you have an older version of Analysis Services ADOMD.Net client library installed on your machine. If you have installed PowerPivot for SharePoint on the same machine as Central Admin, then we will have automatically installed the latest bits of ADOMD.Net and so this would not be the root issue.
I am not sure what other errors would be “expected” misconfigurations, but as I(we) find them I will try to add them. HTH
Lee
This looks like another configuration issue here.
I got the dreaded red X too. In my case it was a Locale issue due to the date format here (dd/mm/yy). The ULS file had this entry:
EXCEPTION: System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value) at Microsoft.AnalysisServices.SharePoint.Integration.WorkbookHistoryDataProvider.GetHistory(WorkbookHistoryDataSet& historyDataSet) at Microsoft.AnalysisServices.SharePoint.Integration.WebServices.PowerPivotOperationsServiceImpl.GetWorkbookHistory(WorkbookHistoryDataSet& history)
I’m also having this problem. I do see the “loading history for workbook history bubble chart” error, and when I check installed programs, I see Microsoft SQL Server 2008 Analysis Services ADOMD.NET version 10.0.1600.60 installed.
I downloaded what looks like the latest version from http://www.microsoft.com/downloads/details.aspx?familyid=CEB4346F-657F-4D28-83F5-AAE0C5C83D52&displaylang=en and this installed version 10.1.2531.0, which hasn’t fixed the problem.
Any other ideas, or where can I find version 10.50.x?
SharePoint and SQL Services are installed on the same box by the way.
Aaron: If this is the RTM version of PowerPivot for SharePoint, another possibility is that you don’t have any data yet to review. Give the system a day or so, or manually configure it to collect the usage data more often than daily and the control may start working. There is a knwown bug that it cannot render data (and thus the Red X) until there is data to render and the default Usage systemm timer jobs are configured to run daily. If you want to poke around my blog, you will see that I published a “how to configure Usage to run more often than daily” that might help, but by the time you read this, your 24 hr window may already be passed
Hope this helps.
[...] Read more… [...]