PowerPivotGeek?

Who is this mystery man?
Click on the icon to find out. Who is powerpivotgeek?

Archives

Dashboard Bubble Chart Shows a Red X (fails to load)

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

  • Share/Bookmark

4 comments to Dashboard Bubble Chart Shows a Red X (fails to load)

  • Bob Duffy

    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)

  • Aaron

    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.

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>