laptop and a wrench

Bug

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, 2018 ArcGIS for Server
Bug ID Number BUG-000098595
SubmittedAugust 15, 2016
Last ModifiedJune 2, 2021
Applies toArcGIS for Server
Version found10.3.1
Operating SystemN/A
StatusNon-Reproducible

Additional Information

This issue is fixed at ArcGIS Server 10.6.1.

Workaround

Use ST_Geometry as the spatial data geometry type.

Steps to Reproduce

Bug ID: BUG-000098595

Software:

  • ArcGIS for Server

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic