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.
One thing that you do is run the following tools. Please create a complete (full) verified backup of the geodatabase before this process.
Then you can see if there are any error and then run the repair portion of the tools (these are separate).