We are receiving the following error message on several datasets in our SQL Server database: Unable to save edits: Attribute column not found[42s22:[Microsoft][ODBC Driver 13 for SQl Server][SQL Server] Invalid column name 'GDB_GEOMATTR_DATA'.] What does this mean, and how do I correct the problem?
Thanks,
--gary
It looks like there may be a known issue on this: BUG-000106321: Enabling archiving on SQLServer feature classes crea..
It looks like there is a workaround till 10.6 is released.
https://community.esri.com/groups/geodatabase?sr=search&searchId=2aea6a37-a2d8-46a5-9342-198a517314e... https://community.esri.com/community/gis/managing-data?sr=search&searchId=cdceadeb-30d3-40f4-8687-3d...
SQL Server spatial types and ArcGIS—Manage geodatabases in SQL Server | ArcGIS Desktop
ArcGIS adds a column to store extra geometric elements
The geometry and geography types cannot store all types of geometric elements that geodatabases must support. Therefore, when you create or register a feature class that uses the geometry or geography storage type with a geodatabase in SQL Server, ArcGIS adds a column to the business table to store these additional geometric elements. The column is called gdb_geomattr_data. The additional geometric elements include the following:
- Parametric objects such as circular arcs and Bezier curves created with advanced editing tools
- PointIDs
- Multipatch features
- Surface patches from ArcGIS Spatial Analyst
When ArcGIS detects the data source has these additional geometric elements, a simple geometric representation is stored in the shape column and the unmodified data (including the additional elements) is stored in the gdb_geomattr_datacolumn.
Gary Bowles Did you ever figure this out? This is happening when attempting to save edits, not when enabling archiving.
I am seeing the same error using version 10.6.1.
I would recommend updating the Enterprise Geodatabase to the same version of the client and retest. The fix for this issue may have been in the geodatabase.