Skip to main content
Kofax

SqlDateTime Overflow Error During Data Load

Article # 3040388 - Page views: 23

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.

error.png

Level of Complexity 

Easy

 

Applies to  

Product Version Build Environment Hardware
Insight 6.x      

 

 

Article # 3040388