While processing cubes from the IT Analytics for Data Loss Prevention v3.0 report pack , the following error is encountered...
Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: 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.. Errors in the OLAP storage engine: An error occurred while processing the 'Scan Fact' partition of the 'Scans' measure group for the 'DLP Discover Scans' cube from the IT Analytics3 database
This issue occurs when processing the DLP Discover Scans cube and manifests itself if there is a scan that has been running for longer than 24 days. As a result, the datediff function used in the shipping code returns a value too large and as a result throws an error.
Run the attached script by following the procedures below:
IT Analytics v7.1 SP2
IT Analytics for Data Loss Prevention 3.0
Important Note: This fix is only applicable to IT Analytics for DLP v3.0.1 Applying this fix to an ITA for DLP 2.0 environment or versions later than 3.01 will cause a number of problems that will result in the need to uninstall and reinstall in order to resolve.
If it becomes necessary to remove and reinstall the IT Analytics for DLP Pack for any reason, this fix should be re-applied. If a newer version is installed or an upgrade beyond v3.0.1 is installed, DO NOT APPLY this fix.
Script for resolving the error described in this KB
IT Analytics for DLP 3_0 Updates.txt (1.0 MB)