Brian Shaw - Tuesday, April 10, 2018 7:27 AM
There is a bug, it will probably be corrected in SP2 CU1 which I've been told will be released at the end of the month.
We got a workaround suggestion from MS, but that was not enough.
Inshort: The providedworkaround does not work as is, but I found out what more to do so now itworks on the server with SP2
Longer: The provided workaround does notwork as is because it does register the correct assembly and the correctversion (v14), but when the package is run it will still search for theprevious version v13.
I have tested and this is the case even if I have SP2 on my laptop, rebuild allin the SSIS project and deply – it will still be v13 that is search for.
It does not help to register v13 of the assembly, since that version does nothave a method that is called, so that will just lead to other error messages.
Theresolution I made on the server is to put in a binding redirect in the .NETmachine.config so that v14 is used even thoug v13 is searched for.
Step-by-stepI did, run from an elevated CMD:
1: Register the assembly:
"C:\Program Files (x86)\MicrosoftSDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools\x64\gacutil.exe" /i"C:\Program Files (x86)\Microsoft Visual Studio14.0\Common7\IDE\PrivateAssemblies\Microsoft.AnalysisServices.AdomdClientUI.dll"
You shouldget message one assembly successfully registered in GAC.
2: (Optional) Verify registration:
"C:\Program Files (x86)\MicrosoftSDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools\x64\gacutil.exe" /l Microsoft.AnalysisServices.AdomdClientUI
You shouldsee message it is version 14.0.0.0 registered
3: Configure version redirect in machine.config (be careful when editing!!)
File toedit:
"C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config"
The elementto add content to is
configuration/runtime
On theserver I fixed it on, this element was completely empty, i.e. <runtime/>
If it isnot empty, of course keep what’s in the element and add the assemblyBindingelement seen below.
Change/addso that the whole element contains this instead:
<runtime>
<assemblyBindingxmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.AnalysisServices.AdomdClientUI" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
<bindingRedirect oldVersion="13.0.0.0" newVersion="14.0.0.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
5: Save thefile. The package should now work.
When afix in CU1 is installed, these steps should be done:
1: Remove the above added assemblyBinding element and save the file
2: Remove the dll that was added to the GAC:
"C:\Program Files (x86)\MicrosoftSDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools\x64\gacutil.exe" /u Microsoft.AnalysisServices.AdomdClientUI