topic Re: 000464: Cannot get exclusive schema lock. Either being edited or in use by another application or service. in ArcGIS Pro Questions

000464: Cannot get exclusive schema lock. Either being edited or in use by another application or service.

mazzouzi — Wed, 10 Jan 2024 19:04:34 GMT

If you are encountering the error "Either being edited or in use by another application or service" in ArcGIS when working with a geodatabase file, it typically indicates that the geodatabase is locked by another process or user. This can happen when a dataset within the geodatabase is being edited or when there's a lingering lock from a previous operation.

you can use the "arcpy.da.Editor" class in ArcPy. This class provides a way to manage edit sessions.

Here's an example script that stops the current editing session:

Replace "C:\Path\to\YourGeodatabase.gdb" with the actual path to your geodatabase file.

Re: 000464: Cannot get exclusive schema lock. Either being edited or in use by another application or service.

TylerT — Wed, 08 May 2024 20:03:57 GMT

@mazzouzi et al,

I am getting this exact error regularly on Enterprise Geodatabase sde path vice gdb file. I can't get the arcpy.da.Editor stopEditing script above working on the Enterprise workspace, and it's not clear to me whether it should work in the Enterprise environment. Should arcpy.da.Editor(workspace) stopEditing work on an Enterprise Geodatabase and if not, how can I programmatically release locks and connections on feature classes. For now, I have been using ArcGIS Pro GUI to release the endless locks and connections, but it's time consuming.

Thank you,

Tyler

Re: 000464: Cannot get exclusive schema lock. Either being edited or in use by another application or service.

mazzouzi — Tue, 28 May 2024 16:29:06 GMT

import arcpy def stop_editing(workspace): try: # Create an edit session edit = arcpy.da.Editor(workspace) # Stop the edit session edit.stopEditing(True) # The True parameter saves the edits print("Editing session stopped successfully.") except Exception as e: print("Error stopping editing session: {}".format(str(e))) def disconnect_users(workspace): try: # Disconnect all users from the SDE geodatabase arcpy.DisconnectUser(workspace, "ALL") print("All users disconnected successfully.") except Exception as e: print("Error disconnecting users: {}".format(str(e))) def remove_locks(workspace): try: # Remove all locks from the SDE geodatabase arcpy.ClearWorkspaceCache_management(workspace) print("All locks removed successfully.") except Exception as e: print("Error removing locks: {}".format(str(e))) # Specify the path to your SDE geodatabase sde_geodatabase_path = r"Database Connections\YourSDEConnection.sde" # Call the function to stop editing stop_editing(sde_geodatabase_path) # Call the function to disconnect users disconnect_users(sde_geodatabase_path) # Call the function to remove locks remove_locks(sde_geodatabase_path)

Re: 000464: Cannot get exclusive schema lock. Either being edited or in use by another application or service.

mazzouzi — Tue, 28 May 2024 16:29:33 GMT

try this code may work for you

Re: 000464: Cannot get exclusive schema lock. Either being edited or in use by another application or service.

TylerT — Wed, 29 May 2024 11:23:15 GMT

Thank you! I will give this a go, and let you know. Tyler

Re: 000464: Cannot get exclusive schema lock. Either being edited or in use by another application or service.

TylerT — Mon, 10 Jun 2024 21:10:57 GMT

@mazzouzi et al,

That code worked for me. Thank you. Is there a way to be more surgical? This operates on the entire geodatabase where ArcGIS Pro client manually operates locks at the table level.

Tyler

Re: 000464: Cannot get exclusive schema lock. Either being edited or in use by another application or service.

eallan — Wed, 26 Mar 2025 17:32:54 GMT

I have a Toolbox Script, where would I insert my script into the solution code?

Like how a black Toolbox Script will show where to insert one's custom code: