Error: "Could not create constraint or index" on Calculate Risk Scores step

Products

• Information Centric Analytics

Issue/Introduction

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.

Environment

Version : 6.6 MP2 (6.6.2.0)

Component : RiskFabric Processing

Resolution

Contact Broadcom support for assistance.

The cause of this error will be fixed in a future release of Information Centric Analytics (ICA).