Unable to save edits - Unique constraint violation: Unable to trim state for table.

Question

Hello,

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,

Paschalis

ABishop · Answer

@PaschalisLagias

Try this one:

https://geodatamaster.com/2013/10/26/underlying-dbms-errorora-00001-unique-constraint-in-arcsde-geodatabase/

PaschalisLagias · Answer

@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.

ABishop · Answer

@PaschalisLagias

I did a google search for your error and found this technical support article:

https://support.esri.com/en/technical-article/000007268