Receiving Error: The Domain Cannot be Removed Because of Existing Software Delivery(SD) Distributions[CMM000247]

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

When trying to unlink a Domain Manager from the Enterprise Manager the  following error message pops up:                                                             

The domain cannot be removed because of existing Software Delivery distributions.[CMM000247]      

 

Environment

CA Client Automation - All versions

Resolution

  To unlink  the DM from the Enterprise server 

      
 1.Open SQL studio manager on the Enterprise Manager and run this query :    
             

use mdb                                                                
 select * from ca_n_tier                                                    
                                                                            
 This will show the domain managers that are linked to this server.          
 Note the <domain_uuid> of the DM you are trying to remove.                        

    

                     
                                              
 2. Then run this Query                                                     
  

 use mdb                                                                          
 DELETE FROM usd_cc WHERE boundto=  <domain_uuid>

Use the domain UUID obtained from the first query and execute the delete statement.                                        
Then go back into the DSM Explorer and unlink the Domain Manager from the Enterprise Manager.        

                                                          
                                                                         
NOTE:  Please do a complete SQL backup of the mdb before doing the above procedure so we have a fallback in case of an unforeseen issue.