Bug
The error message "Failed to execute query" is returned when executing a query operation on a map service table with large data and using an ESRI_OID range in the where clause.
| Bug ID Number | BUG-000107168 |
|---|---|
| Submitted | August 7, 2017 |
| Last Modified | November 23, 2025 |
| Applies to | ArcGIS GIS Server |
| Version found | 10.5.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Duplicate |
Additional Information
Duplicate of BUG-000119828. The ESRI_OID field is a pseudo field with values randomly assigned to each feature, so using ESRI_OID as a regular field is not recommended. Beginning with ArcGIS Enterprise 11.5, map services return uniqueIdInfo in the layer’s REST resources; use the field(s) from this element when constructing queries. In this workflow, use uniqueIds or returnUniqueIdsOnly instead of objectIds or returnIdsOnly.Steps to Reproduce
Bug ID: BUG-000107168
Software:
- ArcGIS GIS Server
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App