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.
Last Published: October 29, 2018ArcGIS for Server
Bug ID Number
BUG-000098595
Submitted
August 15, 2016
Last Modified
June 2, 2021
Applies to
ArcGIS for Server
Version found
10.3.1
Operating System
N/A
Status
Non-Reproducible
This issue was not reproducible when tested by the development team. Issues may be given this status when they cannot be reproduced or are no longer relevant in a development version of the software, but a specific fix was not installed to address the issue. The issue's Additional Information section may contain further explanation.
Additional Information
This issue is fixed at ArcGIS Server 10.6.1.
Workaround
Use ST_Geometry as the spatial data geometry type.