How do I solve this issue if an agent is in a "Locked by Roam" status under All Computers in DSM Explorer ?

Document ID : KB000043581
Last Modified Date : 28/08/2018
Show Technical Document Details
Introduction:

Question:

How do I solve this issue if an agent is in a "Locked by Roam" status under All Computers in DSM Explorer ?

 

Environment:                                          

CA Client Automation - All Versions

 

Answer:

This need to be addressed with a SQL query:  

1. Use SQL Management Studio to connect to SQL server. 

2. New Query  

   use mdb 
   update ca_agent set derived_status_sd=0
   where derived_status_sd =4 and agent_type=1
   update usd_target set locks=0 where locks=4
 
 
Additional Information:                         
 These can be run as often as needed.
 In fact if you don't feel these items are ever valid, you can create an Engine SQL Script task
with just the following to unlock both lock types Lock by RAC and Lock by Roam whenever they occur:
 
Lock by RAC:
 
   use mdb
   update ca_agent set derived_status_sd=0
   where derived_status_sd =1 and agent_type=1
 
    use mdb
    Update usd_target set locks=locks-25
    where locks >24 and (locks % 2 =1)
 
    use mdb
    update ca_agent
    set derived_status_sd=0
    where derived_status_sd =4 and agent_type=1
 
This will unlock all Locked Machines:
    use mdb
    update usd_target
    set locks=0
    where locks=4'  

 

 

Instructions:
Please Update This Required Field