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.
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).