topic Re: Can't delete SDE feature class (SQL) in Data Management Questions

Can't delete SDE feature class (SQL)

MKnapp — Fri, 04 Mar 2022 20:37:15 GMT

Hi there -

We've got an SDE feature class (that we have full permissions to) that has become corrupted...meaning that it can no longer be truncated, and we cannot delete it as well.

We've tried deleting via tools in ArcCatalog, and Pro.

We've looked for locks in the SQL Activity Monitor, but there are none.

Is there a non-desktop process for deleting a feature class outside of Desktop/Pro.

Have done some looking though Community posts and the consensus seems to be "call tech support".

Thanks.

Re: Can't delete SDE feature class (SQL)

ABishop — Fri, 04 Mar 2022 20:48:59 GMT

Hello,

This may help?

https://community.esri.com/t5/data-management-questions/can-t-delete-feature-class-in-sde/m-p/96463#M5637

Re: Can't delete SDE feature class (SQL)

MKnapp — Fri, 04 Mar 2022 21:15:45 GMT

Thanks Amanda.... this isn't quite our issue... we think the feature class has some orphaned locks on it. We're currently looking at ways that we can stop all connections to the database, then identify and clear out the orphaned locks in SQL.

-Mike

Re: Can't delete SDE feature class (SQL)

Reinaldo_Cartagena — Sat, 05 Mar 2022 16:07:21 GMT

Hi, you can use a python script. There is a guide in the following link:

https://desktop.arcgis.com/es/arcmap/10.6/tools/data-management-toolbox/delete-features.htm

Reinaldo.