ArcGIS Pro 3.1.1; file geodatabase
Scenario:
I've opened an ArcGIS Pro project that has a table in it called TEST_TABLE. The table has a join, but I wasn't aware.
I want to truncate the table. So I open the Truncate geoprocessing tool and select TEST_TABLE from the drop-down menu, not by browsing to the table in Catalog. By doing that, I've tried to truncate the in-map Contents table that has a join, which is not allowed in ArcGIS Pro. Normally, only tables without joins are truncated. At least, that's my assumption.
As expected, I get an error when I try to truncate the table with a join.
However, the error message seems incorrect/misleading:
ERROR 001400: Only the data owner may execute truncate.
Failed to execute (TruncateTable).
I think the error should be something like, "Cannot truncate a table that has a join." That would be more helpful to users who are trying to troubleshoot issues.
Is that error message incorrect, and is that a known issue?
Video:
Solved! Go to Solution.
Esri Case #03335647 - Truncate table (from Contents) with join throws the wrong error message
BUG-000158187: When using "Truncate Table" with a table that has a join, ArcGIS Pro provides an incorrect error message of "001400: Only the data owner may execute"
Esri Case #03335647 - Truncate table (from Contents) with join throws the wrong error message
BUG-000158187: When using "Truncate Table" with a table that has a join, ArcGIS Pro provides an incorrect error message of "001400: Only the data owner may execute"