Troubleshooting Locks

[AndresCastillo]

This blog post reviews some of the methodologies that are helpful when trying to find locks.

See the attached file.

Note that the preview doesn't seem to show the word document very well, so its' better to download it.

For example, this is how I resolved this error:

Edit operation failed.

This data is currently locked by another user and cannot be saved.

Esri Technical Support‌

ESRI UK Technical Support‌

troubleshootingLocks.docx

[AndresCastillo]

I also want to add a comment by Xander Bakker‌ in this post:

Why arcpy.Copy_management() tool require exclusive schema lock? 

For managing locks in an enterprise geodatabase you could have a look at (you need to use an administrative account to be able to use these):

arcpy.ListUsers

The see the users that have currently a connection to the EGDB:

1. arcpy.ListUsers("Database Connections/admin.sde")  

arcpy.DisconnectUser

To disconnect a user in case necessary

1. arcpy.DisconnectUser("Database Connections/admin.sde", "ALL")  

arcpy.AcceptConnections

To not allow users to connect to the database (do set this back to True when finished updating the database)

1. arcpy.AcceptConnections("Database Connections/admin.sde", False)