After an upgrade or after uninstalling and reinstalling Information Centric Analytics (ICA), the console displays a generic error with error ID when navigating to the DLP Overview page and displays the following error in the DLP Incidents by Individual Normality Rating widget:
An error has occurred while executing MDX Query.
The following error may also be logged in the SQL Server Agent log and in the Log_DataTransformation table:
JobOwner Domain\Username doesn't have permissions to use proxy 9 for subsystem ANALYSISCOMMAND
Additionally, the Events By Severity counts in the DLP Event Scenarios Requiring Remediation widget are never populated.
The RiskFabric cube has not yet been processed or is not installed on the SQL Server Analysis Services (SSAS) server identified in the ICA console under Admin > Settings > General > Advanced Settings > Analysis Services Server and Analysis Services Database.
If the RiskFabric Processing job was run post-installation, the following job steps failed to complete:
The SQL Server Agent log history shows these steps failed due to an issue with the credentials of the proxy RiskFabric Proxy (SQL Server Agent > Analysis Services Command), or because the RiskFabric cube is missing.
Component: RiskFabric Processing
If the RiskFabric cube is missing from the SSAS server, review the installation log to determine and remediate the cause of failure and then re-run the ICA installer. Alternatively, contact Broadcom support for assistance with obtaining an XMLA script to create the cube.
If the SQL Server Agent log history shows processing failed due to an issue with the credentials of the RiskFabric Proxy, assign the RiskFabric Nightly Processing credential to the RiskFabric Proxy by doing the following:
The following error may be returned on step 9:
Alter failed for ProxyAccount 'RiskFabric Proxy'. (Microsoft SqlServerAdditional Information:
Object reference not set to an instance of an object. (Microsoft.SqlServer)
To resolve this error, the proxy RiskFabric Proxy needs to be deleted and re-created. To do this: