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
Solved! Go to Solution.
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.
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. |
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.