Error handling when MS SQL Server is the target: - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

 To insert the IDENTITY column values, Connect CDC must issue a SET IDENTITY_INSERT ON statement at the target. If that statement fails during replication, an error is issued. Whether replication continues or stops on the target depends on the request error mode. If Shutdown apply component is the error mode, replication stops. For more information, see the Advanced User Guide.

Since MS SQL Server does not allow updates to IDENTITY columns, Connect CDC updates always exclude the IDENTITY column. Situations (collisions) where Connect CDC converts a user insert of a source row to an update of a target row can result in different IDENTITY column values in the source row and the target row because the target IDENTITY column does not get updated with the new value. If such a situation occurs, Connect CDC updates the rest of the target row and continues processing.