Potential inconsistencies can be introduced for versioned updates if the transaction fails after inserting the rows into the adds table and prior to inserting the rows into the deletes table.
A versioned update is logically represented by inserting the new updated row into the adds table and inserting a row into the deletes table representing the state for which the row is being deleted or updated.
If a commit is executed after the insert to the adds table and an underlying DBMS error is encountered prior or after the insert into the deletes table (and rolled back), the logical update without its corresponding delete's row will be considered an INSERT. The result is the row being updated will contain duplicates.
Get help from ArcGIS experts
Download the Esri Support App