topic Re: 'GDB_GEOMATTR_DATA' error in ArcGIS Enterprise Questions

'GDB_GEOMATTR_DATA' error

GaryBowles1 — Tue, 19 Dec 2017 15:58:09 GMT

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

Re: 'GDB_GEOMATTR_DATA' error

George_Thompson — Tue, 19 Dec 2017 16:08:01 GMT

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-198a517314ee&searchIndex=0‌ https://community.esri.com/community/gis/managing-data?sr=search&searchId=cdceadeb-30d3-40f4-8687-3d2465cefee2&searchIndex=0‌

Re: 'GDB_GEOMATTR_DATA' error

Asrujit_SenGupta — Tue, 19 Dec 2017 16:09:33 GMT

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.

What version of ArcGIS Desktop is being used?
What is the version of the Enterprise geodatabase?
What version of SQL Server database is being used?
Was editing working fine on the same data and you are suddenly getting this error? Or did you make some changes today and now you get the error?

Re: 'GDB_GEOMATTR_DATA' error

Anonymous User — Wed, 14 Nov 2018 18:10:47 GMT

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.

What version of ArcGIS Desktop is being used?
- 10.6.1
What is the version of the Enterprise geodatabase?
- 10.5
What version of SQL Server database is being used?
- 12.0.5600.1
Was editing working fine on the same data and you are suddenly getting this error? Or did you make some changes today and now you get the error?
- Nothing has been changed with the data recently, we had been successfully editing data up until a week ago. I have tested editing a few different feature classes in this same feature dataset and am seeing the same error. Other feature datasets seem ok. This feature dataset is registered as versioned, and had archiving enabled on 4/12/18. My colleague tested editing in Pro and got the same error.

Re: 'GDB_GEOMATTR_DATA' error

George_Thompson — Wed, 14 Nov 2018 19:03:23 GMT

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.