Processing jobs hang while staging data from DLP

Products

• Information Centric Analytics

Issue/Introduction

Both the nightly RiskFabric Processing job and the RiskFabric Intraday Processing (if enabled) hang on the step Run Staging Procedures. Executing the following query in SQL Server Management Studio (SSMS) shows the current operation is executing an OPENQUERY call against a Symantec Data Loss Prevention (DLP) data source:

USE RiskFabric;
GO

SELECT   TOP 10
         LogName,
         LogDescription,
         StartDate,
         EndDate,
         RunMinutes,
         RowsAffected
FROM     dbo.Log_DataTransformation WITH (NOLOCK)
WHERE    StatusFlag = N'R'
ORDER BY 1 DESC;

Environment

Release : 6.x

Component : Symantec Data Loss Prevention Integration Pack

Cause

Corruption of the Oracle Database Client.

NOTE: Although the symptoms are similar, the cause of the behavior described in this article differs from the condition described in the knowledgebase article Intermittently slow performance staging data from DLP after migrating to virtual machines.

Resolution

Repair or uninstall and reinstall the Oracle Database Client on the server hosting Microsoft SQL Server and the RiskFabric relational database.