Truncate AGOL table from Pro

726
2
11-28-2019 09:04 AM
RoryBennison
New Contributor II

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

Tags (2)
0 Kudos
2 Replies
Peter_Klingman
Esri Regular Contributor

Hi Rory Bennison‌,

The documentation doesn't indicate that Hosted Feature Layers are unsupported, and I was able to reproduce this on my end. I agree that since Delete Rows is in the same toolset, we would expect both to work with Hosted Feature Layer input.

I logged BUG-000128389 for this behavior. If you would like, you can create a case with Eagle Technology Support and attach your customer number to this issue. As you found, the current workaround is to use Delete Rows. 

Hope this helps - let me know if you have any more questions. 

-Peter 

GillianElliott
Esri Contributor

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