Solved

Date Range Error

  • 3 January 2024
  • 3 replies
  • 93 views

Badge

As shown in Figure Syncronize Task is sucessfully completed, but Transfer Task gets an below error 
“System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 ”PM even though my date range starts from 2002 and ends at 2023.

Even though after suggestion by @Christian Hauggaard i have made changes in setting of Date Conversition and selected MS SQL Min/Max option, but once i change the setting then i gets the below error for same process,
“System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out”


(This error is geeting for those tables who has Date Column, and date column has such data (for example 03/01/2022 6:42 PM ) )

​​​​​​​What are steps to solve above error?

 

icon

Best answer by Karankadam 16 January 2024, 04:56

View original

3 replies

Userlevel 6
Badge +5

Hi @Karankadam 

It is a timeout, have you tried to increase that? If so did it fail still and if so before the allowed time was exceeded?

Userlevel 6
Badge +5

Hi @Karankadam Did you manage to resolve this by increasing timeout or with another solution? Please let us know if you have any follow up questions

Badge

Hi @Christian Hauggaard i have solved this issue by selecting the SQL min/max option in Data conversion .

Reply