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