DLP Discover Scans cube process fails

Products

• IT Analytics

Issue/Introduction

The DLP Dscover Scans cube fails to  process. The last 4 messages in the IT Analytics Event Viewer are:

Processing trace completed.
The job completed with failure.
The job completed with failure.
The job completed with failure.
Processing of the 'Scan Fact' partition has started.

 

Internal error: The operation terminated unsuccessfully.
OLE DB error: OLE DB or ODBC error: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.; 22003

Cause

The view vITAnalytics_DLP_ScanFact attempts to calculate the duration between the start & end times of a DLP scan. This conversion returns an integer value with the # of seconds the scan took. This error indicates that the duration took longer then 2.1 billion seconds or over 68 years. This is caused by an invalid end date in the DLP database table used by the view.

 

Resolution

There are two options to address this issue. With any option remember to make a backup of your database before making modification.

• Option 1 (Preferred method): In the DLP Walk table find the invalid ContentRootStatusTime entry and modify it to contain a valid date or remove the row containing this entry.
• Option 2: Run the attached SQL script to update the view to convert the timeframe to minutes instead of seconds. Not this still may cause the error to generate as the invalid date data could still exceed the integer limitation.

To verify the issue is resolved run the following script against the vITAnalytics_DLP_ScanFact view. If this query executes successfully you can reprocess the cube.

SELECT * FROM vITAnalytics_DLP_ScanFact

 

Applies To

 IT Analytics 7.5 Service Pack 1

DLP 12.5