English

Error: Failed to register as versioned. Unique indexes can not be specified for multiversioned tables

Error Message

When attempting to register an ArcSDE table or layer as versioned, this error message may appear.

"Failed to register as versioned. Unique indexes cannot be specified for multiversioned tables [<owner>.<tablename>]"

Cause

The table has a unique index other than the one on the ArcSDE-maintained registered row ID column. This occurs for several reasons; for example, autoregistering third-party tables with preexisting unique indexes, or adding unique indexes to geodatabase tables using SQL or another database tool.

Solution or Workaround

The steps to accomplish this differ among databases. Refer to the documentation for the database for details.

  1. Find the unique index on the table and get its description.
  2. Drop the unique index.
  3. Use ArcCatalog or sdetable to register the table as versioned.
  4. Replace the unique index on the table.