Feature Class with Identity Column Failed to be Registered as Versioned

880
2
Jump to solution
09-05-2022 01:28 AM
User35489
Occasional Contributor III

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

0 Kudos
1 Solution

Accepted Solutions
MarceloMarques
Esri Regular Contributor

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.

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov

View solution in original post

2 Replies
George_Thompson
Esri Frequent Contributor

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

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.

--- George T.
MarceloMarques
Esri Regular Contributor

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.

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov