Bug
Queries fail and return a "Failed to execute query" error message 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.
| Bug ID Number | BUG-000103227 |
|---|---|
| Submitted | February 27, 2017 |
| Last Modified | November 10, 2025 |
| Applies to | ArcGIS GIS Server |
| Version found | 10.4.1 |
| Operating System | Windows OS |
| Operating System Version | 2008 R2 |
| Status | Non-Reproducible |
Additional Information
This is no longer reproducible.Workaround
When using a standalone table that contains a join in a map service, ensure the join field name and the name of the join field in the table being joined match. 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
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App