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

mazzouzi

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:

 

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)))

# Specify the path to your geodatabase file
geodatabase_path = r"C:\Path\to\YourGeodatabase.gdb"

# Call the function to stop editing
stop_editing(geodatabase_path)

 

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

 

mazzouzi

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)