CA Tuesday Tip - How do I get rid of all these locks??

Discussion created by Sandra_Antunes on May 27, 2013
Latest reply on Jun 5, 2013 by Sandra_Antunes
Hey there!

We've seen with some frequency complains about users unable to do any changes in Service Desk Manager due to locks, specially when the user or analyst just created the ticket, and cannot edit it because[i] he himself holds the lock as per the message received from SDM!!!

Sometimes, the lock gets resolved by itself some time later. Others, the analyst has to logoff and login to SDM to have the lock released.
But sure, this is not the best process to follow. It's fine to be used one, two times, but it's annoying!!!
A recycle??? It resolves, but it's a last resource option.

As a first step, the following command issued from the Primary server releases the lock:

[ bopmsg [b]<sdhostname> bpvirtdb_srvr bpvirtdb unlock <persid> Call_Req ]

The id of the ticket can be obtained from the Lock page in the Administration tab of Service Desk Manager or by issueing a pdm_extract:

pdm_extract -f"Select persid from Call_Req where id like <ticket number>"

Now that the lock had been released, how to definitely resolve the problem?
You should add the following variable to NX.ENV:


It will release all locks on SREL table after 30 seconds.

Don't forget to proceed as per the following TECDOC to add the variable to NX.ENV file:
TEC590407 - Making Manual Changes to the NX.env and NX.env Template Files

Note at this time, a recycle in Service Desk is needed.
And it's done.

Have a great week!

Sandra :wink: