Error "Organization vDC compute policy is being used by VMs. Before deleting, remove all VMs from this policy" thrown when trying to delete Provider VDC

Products

• VMware Cloud Director

Issue/Introduction

• Error about VMs using vGPU profile, when trying to delete PvDC with OvDC and vGPU profile
• The Provider VDC was removed from the vGPU profile scope
• The following error is displayed when attempting to remove the Provider VDC:
  
  Internal Server Error
 - could not delete: [com.vmware.vcloud.common.model.vdc.ProviderVdcModel#xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx]
 - ERROR: update or delete on table "vdc_compute_policy" violates foreign key constraint "fk_vapp_vm2vdc_comp_poli" on table "vapp_vm"
  Detail: Key (id)=(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) is still referenced from table "vapp_vm".

Environment

VMware Cloud Director 10.x

Cause

This is a known issue in Cloud Director 

The issue occurs only when you create a compute policy that is associated to a PVDC and then add further PVDCs in later time.

The vdc_compute_policy table shows the pvdc_id as the value of the original PVDC which should be set to NULL and causing the problem.

Resolution

To resolve this issue database modifications are required and this activity will require assistance from Broadcom Technical Support.

To proceed with the resolution, please contact Technical Support and reference Knowledge Article ID 373060 in the problem description.

For additional guidance, please refer to the article: How to Submit a Support Request.