Bug Number BUG-000098595
Submitted Aug 15, 2016
Modified Jul 28, 2020
Severity Medium
Applies To ArcGIS GIS Server
Version Found 10.5.1
Prog Language N/A
Server Platform N/A
Client Platform N/A
Database N/A
Locale N/A
Status Not in Current Product Plan
Version Fixed
SP Fixed

Bug BUG-000098595


ArcGIS GIS Server 10.4.1 returns "Failed to execute query" and "ORA-01446 underlying DBMS error" when executing a spatial query at REST and providing either a "Result Offset" or "Result Record Count" parameter with an "Input Geometry" specified. This only occurs when the source data geometry type is Esri Binary or SDO Geometry type in an Oracle database.

Additional Information

This issue is fixed at ArcGIS Server 10.6.1.

Alternate Solution

Use ST_Geometry as the spatial data geometry type.