laptop and a wrench

Bug

When a table in SQL Server is joined to a feature class in SQL Server, definition queries cease to work on the joined table. "Failed to Open Table. Error: An expected Field was not found or could not be retrieved properly. [Fieldname]" error message is returned.

ArcGIS Pro
Bug ID Number BUG-000159010
SubmittedJune 9, 2023
Last ModifiedApril 27, 2026
Applies toArcGIS Pro
Version found3.1.1
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusNon-Reproducible

Additional Information

Non-reproducible with the current released version.

Workaround

To solve this issue, move the table and feature class outside of a SQL server and attempt the definition query there.

Steps to Reproduce

Bug ID: BUG-000159010

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options