CDC Capture job fails with 'Cannot insert duplicate key row in object cdc.Table_CT' with unique index 'CT Clustered Index'
2
votes
1
answer
241
views
When the CDC Capture job runs, it fails with this error:
> Cannot insert duplicate key row in object cdc.Table_CT' with unique index 'CT Clustered Index.
This index is a SQL Server CDC created index on columns
__start_lsn, __$command_id, __$seqval, __$operation
.
Any ideas how to simulate this to trap why this happens, or a way to overcome these issues with CDC? Do I need to enable traceflags, or CU installed, etc?
Additional info: RCSI (Read Committed Snapshot Isolation) is enabled on the database. Not sure if this could possibly cause the issue experienced.
The only solution to get passed this error was to disable CDC on the database and re-enable the database and then the affected table. In this scenario, we were fortunate to do this, but this can not be done on other environments
Asked by Pam Moodley
(31 rep)
May 20, 2024, 04:32 AM
Last activity: Jun 12, 2025, 06:09 PM
Last activity: Jun 12, 2025, 06:09 PM