After Upgrade to ICA 6.5.1, The Data Loss Prevention Dashboard is Failing to Display

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

After Upgrade to ICA 6.5.1, The Data Loss Prevention Dashboard is Failing to Display

 "An error has occurred while executing MDX Query." ​

Cause

Processing was incomplete

Environment

After Upgrade to ICA 6.5.1

Resolution

There were certain steps of the processing job that had not completed.  This was due to certain SQL proxy accounts not being assigned to the correct Proxy functions. 

The Operating System (CmdExec) proxy must have the RiskFabric Nightly Processing proxy (credential) assigned.   The Analysis Services Command Proxy must have the RiskFabric Proxy assigned to it.