Cannot insert duplicate key row in object with unique index in SQL Server

Question

Cannot insert duplicate key row in object 'dbo.OCRD' with unique index 'OCRD_ABS_ENTRY'. The duplicate key value is (1). The statement has been terminated.;

An error occurred while updating the entries. See the inner exception for details.; An error occurred while updating the entries. See the inner exception for details.

Inner Exception: Cannot insert duplicate key row in object 'dbo.OCRD' with unique index 'OCRD_ABS_ENTRY'. The duplicate key value is (1). The statement has been terminated.

An error occurred while updating the entries. See the inner exception for details. An error occurred while updating the entries. See the inner exception for details.

It's an insert on DB

So your question is..? The error is literally telling you the problem here. — Thom A
– Thom A ♦, Commented Aug 9, 2018 at 13:21
Look at the definition of the index OCRD_ABS_ENTRY. This will tell you which Field you are having a problem with. The error message is telling you that the value you are trying to insert is the value "1". A unique index will prevent duplicate values for that column from being inserted. So you will either need to a) change the value to something that is unique or b) change the index so that it doesn't have a unique constraint. 99% of the time the correct coarse of action will be a). — kooch
– kooch, Commented Aug 9, 2018 at 13:23

Zaynul Abadin Tuhin · Accepted Answer · 2018-08-09 13:34:37Z

1

You have a column named "OCRD_ABS_ENTRY" which has an integrity constraint (unique key or primary key).
You try to insert another entry with value "1" for OCRD_ABS_ENTRY column, which should be unique.
Try to delete the constraint if it's not necessary, or to insert with another value.

edited Aug 9, 2018 at 13:34

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

answered Aug 9, 2018 at 13:28

Florian

113 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

r.pezzolati Over a year ago

I don't have column named "OCRD_ABS_ENTRY" it's autogenerate from db...my PK is CardCode

r.pezzolati Over a year ago

Ok I have a primary key... row |primary_key| other columns 1 100001 ... 2 100002 ... 3 500000 ... I try to insert a new record with primary_key 100003 From what I understand is trying to write the new record in row 1 and I do not understand the reason ...

Zaynul Abadin Tuhin · Accepted Answer · 2018-08-09 13:38:10Z

1

follow what @Florian already said. Additional information

insert values into tables with out mentioning value to primary field

answered Aug 9, 2018 at 13:38

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

7 Comments

r.pezzolati Over a year ago

Ok I have a primary key... row |primary_key| other columns 1 100001 ... 2 100002 ... 3 500000 ... I try to insert a new record with primary_key 100003 From what I understand is trying to write the new record in row 1 and I do not understand the reason ...

Zaynul Abadin Tuhin Over a year ago

is your primary key auto incremented or not?

Zaynul Abadin Tuhin Over a year ago

as you inserted 1 once so you are not allowed to again insert 1 in praimary key colum, duplicacy not allowed in primary key .it always will be unique

Zaynul Abadin Tuhin Over a year ago

can u plz describe about your primary key and what is your dbms

r.pezzolati Over a year ago

Primary key is nvarchar dbms sql server

|

Collectives™ on Stack Overflow

Cannot insert duplicate key row in object with unique index in SQL Server

2 Answers 2

2 Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related