NIM092238 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM092238
Submitted	June 6, 2013
Last Modified	May 12, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	10.1
Status	Non-Reproducible

Additional Information

This issue is caused because Geometry & Geography type feature classes have a side table that stores CAD entities. The side table contains a column named 'Geometry_ID'. Any operation that has to join to this side table causes an ambiguous column name error because the column in the feature class is not correctly qualified.

Workaround

- Rename the Geometry_ID column in the feature class, or use sdebinary as the spatial type storage. This problem is not specific to 10.1; it would occur in 10.0 as well if the Geometry or Geography type was used.</p><p>- Create a new column in the ArcSDE 10.0 database (using a 10.0 client) and populate the column with the values stored in the GEOMETRY_ID column. As long as the GEOMETRY_ID column is removed before the table is copied to the ArcSDE 10.1 database (using a 10.1 client) the error message is not returned.