Client Automation - What do I do if an Agent is Locked By RAC?

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

What do I do if an Agent is Locked By RAC?

Environment

Client Automation - All supported versions.

Resolution

If unsealed job containers are generated, you can delete them and RAC will become unlock.

If this is not the case, then machines need to be unlocked via a SQL query.

You can unlock all machines locked by RAC via SQL Query:

1. Open SQL Management Studio 
2. Login to SQL server 
3. Select New Query:

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)