Error at SSIS execution (SSAS Cube)

Question

Hello,

I have the following layout.

1) SSAS Cube successfully deployed on server
2) SSIS Project which takes data from an Oracle source and process a dimension of the cube.

The component inside the dataflow which I am using is Dimension Processing (Destination) with Process (Add) Incremental.

When I execute the package from Visual Studio it runs with success.

But, when I deploy the project in the server I am getting the following:

OnWarning
Process Add <DimensionName>:Warning: The registry key "SOFTWARE\Classes\CLSID{0535BEA2-954F-48C4-BB17-9C1C74F8B92F}\DTSInfo" cannot be opened.

OnError
Process Add<DimensionName>:Error: Failed to create COM Component Categories Manager due to error 0x80040154 "Class not registered".

The software versions we are using are:

1) SQL Server 2017 -14.0.17289.0
2) SSAS Multidimensional (Compatibility Level 1100)

Answer 1

I thinks this error involves no influence from SSAS side, it should be , as Olaf said, a 32/64 bit issue.

In 64 bit windows machines the COM components need to register itself in HKEY_CLASSES_ROOT\CLSID (64 bit component) OR HKEY_CLASSES_ROOT\Wow6432Node\CLSID (32 bit component) . If your application is a 32 bit application running on 64-bit machine the COM library would typically look for the GUID under Wow64 node and if your application is a 64 bit application, the COM library would try to load from HKEY_CLASSES_ROOT\CLSID. Make sure you are targeting the correct platform and ensure you have installed the correct version of library(32/64 bit).

Answer 2

If it runs in Visual Studio but not as job, then it could be a 32/64 bit issue; VS is 32 bit, SQL 64 bit. For a test set in the job step => Execution option the checkbox "Use 32 bit enviroment", may it works then.