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. An error message "Failed to Open Table. Error: An expected Field was not found or could not be retrieved properly. [Fieldname]" is returned.
| Bug ID Number | BUG-000159010 |
|---|---|
| Submitted | June 9, 2023 |
| Last Modified | June 26, 2024 |
| Applies to | ArcGIS Pro |
| Version found | 3.1.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | In Review |
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
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