When
importing KPIs as part of creating score cards in PPS designer 2013, we may get
following error
An unexpected error occurred. Error 47205
For SQL Server 2012
For SQL Server 2014
An unexpected error occurred. Error 47205
Following is
the event log entryException details:
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
at Microsoft.PerformancePoint.Scorecards.Server.ImportExportHelper.GetImportableAsKpis(DataSource asDataSource)
at Microsoft.PerformancePoint.Scorecards.Server.PmServer.GetImportableAsKpis(DataSource dataSource)
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
at Microsoft.PerformancePoint.Scorecards.Server.ImportExportHelper.GetImportableAsKpis(DataSource asDataSource)
at Microsoft.PerformancePoint.Scorecards.Server.PmServer.GetImportableAsKpis(DataSource dataSource)
Strangely GAC has
this assembly….
But the answer is
we should install analysis Management
objects (AMO ) package. NOT the ADOMD.net
The AnalysisServices.DLL will not be installed as part of AMDO.Net installation. Hence, we
should install AMO package. Please mind that when you download the AMO package
based on you SQL server version like 2008 R2, 2012, 2014.
For SQL Server 2008 R2
Click ‘Install
Instructions’ and search for ‘AMO’For SQL Server 2012
Click ‘Install
Instructions’ and search for ‘AMO’
Click ‘Install
Instructions’ and search for ‘AMO’
After
installing the AMP package, you can see AnalysisServices.DLL
in GAC..
Note: Install the respective package in all SharePoint web front
end servers and reset IIS
Cheers!
Mohan
No comments:
Post a Comment