Error: "No row with the given identifier exists: [com.vmware.vcloud.common.model.logicalresource.StorageClassProviderVdcLogicalResourceModel" when removing Provider VDC

Products

• VMware Cloud Director

Issue/Introduction

• When removing Provider VDC, the following error is encountered:
  
  Error: No row with the given identifier exists: [com.vmware.vcloud.common.model.logicalresource.StorageClassProviderVdcLogicalResourceModel#xxxxxx-xxxxxxx-xxxxxxx-xxxxxxxxxxxx]
  
  
• Cannot provision or modify any VMs.

Environment

• VMware Cloud Director 10.x

Cause

Mismatch in the Logical Resources, essentially what is defined as the logical link between the physical resources and the provider VDC Resources.

Resolution

The following will give an output if there are any affected Logical Resources.

1. Connect to the database using the command: sudo -i -u postgres psql vcloud
2. Run the below query:

select plr.name from vdc_logical_resource vlr join prov_vdc_logical_resource plr on vlr.name = plr.name where vlr.prov_vdc_lr_id <> plr.id and vlr.prov_vdc_lr_id not in (select id from prov_vdc_logical_resource);

 

If any results are returned from the above query, then please Contact Broadcom Support to fix the Logical Resource links.