This operation is not supported on Esri Spatial Types

JasonHarshman

I recently upgraded our SDE Enterprise Geodatabase to 10.9.0.2.7 from 10.6.x following an upgrade to our PostgreSQL database to 12.5. I upgraded the Enterprise Geodatabase using ArcGIS Pro 2.7 and had no issues with upgrading the Geodatabase. 

However, I've noticed some issues related to tables with geometry columns. For example, when I attempt to run the Check Geometry tool on any registered feature class, I get a validation error that says, "ERROR 003341 This operation is not supported on Esri Spatial Types". This is odd because the geometry type is an Esri Spatial Type because that's what the spatial type was before the upgrade and nothing changed other than upgrading the Geodatabase using ArcGIS Pro. I also know the database host has a valid st_geometry.so file because I was able to successfully enable a new database as a Geodatabase following the upgrade. 

Has anyone experienced this type of behavior? Is there a way to check what the spatial type is of a geometry column in Postgres?  

Thank you!

Check Geometry.jpg

feature class properties.jpg

Dale_Honeycutt_0-1713726823910.png

433959042_122116648556234986_992147424184090595_n.jpg

George_Thompson

Thanks for updating the images, that helps 1000%. I think that the issue is related to what spatial types that the Check Geometry tool supports

"Valid input formats are shapefiles, and feature classes stored in a file or enterprise geodatabase. For feature classes stored in an enterprise geodatabase, the following spatial types are supported:

• Microsoft SQL Server Geometry and Geography
• PostgreSQL PostGIS Geometry and Geography
• Oracle SDO Geometry"

That would mean that the tool does not support ST_Geometry.

Could you export the feature to a file geodatabase to run?

I was looking to see if their is an ST operator that could be run but could not figure one for your use case: 

Hope this helps!