ST_CENTROID Function Fails with ORA-20017 and LIB PKG Errors

KrystalPhaneuf4 — Tue, 14 Jan 2025 23:56:50 GMT

Oracle 19c, SDE 10.7.1

Tested in ArcMap/Catalog 10.7.1, ArcGIS Pro 3.2.2, Oracle SQL Developer

Not sure when it happened but our Development database is returning the error below when creating a spatial view using sde.ST_CENTROID. Other functions work like ST_BUFFER and I have ran the check geometry on the polygons the view is referencing, and tried multiple feature classes with no luck.

Our DBAs have also recompiled the SDE.ST_GEOMETRY_OPERATORS and SDE.ST_GEOMETRY_SHAPELIB_PKG packages.

I have ran through all the queries that are recommended online to check the health of the database. All of those queries return what is expected. And the library file is pointing to the correct location. Opened a ticket with ESRI but hoping someone here may have answers.

ORA-20017: Invalid Geom_Operation
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 339
ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 1553

select sde.ST_AsText(SDE.ST_Geometry('POINT(10 10)',0)) from dual;

RETURNS "POINT ( 10.0 10.0)"

SELECT object_name, object_type FROM USER_OBJECTS WHERE STATUS = 'INVALID';

Nothing returns

SELECT file_spec FROM user_libraries WHERE library_name = 'ST_SHAPELIB';

Correct library file location

topic ST_CENTROID Function Fails with ORA-20017 and LIB PKG Errors in Geodatabase Questions

ST_CENTROID Function Fails with ORA-20017 and LIB PKG Errors