SqlDateTime Overflow Error During Data Load
Article # 3040388 - Page views: 27
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 |