Versioning Error in Feature Class Stored in SDE (Column name SDE_STATE_ID is specified more than once)
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.
