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".
Release: 6.5.x
Component: RiskFabric_ASDB Linked Server
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.
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:
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: