Can't delete SDE feature class (SQL)

Question

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.

Reinaldo_Cartagena · Answer

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.

MKnapp · Answer

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

ABishop · Answer

Hello,

This may help?

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