caused by com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.

1
We try to retrieve a claim object with the following Xpath: [ClaimNo=$c_schade/schadenummer] [year-from-dateTime(IncidentDate)= year-from-dateTime($IncidentdateUTC)] [month-from-dateTime(IncidentDate)= month-from-dateTime($IncidentdateUTC)] [day-from-dateTime(IncidentDate)= day-from-dateTime($IncidentdateUTC)] All date times are available and are not Null or empty We get the following error... caused by com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): XPathTextGetRequest (depth = 0, amount = 1): //Claim.ClaimHub[ClaimNoVPI='2921213'] [year-from-dateTime(IncidentDate)= year-from-dateTime(1458172800000)] [month-from-dateTime(IncidentDate)= month-from-dateTime(1458172800000)] [day-from-dateTime(IncidentDate)= day-from-dateTime(1458172800000)] …endix.util.classloading.Runner.doRunUsingClassLoaderOf (Runner.java:36) caused by com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. What can cause this error?
asked
1 answers
0

From this SO question:

DATETIME2 has a date range of "0001 / 01 / 01" through "9999 / 12 / 31" while the DATETIME type only supports year 1753-9999.

Are any of your dates outside of the range 1753-9999?

answered