update attribute from a table using sql

12-23-2019 05:59 AM
Occasional Contributor

I am attempting to update our tax parcel data using a table from our old AS400 CAMA system. when merging the two I get an error: Error: Violation of PRIMARY KEY constraint 'a18_rowid_ix1'. Cannot insert duplicate key in object 'sdeadmin.a18'. The duplcate key value is (59877, 92064).

I cant find those values in the table so I am not sure how they are being duplicated. Has anyone tried to do this? do you have any tips or suggestions? Maybe a different approach I have over looked?



0 Kudos
0 Replies