Tuesday, January 22, 2013

Fresh SharePoint 2013: Performance Point Error: System.IO.FileNotFoundException: 'Microsoft.AnalysisServices.AdomdClient,

If you've recently created a SharePoint 2013 Virtual machine that's an all in one image, you may have looked through your log files to find a critical error with Performance Point. The error looks like this:

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

This has to do with Central Administration being loaded on the Web Front End as explained by Microsoft:

If you install PowerPivot for SharePoint into a farm that has this topology (Central Administration, without Excel Services or PowerPivot for SharePoint), you must download and install the Microsoft ADOMD.NET client library if you want full access to the built-in reports in the PowerPivot management dashboard. Some reports in the dashboard use ADOMD.NET to access internal data that provides reporting data on PowerPivot query processing and server health in the farm.
Reference: http://msdn.microsoft.com/en-us/library/ee637433.aspx

To fix the issue, simply go to the SQL Server 2012 Feature Pack Page (assuming you're running 2012) and download/install the Microsoft® SQL Server® 2012 ADOMD.NET package

No comments: