Agent is in a "Locked by Roam" status under All Computers in DSM Explorer

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager

Issue/Introduction

An agent is in a "Locked by Roam" status under All Computers in DSM Explorer. How can you fix this?

Environment

CA IT Client Automation - All Versions

Resolution

This needs 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'  

 

For Oracle Database, please use below queries:

For Locked by RAC:

update ca_agent set derived_status_sd=0 where derived_status_sd=1 and agent_type=1;

update usd_target set locks=locks-25 where locks>24 and mod(locks,2)=1;

For Locked by ROAM:

update usd_target set locks=locks-25 where locks>24 and mod(locks,2)=1;

update usd_target set locks=0 where locks=4;