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

JamesMadden1 — Fri, 22 Jun 2018 19:09:21 GMT

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.

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

George_Thompson — Mon, 25 Jun 2018 11:00:25 GMT

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

topic Re: Versioning Error in Feature Class Stored in SDE (Column name SDE_STATE_ID is specified more than once) in Geodatabase Questions

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

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