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 validhttps://support.esri.com/en/technical-article/000011579Software:ArcGIS Pro 2.9, Enterprise Geodatabase, SQL Server 2019
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-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.
Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
