We have been experiencing the impossible problem of duplicate ObjectIDs getting created in one of our SDEs on an SQL server. Prior to reconciling, checks are done across the SDE to confirm this issue isn’t present and then after a full reconcile/post the issue is present. It is technically impossible to occur, but somehow this is the 4th occurrence in the last year with this specific SDE. Any insight would be greatly appreciated. We currently have 3.2 ArcGIS Pro and Enterprise 11 in use and experienced this issue last year when using previous versions as well.
We have previously opened a ticket with Esri and their solution was to run the gp tools Diagnose Version Metadata, Diagnose Version Tables, Repair Version Metadata, and Repair Version Tables. The first two times we had this issue, the above tools eventually worked after repeatedly attempting execution upon tool failure on multiple machines. The last time this occurred the tools never executed successfully, and we were left with a cumbersome manual approach to address the issues.