How do I figure out duplicate key?

[penny_cundro]

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?

[scsharath2]

Hi,
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.

[penny_cundro]

I will look for spaces. Thanks!