AnsweredAssumed Answered

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

Question asked by kjxm25_KCSouthern on Jun 22, 2018
Latest reply on Jun 25, 2018 by George_Thompson-esristaff

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

Outcomes