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"

book

Article ID: 109956

calendar_today

Updated On:

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

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.

Environment

Client Automation (ITCM) -- any version

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.