topic Re: Delete Specific Feature Class in Python Questions

Delete Specific Feature Class

jaykapalczynski — Tue, 15 Mar 2022 22:35:01 GMT

I am trying to read my SDE database and then delete specific feature classes if they exist...

I keep getting error below....not sure whats up....do I need to make a different connection to the db?

ExecuteError: ERROR 000601: Cannot delete C:/GIS_Scripts/Update/OS@Connection.sde/database.DBO.FEATURES_update. May be locked by another application.
Failed to execute (Delete).

def main(): sqlPath = r"C:/GIS_Scripts/Update/OS@Connection.sde/" fc_Delete = ["database.DBO.FEATURES_update","fc_Out2a"] for fc in fc_Delete: fc_path = os.path.join(sqlPath, fc) print fc_path if arcpy.Exists(fc_path): arcpy.Delete_management(fc_path)

Re: Delete Specific Feature Class

DonMorrison1 — Tue, 15 Mar 2022 23:19:27 GMT

I've never found a good way to get around this from python. Usually when my script fails (and I know nobody else should be using the database) I delete the locks on the database and then rerun the script. There is probably a less disruptive way - I'd be curious to find out.

Re: Delete Specific Feature Class

RhettZufelt — Tue, 15 Mar 2022 23:36:05 GMT

Do either of these feature classes exist:

C:/GIS_Scripts/Update/OS@Connection.sde/database.DBO.FEATURES_update
C:/GIS_Scripts/Update/OS@Connection.sde/fc_Out2a

as that is what is being told to delete (in that order).

Otherwise, normally when data is locked, it is by another user OR a service that is consuming the feature class.

You need to make sure you stop any services that are using that feature class. If that isn't it, you can try to disconnect users from the database, and, maybe even block incoming connections while you do the delete.

Re: Delete Specific Feature Class

jaykapalczynski — Wed, 16 Mar 2022 12:32:03 GMT

The dbo.features_update FC exists....

Thats the crazy thing there are no locks....

That is ALL the code that I am trying to use....is there something else that I am missing....

Re: Delete Specific Feature Class

jaykapalczynski — Wed, 16 Mar 2022 12:39:42 GMT

It almost appears that its creating its own lock when its trying to read if it exists....

Re: Delete Specific Feature Class

Anonymous User — Wed, 16 Mar 2022 12:58:59 GMT

My first thought is are you using the connection for the data owner? Most of the time it will be the sde account. Not sure what your OS connection has available in terms of roles, but that is something to check as well.

Re: Delete Specific Feature Class

DonMorrison1 — Wed, 16 Mar 2022 12:59:36 GMT

I would try to delete the table using the Delete Geoprocessing tool in ArcGIS Pro to see if you can establish that it is related to something in your python code. Another possibility is something in the database itself has it locked. Our systems use MS SQL Server and I would guess there are things you could do in the MS SQL Server Manager that would lock up a table. I've never had a problem with the arcpy.Exists call leaving the object locked.

Re: Delete Specific Feature Class

jaykapalczynski — Wed, 16 Mar 2022 13:06:16 GMT

OK so its telling me its locked but I have already cleared the locks....there is no service hitting this db and its on a test box so nothing should be accessing it....

I first check to make sure it exists
I then try to disconnect all users
I then test that specific FC for a lock

It keeps telling me its locked but when I check the DB and FC after it runs there are no locks?

for fc in fc_Delete: fc_path = os.path.join(workspaceLocation, fc) print fc_path if arcpy.Exists(fc_path): arcpy.DisconnectUser(r"C:/GIS_Scripts/Update/OSConnection.sde/", "ALL") print fc_path + " exists" if not arcpy.TestSchemaLock(fc_path): print "Can't proceed - " + fc_path + " feature class is locked" else: arcpy.ClearWorkspaceCache_management() arcpy.Delete_management(fc_path)

Re: Delete Specific Feature Class

jaykapalczynski — Wed, 16 Mar 2022 13:48:34 GMT

Thanks will check that out....

Re: Delete Specific Feature Class

jaykapalczynski — Fri, 18 Mar 2022 12:48:46 GMT

Thanks Ya'll for your comments....turns out there was an issue with the FC itself. I rebuilt the db and everything works regarding the DELETE....thanks again

Re: Delete Specific Feature Class

davedoesgis — Tue, 18 Oct 2022 18:11:08 GMT

I got this Traceback from an exception from arcpy.management.Delete:

Traceback (most recent call last): [...TRIMMED THE SAUSAGE-MAKING OF MY SCRIPTS...] File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 6977, in Delete raise e File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 6974, in Delete retval = convertArcObjectToPythonObject(gp.Delete_management(*gp_fixargs((in_data, data_type), True))) File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda> return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: ERROR 000601: Cannot delete <PATH_TO_SDE_FILE>\<DATABASE>.<SCHEMA>.<FEATURE_CLASS>. May be locked by another application. Underlying DBMS error [42S02:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot drop the procedure 'DBO.i68_return_ids', because it does not exist or you do not have permission.] [<DATABASE>.<SCHEMA>.<FEATURE_CLASS>] Failed to execute (Delete).

I had another table that I had created using non-Esri SQL. That table had a foreign key referencing my feature class. Because the table and FK were both created with SQL, I guess SDE doesn't know about them, so wasn't tracking them, and thus was unable to delete the feature class with another table referencing it. As soon as I dropped the FK, the error went away.

I know we're supposed to always use Esri tools to manage database objects related to feature classes, but this seems like such a basic thing that it surprised me that arcpy's Delete couldn't figure it out.