OleDB version 12 not working with SSAS Multidimensional instance, version 11 is fine
Just a finding I wanted to share.
We are running a Microsoft SSAS server containing both a Multidimensional instance and a Tabular model instance. Both are connecting to our Vertica cluster running v11.1.1-11. SSAS version is 2019.
We recently upgraded to driver package version 12 on the Microsoft servers since we are moving towards version 12 on Vertica also. With that came of course OleDB driver version 12.
After installing the driver a reboot was done on the server and things went haywire. The event log started giving errors similar to this, but ONLY for the Multidimensional instance:
Faulting application name: msmdsrv.exe, version: 2018.150.35.33, time stamp: 0x62cd011d
Faulting module name: vertica_12.0_oledb.dll, version: 22.214.171.124, time stamp: 0x636bef08
Also the processing of dimensions stopped as running into a wall after exactly 1 minute.
Note! Tabular models and Power BI reports work fine.
After downgrading to driver pack Version 11, the cube processing on Multidimensional instance went back to working.
Anyone else experiencing the same?