Update LDW Core failed during RiskFabric Processing
search cancel

Update LDW Core failed during RiskFabric Processing

book

Article ID: 228767

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

The RiskFabric Processing job step Update LDW_Core fails and the SQL Server Agent log contains the following entries for this job step:

spUpdateDIMIncidentClassificationMitigationFromStatus failed. Error Message: Cannot insert the value NULL into column 'ClassificationMethodID', table 'RiskFabric.dbo.LDW_DIMIncidents'; column does not allow nulls. UPDATE fails. [SQLSTATE 42000] (Error 50000)
...The step failed.

Environment

Release : 6.5.4

Component : RiskFabric Processing

Cause

A defect in a stored procedure causes Data In Motion (DIM) incidents that have been automatically remediated (i.e., classified or mitigated) through DIM classification prediction to return a null remediation ID.

Resolution

This defect is fixed in Information Centric Analytics (ICA) 6.6.