Symptom
An exception occurs when Analysis for Office tries to connect to the backend system.
In the traces of AO that can be recorded by following the instructions of SAP Note 2129389, the folowing entries can be found:
----------------------------
Caught exception while initializing RFC parameters: System.IO.FileNotFoundException: Could not load file or assembly 'pluginwrapper, Version=1.3.3.0, Culture=neutral, PublicKeyToken=8ede04ace7fbcb32' or one of its dependencies. The system cannot find the file specified.
File name: 'pluginwrapper, Version=1.3.3.0, Culture=neutral, PublicKeyToken=8ede04ace7fbcb32'
at Com.Sap.Cof.ConnectionService.BusinessWarehouse.BwConnectionManager.InitializeClientPassportHandler()
at Com.Sap.Cof.ConnectionService.BusinessWarehouse.BwConnection.InitNcoParameters(IAuthentication authentication)
...
Exception while connecting to BW with user XYZ: Com.Sap.Cof.Interfaces.Connection.ConnectionException: Could not load file or assembly 'pluginwrapper, Version=1.3.3.0, Culture=neutral, PublicKeyToken=8ede04ace7fbcb32' or one of its dependencies. The system cannot find the file specified. ---> System.IO.FileNotFoundException: Could not load file or assembly 'pluginwrapper, Version=1.3.3.0, Culture=neutral, PublicKeyToken=8ede04ace7fbcb32' or one of its dependencies. The system cannot find the file specified.
...
General .NET Exception [3329-c78f-d1]:
Could not load file or assembly 'pluginwrapper, Version=1.3.3.0, Culture=neutral, PublicKeyToken=8ede04ace7fbcb32' or one of its dependencies. The system cannot find the file specified.
----------------------------
Environment
SAP Analysis for Microsoft Office
Cause
The issue might be related to the pluginwrapper.dll installed in global assembly cache (GAC).
Resolution
- Make sure the latest version of Analysis Office is installed (refer to SAP Note 1518359). The latest version can be installed by following the instructions in section #2 of this Wiki page;
- Make sure to have the Windows tool gacutil installed. This tool is part of the Microsoft Windows SDK for your Windows version:
Win 10 - https://developer.microsoft.com/en-us/windows/downloads/windows-10-sdk - Open the Command Prompt as Administrator;
- Go to the installation folder of the Analysis Office plugin, where the pluginwrapper.dll of AO is located. The default folder is %PROGRAMFILES%\SAP BusinessObjects\Office AddIn\Plugins\AnalysisOffice);
- Install this pluginwrapper.dll with the command below:
gacutil /i pluginwrapper.dll - Start AO again and retest the scenario.
See Also
SAP Note 2694979 - "Mixed mode assembly" error in Analysis for Office
Keywords
3329-c78f-d1, pluginwrapper, 8ede04ace7fbcb32 , KBA , BI-RA-AO-XLA , Excel Addin , Problem