Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB"

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

The following error is logged in the SQL Server Agent log and in the RiskFabric.Log_DataTransformation table while the RiskFabric Processing job is running the Calculate Risk Scores step:

Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB".

It may also be logged in the RiskFabric server log on a failed attempt at accessing the Events > Data In Motion dashboard, with additional detail:

[70:ERROR] LoggingExceptionFilterAttribute.OnException() https://<hostname>/api/WidgetAgingView/GetSectionData
System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB".

Environment

Release: 6.5.x

Component: RiskFabric_ASDB Linked Server

Cause

This error is thrown when the security context identity of the RiskFabric_ASDB linked server used to authenticate to the SQL Server Analysis Services (SSAS) server hosting the RiskFabric cube is not a member of the Server Administrators role on the SSAS server, or when no security context is set for connecting to the RiskFabric_ASDB linked server.

Resolution

To resolve this condition, follow this procedure to confirm the account of the security context identity to be used for the RiskFabric_ASDB linked server has been assigned the Administrators Role on the SSAS server:

1. Using SQL Server Management Studio (SSMS), connect to the Analysis Services server hosting the RiskFabric cube
2. In Object Explorer, right-click the server's hostname and select Properties
3. In the Analysis Server Properties window, select the Security page
4. If the account of the security context identity is not present in the list of Server Administrators, add the account using the Add... button
5. Click the OK button to close the Analysis Server Properties window

After confirming the account has been assigned the Server Administrator role on the SSAS server, follow this procedure to set the security context identity used by the RiskFabric_ASDB linked server:

1. Using SSMS, connect to the Database Engine hosting the RiskFabric database
2. In Object Explorer, navigate to Server Objects > Linked Servers
3. Right-click the linked server RiskFabric_ASDB and select Properties
4. In the Linked Server Properties - RiskFabric_ASDB window, select the Security page
5. Select the radio button Be made using this security context
6. Enter the credentials to connect to the SSAS server
7. Click the OK button to close the Linked Server Properties - RiskFabric_ASDB window