Error: An error occurred during the merge process. The merge could not be performed. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

Error: An error occurred during the merge process.  The merge could not be performed. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.  Native error: 242 [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.  Native error 3621
Addressed in version 7.83.1622. Download the latest update from our website.

Alternative Solutions:

Exclude Action information from the merge.

OR

Temporarily change the regional settings to English (United States):

  1. Open Regional and Language Settings in the Control Panel.
     
  2. On the Regional Options tab, select English (United States) in the main drop-down menu.
     
  3. Click OK.
     
  4. Run the merge process.
     
  5. Change the regional settings back to English (Canada) or English (United Kingdom).
     

Environment

 Reported in version 7.82.1514.0 ; Duplicated in version 7.82.1514.0 ; Duplicated in version 7.82.1476

Was this article helpful?