The RiskFabric Processing job steep Run Loading Procedures runs interminably

Products

• Information Centric Analytics

Issue/Introduction

Run Loading Procedures runs without errors indefinitely in an environment in which this job step ran quickly. The Log_DataTransformation table shows the following records for stored procedures that are running at that time:

EXEC dbo.spLDW_UpdateSymantecDLPUsersToNetworkEndpoints
Process DIM Users To Network Endpoints for LinkedServerID

Environment

Release : 6.5.x

Component :

Resolution

This issue was caused by a defect in the way the stored procedure spLDW_UpdateSymantecDLPUsersToNetworkEndpoints was written. An optimized version will be made available with 6.5.4 MP1.