Versioning Error in Feature Class Stored in SDE (Column name SDE_STATE_ID is specified more than once)

06-22-2018 12:09 PM
Occasional Contributor

We have a feature class that is stored in a SQL Server SDE database.  The feature class originated from a feature class view that resides in a production db.  When we went to version the feature class we received an odd error message saying 'FAILED TO REGISTER AS VERSIONED, COLUMN SDE_STATE_ID IN TABLE A107 IS SPECIFIED MORE THAN ONCE'.  I did some digging and column/field SDE_STATE_ID appears to be a primary key in the 'adds' table for version 107.  This has me concerned because the new feature class resides in a separate geodatabase and shouldn't be maintaining any relationship to the production database.  The feature class view was exported to the new database using the feature class to feature class tool.  A picture of the error message is shown below.   

error message

Tags (1)
0 Kudos
1 Reply
Esri Frequent Contributor

One thing that you do is run the following tools. Please create a complete (full) verified backup of the geodatabase before this process.

Diagnose Version Metadata—Help | ArcGIS Desktop 

Diagnose Version Tables—Help | ArcGIS Desktop 

Then you can see if there are any error and then run the repair portion of the tools (these are separate).

--- George T.