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

Article Number: 44626

Products:

Raiser_s_Edge_RE

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):

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

Environment

Affected Version (from previous KB) Reported in version 7.82.1514.0 ; Duplicated in version 7.82.1514.0 ; Duplicated in version 7.82.1476

Blackbaud Community

Connect and collaborate with fellow Blackbaud users.

Chat with Support

Chat with our experienced staff to receive help right away.

Connect