topic Re: Delete a feature class from a SDE database failed in Python Questions

Delete a feature class from a SDE database failed

YuLuo — Thu, 11 Jun 2020 18:45:53 GMT

When I tried to use arcpy.management.Delete(fc) to delete a feature class from a SDE database, it failed with error message " ERROR 000601: Cannot delete ..\SECore_Tools_Testing_sde.DBO.point_windmill. May be locked by another application. Failed to execute (Delete)."

Then I add the following code before delete the feature class:

edit = arcpy.da.Editor(arcpy.env.workspace)
edit.startEditing(False, True)
edit.startOperation()

arcpy.management.Delete(fc)

edit.stopOperation()

edit.stopEditing(True)

I got different error message " ERROR 000496: table is being edited. Failed to execute (Delete)."

Please help! Thanks.

Re: Delete a feature class from a SDE database failed

DanPatterson — Thu, 11 Jun 2020 19:01:28 GMT

Is it in a map?

Did you restart Pro?

Where are you running this? from inside using Pro's python or external?

Re: Delete a feature class from a SDE database failed

YuLuo — Thu, 11 Jun 2020 19:05:29 GMT

I am running a python tool inside Pro.

Re: Delete a feature class from a SDE database failed

DanPatterson — Thu, 11 Jun 2020 19:06:56 GMT

what about the first 2 questions?

Re: Delete a feature class from a SDE database failed

YuLuo — Thu, 11 Jun 2020 19:08:22 GMT

I am writing a python toolbox tool and run it in Pro.

Re: Delete a feature class from a SDE database failed

YuLuo — Thu, 11 Jun 2020 19:11:09 GMT

I start a Arc Pro and add a new map, add some feature classes from a SDE database, add my new toolbox in Catalog pan.

Re: Delete a feature class from a SDE database failed

DanPatterson — Thu, 11 Jun 2020 19:20:23 GMT

If one of the layers you are adding is one you are trying to delete, don't add it and see if you can delete it from the database.

If you are trying to just remove it from the map, then you should be using removeLayer from ...

LayerFile—ArcPy | Documentation

Re: Delete a feature class from a SDE database failed

YuLuo — Thu, 11 Jun 2020 19:27:05 GMT

Thank you, Dan. I tried to start new pro and not add any feature class, then run my tool from the toolbox. It gives me the same errors.

Re: Delete a feature class from a SDE database failed

DanPatterson — Thu, 11 Jun 2020 19:28:59 GMT

It could be anything, including how you set up your parameters in the toolbox. A lot more information would be needed

Re: Delete a feature class from a SDE database failed

YuLuo — Thu, 11 Jun 2020 19:32:50 GMT

However, when I run Pro built-in geoprocessing tool "Delete" with feature class I am trying to delete on the map, I can delete it successfully.

Re: Delete a feature class from a SDE database failed

YuLuo — Thu, 11 Jun 2020 19:34:45 GMT

My tool can delete feature class from a FileGeodatabase (*.gdb) but not SDE.

Re: Delete a feature class from a SDE database failed

DanPatterson — Thu, 11 Jun 2020 19:38:19 GMT

SDE just opens up a whole new set of issues

Good luck

Re: Delete a feature class from a SDE database failed

YuLuo — Thu, 11 Jun 2020 19:43:58 GMT

Thank you for your help!

Re: Delete a feature class from a SDE database failed

RandyKreuziger1 — Fri, 12 Jun 2020 21:41:33 GMT

If it's part of the map I think you need to programmatically remove the layer from the map before you can delete it in your code. Otherwise, your map has a shared lock on it.

Re: Delete a feature class from a SDE database failed

YuLuo — Mon, 15 Jun 2020 16:42:38 GMT

I start ArcPro without a template that shows blank Contents pane, no maps at all. Then I add my toolbox to the Catalog and run my tool. It gives me same error like the database "May be locked by another application". I think I have missed some code that should unlock SDE, but I don't know what is it.

Re: Delete a feature class from a SDE database failed

YuLuo — Thu, 18 Jun 2020 14:07:38 GMT

The issue is due to the SDE process permission. After our SQL administrator assigned a different server, the issue is resolved. Thank you for the helps.