laptop and a wrench

Bug

Setting 'Return ID's Only = True' in the query panel at the REST endpoint when querying a feature service published from a registered database against an unregistered view (regardless of the RDBMS) returns an error.

Last Published: March 9, 2020 ArcGIS GIS Server
Bug ID Number BUG-000128505
SubmittedFebruary 7, 2020
Last ModifiedJune 11, 2024
Applies toArcGIS GIS Server
Version found10.7.1
Operating SystemWindows OS
Operating System Version10.0
StatusDuplicate

Additional Information

Duplicate of BUG-000110683: This is expected behavior. The Object IDs and the Return IDs Only parameter entries are for the ObjectID data type. If the view is not registered with the geodatabase, even though there is a field called objectid, it is still just like any other field – its type is long integer. In order for this field to be recognized as the ObjectID type, the view must be registered with the geodatabase. Once that is done, the properties of the view would now show the type of the ‘objectid’ field as Object ID and the query would then work.

Workaround

Publish a view which is registered with a geodatabase and successfully run when querying the feature service with 'Return ID's Only: True' at the REST endpoint. 

Steps to Reproduce

Bug ID: BUG-000128505

Software:

  • ArcGIS GIS Server

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options