search cancel

Deadlock when computers are deleted

book

Article ID: 254805

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Software Delivery

Issue/Introduction

When a computer is deleted, it could take long time and some locks are set in table usd_class_version
This could generate GUI performance problem or problem/error during creation of SD Job Container
 

Environment

Client Automation 14.5 - Any version

Resolution

Open a case at CA Broadcom Technical Support requesting the fix T5KP078
 
This fix delivers a new version of usd_trg_d_agent_usd_rel trigger of table ca_agent.
This new trigger reduce the time of lock in table usd_class_version and so minimize the risk to get a deadlock.