topic Feature Class with Identity Column Failed to be Registered as Versioned in Geodatabase Questions

Feature Class with Identity Column Failed to be Registered as Versioned

User35489 — Mon, 05 Sep 2022 08:28:49 GMT

Hello There,

I tried to enable traditional versioning on a Feature Class with a column enabled for SQL Server identity property. It failed with the error 999999, Invalid column datatype.
Attached: Error snapshot

Is the below link still valid
https://support.esri.com/en/technical-article/000011579

Software:
ArcGIS Pro 2.9, Enterprise Geodatabase, SQL Server 2019

Re: Feature Class with Identity Column Failed to be Registered as Versioned

George_Thompson — Mon, 05 Sep 2022 14:46:03 GMT

You may have to contact technical support on this one. I did find this: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/data-types-sqlserver.htm

Not sure it answers your question. But it seems it may be something on the OBJECTID field only.

OBJECT ID

int(4) when created in an enterprise geodatabase

integer with identity property when created in a database

The ArcGIS type ObjectID is the registered row ID column for the table (or feature class.) Only one may exist per table.

Re: Feature Class with Identity Column Failed to be Registered as Versioned

MarceloMarques — Tue, 06 Sep 2022 15:41:10 GMT

Yes, the article is still valid and correct https://support.esri.com/en/technical-article/000011579

SQL Server Featureclass with a column that has Identity Property set to True is not supported.