ICA console displays errors for MDX query results

book

Article ID: 184661

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

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.

Cause

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:

  • Risk Fabric cube processing
  • Process Collections and Scenarios and Risk Models Measures Groups
  • Process Risk Vectors Measure Group

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.

Environment

Release: 6.5.x

Component: RiskFabric Processing

Resolution

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:

  1. Using SQL Server Management Studio (SSMS), connect to the database engine hosting the RiskFabric database
  2. In Object Explorer, navigate to SQL Server Agent > Proxies > Analysis Services Command
  3. Right-click the RiskFabric Proxy and select Properties
  4. In the 'RiskFabric Proxy' Proxy Account Properties window, select the ellipsis next to Credential name:
  5. In the Select Credential window, click the Browse... button
  6. In the Browse for Objects window, check the box next to the credential [RiskFabric Nightly Processing]
  7. Click the OK button to close the Browse for Objects window
  8. Click the OK button to close the Select Credential window
  9. Click the OK button to close the 'RiskFabric Proxy' Proxy Account Properties window
  10. If no errors were returned, navigate in Object Explorer to SQL Server Agent > Jobs
  11. Right-click RiskFabric Processing and select Start Job at Step
  12. In the Start Job on '<hostname>' window, highlight Step ID 1 and click the Start button to begin the processing job

The following error may be returned on step 9:

Alter failed for ProxyAccount 'RiskFabric Proxy'. (Microsoft SqlServer
Additional 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:

  1. In Object Explorer, navigate to SQL Server Agent > Proxies > Analysis Server Command
  2. Right-click RiskFabric Proxy and select Delete
  3. In the Delete Object window, check the box next to Reassign to: and select SQL Server Agent Service from the drop-down menu
  4. Click the OK button
  5. In Object Explorer, right-click the Analysis Server Command folder and select New Proxy...
  6. In the New Proxy Account window on the General page, ensure the following values are entered and selected:
    Proxy name: RiskFabric Proxy
    Credential name: RiskFabric Nightly Processing
    Active to the following subsystems: SQL Server Analysis Services Command
  7. Click the OK button to close the New Proxy Account window
  8. In Object Explorer, navigate to SQL Server Agent > Jobs
  9. Right-click RiskFabric Processing and select Start Job at Step
  10. In the Start Job on '<hostname>' window, highlight Step ID 1 and click the Start button to begin the processing job