ArcGIS Pro 3.0.3; mobile geodatabase:
I have a FC and a standalone table:
I apply a definition query to the table -- to pare-down the rows so that only the latest inspection per asset is shown:
date_ = (select max(subq.date_) from roadinsptable subq where roadinsptable.asset_id = subq.asset_id)
I create a join from the FC to the table:
The join works as expected. And the definition query from the table is honoured.
Later, I change my mind: I've determined I don't need the join, so I remove it:
Problem:
Removing the join causes an error:
Failed to open table.
Error:
Attribute column not found [no such column: date_]
[Roads][STATE_ID = 0]
I hit OK. The attribute table of the FC automatically closes.
I try to re-open the attribute table of the FC:
But I get the same error I saw previously. And the attribute table doesn't open.
Trying again produces the same error.
The only way to successfully open the attribute table again is to remove the FC from the map and re-add it, which isn’t ideal.
Is that a known issue?
I only have the problem when the join table has a definition query. If there's no definition query, then I can remove the join without getting the error.