Data In Motion events dashboard and Calculate Risk Scores processing step

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

When viewing the Events by Severity widget in the Events > Data In Motion dashboard, no values are displayed. Instead, progress indicators for each value are displayed interminably and the following error is logged in the Information Centric Analytics (ICA) server log on the application (IIS) server:

[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".

In addition, the Top Users with Very Unusual Incidents widget may also return no values and instead display the message "No User Information". When this occurs, the following error is logged in both the SQL Server Agent log and in the RiskFabric.dbo.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".

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 ICA service account 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 ICA service account 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 ICA service 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 ICA service account credentials to connect to the SSAS server
7. Click the OK button to close the Linked Server Properties - RiskFabric_ASDB window