Staging procedure for Symantec DAR integrations performs slowly

book

Article ID: 205587

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

The Run Staging Procedures step of the RiskFabric Processing job runs for several hours without completion. Entries in the Log_DataTransformation table show the stored procedure spUpdateStg_SymantecDAR running significantly longer than usual, with a section of entries looping through a set of incident IDs from LDW_DARIncidents that have NULL StatusID values. The loop goes through 500 at a time in order to prevent the IN clause from exceeding the 8000 character limit for OPENQUERY calls.

Cause

The loading process filters for INCIDENT.INCIDENTSTATUSID IS NOT NULL, but the StatusID isn't being set properly in the LDW_DARIncidents table, resulting in abnormally large data sets to loop.

Environment

Release : 6.5.4

Component : Symantec DAR Integration

Resolution

A fix for this issue will be released with 6.5.4 MP1.