SqlDateTime Overflow Error During Data Load

Issue

"SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

 

Cause

Invalid data in a date field in the source.

 

Solution

Locate the offending data and correct. The date field used in the record / metric contains data outside the allowed range. Below is an example of an SQL Query that can be used to locate that information. You can utilize the InsightServer_WinApp.log file when this error occurs to find the query causing this for your data load.

Level of Complexity 

Easy

 

Applies to  

Product	Version	Build	Environment	Hardware
Insight	6.x

 

 

Article # 3040388