laptop and a wrench

Error

Publishing mapping services containing layers with joins in ArcGIS Enterprise results in the advanced query capability being set to FALSE, unless the joined table is contained in the same map service.

ArcGIS GIS Server
Número de ID del error BUG-000167543
EnviadoMay 16, 2024
Última modificaciónJanuary 6, 2026
Relacionado conArcGIS GIS Server
Versión encontrada11.3
Sistema operativoWindows Server
Versión de sistema operativo2022
EstadoAs Designed

Información adicional

The support for advanced queries completely relies on the underlying database. The map service generates an SQL containing the entire join definition and pushes it to the database to execute it. When tables are coming from different databases, the query fails. Hence, map services do not support advanced queries such as outStatistics when joins are made of tables from multiple databases.

Solución alternativa

If the table or layer from the same workspace that participates in the join is included in the service, the advancedQueryCapabilities property is set to TRUE for all ArcGIS Enterprise versions 10.9.1, 11.1, 11.2, and 11.3.

Pasos para reproducir

ID del error: BUG-000167543

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