In ArcGIS Server, if the values for 'Result Offset' and 'Record Count' fields are set, the query results are inconsistent if the 'Return IDs only' field is false and the underlying data resides on an Enterprise Geodatabase.
Last Published: May 28, 2019ArcGIS GIS Server
Bug ID Number
BUG-000120308
Submitted
February 25, 2019
Last Modified
April 9, 2024
Applies to
ArcGIS GIS Server
Version found
10.6.1
Operating System
Windows OS
Status
Known Limit
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
Additional Information
This is an expected behavior. It is documented in the REST API.
https://developers.arcgis.com/rest/services-reference/query-map-service-layer-.htm
"In some cases when using the resultOffset and resultRecordCount parameters, the exceededTransferLimit property may be included in the query results even though the value specified in the resultRecordCount has not been exceeded. This is due to internal spatial index filtering of the query results. For this reason you should always rely on the exceededTransferLimit property to determine if you should page through results rather than relying on the number of results returned from each page. In some extreme cases zero results can be returned but the exceededTransferLimit property will be returned. In these cases you should continue paging though your results until exceededTransferLimit is no longer returned."