laptop and a wrench

Error

When Return Distinct Values is set to True for a feature service or map service and a geometry type is specified, a query from ArcGIS REST API fails on ArcGIS Server with PostgreSQL as the underlying database.

Última publicación: July 5, 2019 ArcGIS GIS Server
Número de ID del error BUG-000118572
EnviadoDecember 4, 2018
Última modificaciónJune 5, 2024
Relacionado conArcGIS GIS Server
Versión encontrada10.6.1
Sistema operativoWindows OS
Versión de sistema operativo2016 64 Bit
EstadoKnown Limit

Información adicional

This is a known limitation in ArcGIS Server. Our ArcGIS Server REST API states the following: Note: Make sure to set returnGeometry = false when returnDistinctValues = true or results will not be reliable. https://developers.arcgis.com/rest/services-reference/query-feature-service-layer-.htm

Solución alternativa

  1. Run a query with only Return IDs Only set to True, along with an Input Geometry specified.
  2. Take note of the ObjectIDs that are returned and then run another query.
  3. Place the returned ObjectIDs into a second query with the following parameters:
    1. Remove the input geometry.
    2. Return Distinct Values = True.
    3. Return IDs Only = False.
  4. The query should complete successfully.

Pasos para reproducir

ID del error: BUG-000118572

Software:

  • ArcGIS GIS Server

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga