topic Unable to save edits - Unique constraint violation: Unable to trim state for table. in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/unable-to-save-edits-unique-constraint-violation/m-p/1109642#M7402 <P>Hello,</P><P>I am currently getting an error when trying to save edits within an Edit Session while modifying data saved within an Oracle Enterprise Geodatabase.</P><P>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.</P><P>The error I get is related to a unique constraint violation, which seems to stop state trimming. Below a screenshot of the error:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PaschalisLagias_0-1634817139148.png" style="width: 434px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/25737iBBB667223B6905E6/image-dimensions/434x177?v=v2" width="434" height="177" role="button" title="PaschalisLagias_0-1634817139148.png" alt="PaschalisLagias_0-1634817139148.png" /></span></P><P>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.</P><P>Many thanks in advance,</P><P>Paschalis</P><P>&nbsp;</P> Thu, 21 Oct 2021 12:00:01 GMT PaschalisLagias 2021-10-21T12:00:01Z Unable to save edits - Unique constraint violation: Unable to trim state for table. https://community.esri.com/t5/geodatabase-questions/unable-to-save-edits-unique-constraint-violation/m-p/1109642#M7402 <P>Hello,</P><P>I am currently getting an error when trying to save edits within an Edit Session while modifying data saved within an Oracle Enterprise Geodatabase.</P><P>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.</P><P>The error I get is related to a unique constraint violation, which seems to stop state trimming. Below a screenshot of the error:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PaschalisLagias_0-1634817139148.png" style="width: 434px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/25737iBBB667223B6905E6/image-dimensions/434x177?v=v2" width="434" height="177" role="button" title="PaschalisLagias_0-1634817139148.png" alt="PaschalisLagias_0-1634817139148.png" /></span></P><P>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.</P><P>Many thanks in advance,</P><P>Paschalis</P><P>&nbsp;</P> Thu, 21 Oct 2021 12:00:01 GMT https://community.esri.com/t5/geodatabase-questions/unable-to-save-edits-unique-constraint-violation/m-p/1109642#M7402 PaschalisLagias 2021-10-21T12:00:01Z Re: Unable to save edits - Unique constraint violation: Unable to trim state for table. https://community.esri.com/t5/geodatabase-questions/unable-to-save-edits-unique-constraint-violation/m-p/1109650#M7403 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/530981">@PaschalisLagias</a>&nbsp;</P><P>I did a google search for your error and found this technical support article:&nbsp;</P><P><A href="https://support.esri.com/en/technical-article/000007268" target="_blank">https://support.esri.com/en/technical-article/000007268</A>&nbsp;</P> Thu, 21 Oct 2021 12:36:47 GMT https://community.esri.com/t5/geodatabase-questions/unable-to-save-edits-unique-constraint-violation/m-p/1109650#M7403 ABishop 2021-10-21T12:36:47Z Re: Unable to save edits - Unique constraint violation: Unable to trim state for table. https://community.esri.com/t5/geodatabase-questions/unable-to-save-edits-unique-constraint-violation/m-p/1109716#M7404 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/486546">@ABishop</a>&nbsp; thank you for the quick response. I have looked into the article but I cannot find <SPAN>SDE.GDB_OBJECTCLASSES table within Oracle SDE user.</SPAN></P><P>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.</P> Thu, 21 Oct 2021 14:37:46 GMT https://community.esri.com/t5/geodatabase-questions/unable-to-save-edits-unique-constraint-violation/m-p/1109716#M7404 PaschalisLagias 2021-10-21T14:37:46Z Re: Unable to save edits - Unique constraint violation: Unable to trim state for table. https://community.esri.com/t5/geodatabase-questions/unable-to-save-edits-unique-constraint-violation/m-p/1109718#M7405 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/530981">@PaschalisLagias</a>&nbsp;</P><P>Try this one:</P><P><A href="https://geodatamaster.com/2013/10/26/underlying-dbms-errorora-00001-unique-constraint-in-arcsde-geodatabase/" target="_blank">https://geodatamaster.com/2013/10/26/underlying-dbms-errorora-00001-unique-constraint-in-arcsde-geodatabase/</A>&nbsp;</P> Thu, 21 Oct 2021 14:45:48 GMT https://community.esri.com/t5/geodatabase-questions/unable-to-save-edits-unique-constraint-violation/m-p/1109718#M7405 ABishop 2021-10-21T14:45:48Z