Troubleshooting
Problem
Refresh fails with "CREATE UNIQUE INDEX statement terminated because a duplicate key was found" error while replicating to SQL Server target. Source table has corresponding columns defined as primary key or unique index so no duplicates are possible and present on the source.
Symptom
Refresh fails and the message similar to the one below is present in event log:
[CDC][SQLServer JDBC Driver][SQLServer]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.TABLE1' and the index name 'PK__TABLE1__4C6B5938'. The duplicate key value is (Value1, Value2).
A SQL exception has occurred. The SQL error code is '1750'. The SQL state is: HY000. The error message is:
[CDC][SQLServer JDBC Driver][SQLServer]Could not create constraint. See previous errors.
Target database uses case-insensitive collation and source database is case-sensitive.
Character columns are part of primary key or unique index on both source and target.
[CDC][SQLServer JDBC Driver][SQLServer]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.TABLE1' and the index name 'PK__TABLE1__4C6B5938'. The duplicate key value is (Value1, Value2).
A SQL exception has occurred. The SQL error code is '1750'. The SQL state is: HY000. The error message is:
[CDC][SQLServer JDBC Driver][SQLServer]Could not create constraint. See previous errors.
Target database uses case-insensitive collation and source database is case-sensitive.
Character columns are part of primary key or unique index on both source and target.
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSX3HK","label":"InfoSphere Change Data Capture"},"ARM Category":[{"code":"a8m0z000000cwb9AAA","label":"Troubleshooting-\u003ETroubleshooting data replication"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.3.0;11.4.0"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
InfoSphere Change Data Capture
Component:
Troubleshooting->Troubleshooting data replication
Software version:
11.3.0, 11.4.0
Operating system(s):
Windows
Document number:
481279
Modified date:
24 July 2023
UID
swg21614482
Manage My Notification Subscriptions