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"

Document ID : KB000109956
Last Modified Date : 09/08/2018
Show Technical Document Details
Issue:
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.