topic Unable to delete features with Delete Features or Delete Rows tools in ArcGIS Pro Questions

Unable to delete features with Delete Features or Delete Rows tools

swhitcombMCC — Mon, 31 Jul 2023 21:49:05 GMT

I have a hosted feature layer created from a CSV, and I want to use ModelBuilder to delete the contents and replace them with new data from an updated CSV on a schedule. I have tried to delete the features using both the Delete Features and Delete Rows tools in Pro. Both tools say they completed successfully, but when I look at the attribute table for the layer, it still has all the original features.

The odd thing is that none of the points show up on the map in Pro. I can right click on a feature and zoom to its location, but the points are not visible. When I pull up the map on AGOL, the attribute table for the layer is still full and the points show up just fine as if nothing has been deleted.

Any guesses as to why I can't delete these features?

Re: Unable to delete features with Delete Features or Delete Rows tools

JakeSkinner — Tue, 01 Aug 2023 11:26:46 GMT

@swhitcombMCC ,

What version of Pro are you running? Maybe try the Truncate Table tool instead.

Re: Unable to delete features with Delete Features or Delete Rows tools

swhitcombMCC — Wed, 02 Aug 2023 20:59:52 GMT

I'm running 3.1.2. I tried the Truncate Table tool, and I got the following error:

ERROR 001260: Operation not supported on table L0Arboretum_Map_Data_Survey123

Now what do I do?

Re: Unable to delete features with Delete Features or Delete Rows tools

JakeSkinner — Thu, 03 Aug 2023 11:00:56 GMT

I may be misunderstanding your workflow. Are you trying to truncate/delete rows from the CSV? Instead of doing this, I would recommend creating a ModelBuilder that performs the following:

Truncates the feature service
Converts the local CSV to points using XY Table to Point
Append the feature class to the feature service