Showing results for 
Show  only  | Search instead for 
Did you mean: 

How do I figure out duplicate key?

The error message I am getting is "Import failed. Error: Violation of PRIMARY KEY constraint 'PK__#Target___6C31A7A28770E611'. Cannot insert duplicate key in object 'dbo.#Target'. The duplicate key value is (2840274, 14, 4). Synchronized 0 row(s) of table 'AssetPerOperator_PC' (172 ms)"

I am trying to update some fields in Assets through Beacon and there are no duplicates in sheet.

Any ideas?

(2) Replies

I believe there is a duplicate record in the source file. It’s possible that some text in the source ends with a space, and when the adapter tries to insert this value, it removes the space. This can generate an error if the value without space is already inserted into the table.

I had a similar issue, above steps helped me resolve it.

I will look for spaces. Thanks!