menu
  • Register

the create unique index statement terminated because a duplicate key was found for the object name

1 vote
56 views

Problem :

I am facing bellow error
the create unique index statement terminated because a duplicate key was found for the object name
●6 ●5 ●3
6,930 points

1 Answer

0 votes

Solution :

The problem is not that index already exists but there are duplicate values of the TopicShortName field in the table itself. Such duplicates prevent the creation of a UNIQUE index.

So you should run a query to confirm that you have a duplicate:

SELECT
    TopicShortName,
    COUNT(*)
FROM
    DimMeasureTopic
GROUP BY
    TopicShortName
HAVING
    COUNT(*) > 1

Presumably in the other database the data are different, and the duplicates are not present.

This will certainly solve your problem.

Further Readings :

https://www.ibm.com/support/pages/refresh-fails-create-unique-index-statement-terminated-because-duplicate-key-was-found-error-while-replicating-sql-server-target

●9 ●7 ●4
38,600 points

Related questions

0 votes
1 answer 5 views
5 views
create procedure must be the only statement in the batch
asked Sep 13 Daniel Anderson 4k points
1 vote
2 answers 37 views
37 views
No unique index found for the referenced field of the primary table.
Problem : I am very new to database programming. I have recently started learning about databases. Currently I am desperately trying to create the database somehow for a very first time. I have already designed all of my tables. Now I am trying to create their relationships. But ... till now unable to fix it. So I am looking for database expert who can suggest me the quick fix for my above error.
asked Apr 22 stewart 4k points
0 votes
2 answers 240 views
240 views
Text was truncated or one or more characters had no match in the target code page
Problem : I want to import the flat file into my oledb target sql server database. But I am getting below error message : [Source - 18942979103_txt [424]] Error: Data conversion failed. The data conversion for column "recipient-name" returned status value 4 and status text ... more characters had no match in the target code page.". Why am I getting this error message? What am I doing wrong here?
asked Dec 23, 2019 alecxe 7.5k points
1 vote
1 answer 69 views
69 views
Procedure expects parameter statement of type ntext nchar nvarchar.
Problem : I am very new to SQL. If I try to use the sp_executesq I am often facing below strange looking error: “Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.” I have spent more than two days on above error but still can not fix above sql related error. Please guide me in fixing above sql error.
asked May 12 Martin K 6.6k points
Dark theme