SQL to find the version name that is locking default version

IrisHadarStltd — Wed, 26 Jun 2024 10:21:44 GMT

Hi,

I'm seeking the most effective method to identify which version is locking the default version before initiating maintenance routines. This is my current approach, but I'm uncertain about its correctness.

Any suggestions on this matter would be greatly appreciated.

1. Find witch one is blocking:

select p.owner,oselect p.owner,o.lock_time from sde.OBJECT_LOCKS o inner join sde.process_information p on o.sde_id = p.sde_id where object_id = 1

2.get the process info:

select sde_id from process_information where owner = 'U2PH5'

3.get state_id

select state_id from STATE_Locks where sde_id in (606147,606139)

4.get the version name

select NAME from versions where state_id in(5690105, 5690987, 5691192, 5690541, 5691075)

topic SQL to find the version name that is locking default version in Geodatabase Questions

SQL to find the version name that is locking default version