Error Message: ORA-20999: Error 9011: Cannot remove the computer because of active Software Delivery jobs ORA-06512: in "MDBADMIN.USD_TRG_D_AGENT_USD_REL"

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

While attempting to unlink a Domain manager, from an Enterprise manager DSM Explorer console, you receive the following error message:
Error 9011: Cannot remove the computer because of active Software Delivery jobs

The TRC_GUI_*.log file reveals TWO errors:

INFO   | CRecImpl_OracleCreate() enter - (delete from ca_agent where domain_id=1523357064) (3 1 2)
DETAIL | CDb_Oracle::IsOpen entering
ERROR  | ERROR:OCIStmtExecute() failed
NOTIFY | Custom Error Message: ORA-20999: Error 9011: Cannot remove the computer because of active Software Delivery jobs
...
ERROR  | ERROR:OCIStmtExecute() failed
NOTIFY | Custom Error Message: ORA-20000: Error 9004: deletion denied, ca_agent object still exists

Environment

Client Automation (ITCM) -- any version

Cause

There is some data in the usd_applic table for software delivery, for some agent records on the Enterprise manager, that are causing the unlink to fail.

Resolution

Manually clear the software delivery data from the Enterprise, by running this delete statement:

delete from ca_agent where domain_id=1523357064

The domain_id will come directly from the error message in the TRC_GUI log.  See the log sample above, where the domain_id is in BOLD.

Once the software delivery data is deleted, repeat the unlink operation.