topic Automate Locks Management in Data Management Questions

Automate Locks Management

CraigCarsley — Wed, 04 Sep 2013 12:16:28 GMT

Does anyone know of any way to automatically break user connections to an enterprise geodatabase?
We are trying to run some scripts overnight, but they need to acquire locks on certain datasets, and we have some users who leave connections open.

I'd like to find a way to break their connections without having to go through the manual process.

Thanks!

Re: Automate Locks Management

VinceAngelo — Wed, 04 Sep 2013 12:30:22 GMT

Database connection termination is a database feature. The syntax varies by RDBMS.

The only way Esri code could be involved is if an application server connection is used
(and doing so is discouraged, partially because of this vulnerability).

I expect you could script user session termination in any of the dozen ArcSDE-supported
RDBMSes.

- V

Re: Automate Locks Management

RussellBrennan — Thu, 05 Sep 2013 16:03:02 GMT

The functions you are looking for are arcpy.ListUsers and arcpy.DisconnectUser

List Connected Users
http://resources.arcgis.com/en/help/main/10.2/index.html#//018v00000030000000

Disconnect users:
http://resources.arcgis.com/en/help/main/10.2/index.html#//018v00000061000000

The third example for disconnect users shows how to use the list users function with the disconnect users function to disconnect only specific users based on their names.

This will work for both application server connections (3-tier) as well as direct connections (2-tier).

Russell

Re: Automate Locks Management

ForrestJones — Thu, 05 Sep 2013 16:16:12 GMT

Also...to add to Russell's info about the GP tools (which you can script), you can list and disconnect users through the ArcGIS gui. This is from the 10.1 help (similar for 10.2):

Viewing connected users in ArcGIS for Desktop

The above has links to topics for removing connections from different types of databases. You'll have to make sure the sde admin user has the correct privileges (this is discussed in the help topics).

Re: Automate Locks Management

Bud — Fri, 15 Apr 2022 19:16:20 GMT

This post is quite old. I wonder if anything has changed since then? Any enhancements added to ArcGIS, etc.?