The nightly RiskFabric Processing job logs an error similar to the following on the Calculate Risk Scores step (19):
Executed as user: NT SERVICE\SQLSERVERAGENT. Error Msg: Could not create constraint or index. See previous errors. Line Number: 355| Error Msg: Could not create constraint or index. See previous errors. Line Number: 427 [SQLSTATE 42000] (Error 50000) Job 'RiskFabric CalculateIPRiskScores' started successfully. [SQLSTATE 01000] (Error 14243) Job 'RiskFabric CalculateComputerEndpointRiskScores' started successfully. [SQLSTATE 01000] (Error 14243) Job 'RiskFabric CalculateUserRiskScores' started successfully. [SQLSTATE 01000] (Error 14243) Job 'RiskFabric CalculatePersonRiskScores' started successfully. [SQLSTATE 01000] (Error 14243) Job 'RiskFabric CalculateApplicationRiskScores' started successfully. [SQLSTATE 01000] (Error 14243) Job 'RiskFabric - Rebuild Indexes 6E2C56591EC54C2AA0AE539A4B5EBF68' started successfully. [SQLSTATE 01000] (Error 14243). The step failed.
This failure may occur either consistently or intermittently.
Version : 6.6 MP2 (6.6.2.0)
Component : RiskFabric Processing
Contact Broadcom support for assistance.
The cause of this error will be fixed in a future release of Information Centric Analytics (ICA).