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
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.
There are two options to address this issue. With any option remember to make a backup of your database before making modification.
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