ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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.

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.

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).

Environment

Release: 6.5.x

Component: RiskFabric Processing

Resolution

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