Unable to Unregister vCenter in VCD due to Error "VC [vCenter Name] still contains references to resolved VMs"

Products

• VMware Cloud Director

Issue/Introduction

• For this vCenter all VMs have been moved or deleted.
• For this vCenter all vApps have been removed.
• For this vCenter all Networks have been removed.
• For this vCenter all Catalogs have been removed.
• When removing vCenter getting the Error in the UI -

         "VC [vCenter Name] still contains references to resolved VMs"

Environment

• VMware Cloud Director 10.6.x
• VMware Cloud Director 10.5.x

Cause

References in the DB still exist between the vCenter that is being Unregistered and Cloud Director's list of active VMs.

Resolution

To investigate and remove still referenced Resolved VMs, please contact Broadcom Support and reference this KB Article

Additional Information

1. SSH into the primary DB cell and enter PostgreSQL with:      db
2.  Identify the ID of the vCenter using the following, substituting [vCenter Name] referenced in Error

     select id,name from virtual_center where name = '[vCenter Name]';

     3. Find Resolved VMs tied to the vCenter, substituting [vCenter ID] from the previous SQL:

     select name from vapp_vm where svm_id in (select id from vm where vc_id = '[vCenter ID]');

     select * from vm where vc_id = '[vCenter ID]';

The above SQL will give an idea of the VMs that are still referenced by the vCenter.