I am currently getting an error when trying to save edits within an Edit Session while modifying data saved within an Oracle Enterprise Geodatabase.
I am using ArcMap Standard 10.8 and I am trying to update a table that has been registered as versioned with the edits being moved to base. We don't have multiple versions of the Geodatabase apart from the default one.
The error I get is related to a unique constraint violation, which seems to stop state trimming. Below a screenshot of the error:
Any suggestion or direction about this error would be highly appreciated. Could you please let me know in case there is any extra piece of information that I can add to assist. Apologies if the post does not meet the required standard, it is the first time I am creating one in this space.
Many thanks in advance,
I did a google search for your error and found this technical support article:
@ABishop thank you for the quick response. I have looked into the article but I cannot find SDE.GDB_OBJECTCLASSES table within Oracle SDE user.
The unique constraint seems to be related to an Additions delta table composite Primary key. Unfortunately, I don't know how to track how the values for this key are generated.
Try this one: