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
