PowerPivot FileNotFoundException issue
A FileNotFoundException error message keeps appearing during SPDocKit Consultant's snapshot process.
During the snapshot process, the following error can be observed either in the Snapshot Wizard or the event log:
System.IO.FileLoadException: Could not load file or assembly ‘Microsoft.AnalysisServices.SPAddin, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)…`
Application version: All versions
Make sure that you take a snapshot on a server where “PowerPivot for SharePoint Add-in” is installed.
If the error still occurs, please do the following:
- 1.Determine the correct major version [MajorVersion] of “PowerPivot for SharePoint Add-in”. You can do this by viewing the installed programs list and locating Microsoft SQL Server PowerPivot for SharePoint.
- 2.After you have the correct version, open the SPDocKitSnapshotWizard.exe.config file. It is located in the folder together with the .exe file.
- 3.Inside the runtime tag, add the following as a child node and save the file:<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"><dependentAssembly><assemblyIdentity name="Microsoft.AnalysisServices.SPAddin" publicKeyToken="89845DCD8080CC91" culture="neutral" /><bindingRedirect oldVersion="0.0.0.0-[MajorVersion].0.0.0" newVersion="[MajorVersion].0.0.0" /></dependentAssembly></assemblyBinding>
- 4.Restart the wizard.
Please note! This is only possible if you are using the SPDocKit Snapshot Wizard - Consultant to perform the load. If you are using the PowerShell Module, unfortunately there is no workaround.