topic Re: Delete Rows Tool Fails and then Corrupts Shapefile in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421329#M18716 <HTML><HEAD></HEAD><BODY><P>Hi Kory,</P><P></P><P>Yes- I am giving it a shapefile, either polygons or lines.&nbsp;</P><P><IMG class="image-1 jive-image" height="266" src="https://community.esri.com/legacyfs/online/483790_pastedImage_1.png" width="443" /></P><P></P><P>The shapefile is stored in a local C drive folder, I try to always run locally since it tends to have issues otherwise. I also tried just manually deleting the rows from the attribute table using the delete selected rows button, but that also produced similar results.&nbsp;</P></BODY></HTML> Mon, 02 Mar 2020 19:35:47 GMT NatalieRobbins 2020-03-02T19:35:47Z Delete Rows Tool Fails and then Corrupts Shapefile https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421327#M18714 <HTML><HEAD></HEAD><BODY><P>When I create a Select by Location query to find identical features in two shapefiles, I run the Delete Rows tool to get rid of the identical features. About every 1/5 times the Delete Rows tool will fail and then will corrupt the shapefile I am working with. Is this because I am working with shapefiles vs feature classes??<IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/483766_pastedImage_1.png" /></P></BODY></HTML> Mon, 02 Mar 2020 15:31:30 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421327#M18714 NatalieRobbins 2020-03-02T15:31:30Z Re: Delete Rows Tool Fails and then Corrupts Shapefile https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421328#M18715 <HTML><HEAD></HEAD><BODY><P>That could be because rows are being deleted from the .dbf table but not the .shp file.&nbsp; Can you include a screenshot of how you're setting up the Delete Rows tool?&nbsp; For the Input Rows, you're providing it a shapefile, correct? (i.e. Pro isn't "seeing" a separate .dbf?)</P><P></P><P>Where is the shapefile stored?&nbsp; If not locally (C drive) does it make any difference if the tool is reading/writing locally?</P></BODY></HTML> Mon, 02 Mar 2020 19:12:46 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421328#M18715 KoryKramer 2020-03-02T19:12:46Z Re: Delete Rows Tool Fails and then Corrupts Shapefile https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421329#M18716 <HTML><HEAD></HEAD><BODY><P>Hi Kory,</P><P></P><P>Yes- I am giving it a shapefile, either polygons or lines.&nbsp;</P><P><IMG class="image-1 jive-image" height="266" src="https://community.esri.com/legacyfs/online/483790_pastedImage_1.png" width="443" /></P><P></P><P>The shapefile is stored in a local C drive folder, I try to always run locally since it tends to have issues otherwise. I also tried just manually deleting the rows from the attribute table using the delete selected rows button, but that also produced similar results.&nbsp;</P></BODY></HTML> Mon, 02 Mar 2020 19:35:47 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421329#M18716 NatalieRobbins 2020-03-02T19:35:47Z Re: Delete Rows Tool Fails and then Corrupts Shapefile https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421330#M18717 <HTML><HEAD></HEAD><BODY><P>It would probably be best to work with <A href="https://support.esri.com/en/contact-tech-support">Technical Support</A> on this one as it will require some troubleshooting.</P></BODY></HTML> Mon, 02 Mar 2020 22:48:38 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421330#M18717 KoryKramer 2020-03-02T22:48:38Z Re: Delete Rows Tool Fails and then Corrupts Shapefile https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421331#M18718 <HTML><HEAD></HEAD><BODY><P>Even if this does turn out to be a defect with shape files, getting defects addressed takes time, so finding a workaround or alternate workflow is crucial.&nbsp; You might as well start testing with feature classes now.</P></BODY></HTML> Mon, 02 Mar 2020 23:02:19 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421331#M18718 JoshuaBixby 2020-03-02T23:02:19Z Re: Delete Rows Tool Fails and then Corrupts Shapefile https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421332#M18719 <HTML><HEAD></HEAD><BODY><P>You could try&nbsp; "shapefile repair", in the attachment in this thread</P><P><A _jive_internal="true" class="link-titled" href="https://community.esri.com/thread/177037#comment-614216" title="https://community.esri.com/thread/177037#comment-614216">https://community.esri.com/thread/177037#comment-614216</A>&nbsp;</P></BODY></HTML> Mon, 02 Mar 2020 23:07:36 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-rows-tool-fails-and-then-corrupts-shapefile/m-p/421332#M18719 DanPatterson_Retired 2020-03-02T23:07:36Z