AnsweredAssumed Answered

update attribute from a table using sql

Question asked by kbusby on Dec 23, 2019

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?

 

Thanks,

Ken

Outcomes