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
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.
Client Automation (ITCM) -- any version
Manually clear the software delivery data from the Enterprise, by running this delete statement:
delete from ca_agent where domain_id=1523357064The 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.