Truncate AGOL table from Pro

Question

Hi Guys,

Hopefully this hasnt been asked before, I am trying to use the truncate table tool from within arcgis pro for a feature layer in arcgis pro, the plan being to later append the data.

When i try to run it, very quickly a failed error appears as below.  Is there something that needs to be updated in the arcgis online feature service to allow this to work.  The delete rows tool works without a problem and so does append.

Appreciate your assistance on this one

Cheers

Rory

LindsayRaabe_FPCWA · Answer

Small clause to add - it only works as long as the feature service doesn't have Sync enabled. More reading here: ArcGIS Pro Truncate Table GP Tool Could Work on Po... - Page 2 - Esri Community

LindsayRaabe_FPCWA · Answer

I know this is an old post, but thought it worthwhile to post anyway.

I've just discovered that the Truncate Table works with feature services (for administrators only) from ArcGIS Pro 3.0.

Anonymous User · Answer

To provide an update on this, BUG-000128389 was closed by Development as a known limitation with the explanation, "The Truncate Table is not supported on hosted feature layers, as described in the error message returned."

The workaround remains what Peter suggested above, Use the Delete Rows tool instead of the Truncate Table tool or use the Delete Features operation through the ArcGIS REST API.

Thank you,

Gillian