topic update attribute from a table using sql in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/update-attribute-from-a-table-using-sql/m-p/369988#M14356 <HTML><HEAD></HEAD><BODY><P>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: <SPAN style="font-size: 11.0pt;">Error: Violation of PRIMARY KEY constraint 'a18_rowid_ix1'. Cannot insert duplicate key in object 'sdeadmin.a18'. The duplcate key value is (59877, 92064).</SPAN></P><P><SPAN style="font-size: 11.0pt;">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?</SPAN></P><P></P><P><SPAN style="font-size: 11.0pt;">Thanks, </SPAN></P><P><SPAN style="font-size: 11.0pt;">Ken</SPAN></P></BODY></HTML> Mon, 23 Dec 2019 13:59:49 GMT KennethBusby 2019-12-23T13:59:49Z update attribute from a table using sql https://community.esri.com/t5/arcgis-enterprise-questions/update-attribute-from-a-table-using-sql/m-p/369988#M14356 <HTML><HEAD></HEAD><BODY><P>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: <SPAN style="font-size: 11.0pt;">Error: Violation of PRIMARY KEY constraint 'a18_rowid_ix1'. Cannot insert duplicate key in object 'sdeadmin.a18'. The duplcate key value is (59877, 92064).</SPAN></P><P><SPAN style="font-size: 11.0pt;">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?</SPAN></P><P></P><P><SPAN style="font-size: 11.0pt;">Thanks, </SPAN></P><P><SPAN style="font-size: 11.0pt;">Ken</SPAN></P></BODY></HTML> Mon, 23 Dec 2019 13:59:49 GMT https://community.esri.com/t5/arcgis-enterprise-questions/update-attribute-from-a-table-using-sql/m-p/369988#M14356 KennethBusby 2019-12-23T13:59:49Z