search cancel

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

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.