laptop and a wrench

Bug

Queries fail with a "Failed to execute query" error when querying a standalone table in a map service at REST if the table contains a join, and the join field names between the two tables do not match.

Last Published: March 1, 2017 ArcGIS GIS Server
Bug ID Number BUG-000103227
SubmittedFebruary 27, 2017
Last ModifiedMay 31, 2023
Applies toArcGIS GIS Server
Version found10.4.1
Operating SystemWindows OS
Operating System Version2008 R2
StatusIn Review

Workaround

When using a standalone table that contains a join in a map service, make sure that the join field's name matches the name of the join field in the table being joined. It is not enough for the alias names to match; the actual field names must match.

Steps to Reproduce

Bug ID: BUG-000103227

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