Continue in the app
Bug Number BUG-000120308
Submitted Feb 25, 2019
Modified Oct 03, 2020
Severity Low
Applies To ArcGIS GIS Server
Version Found 10.6.1
Prog Language N/A
Server Platform Windows
Client Platform Windows
Database N/A
Locale N/A
Status Known Limit
Learn more
Version Fixed
SP Fixed

Bug BUG-000120308


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.

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."

Alternate Solution