Merging pVDCs fails with a validation error

Products

• VMware Cloud Director

Issue/Introduction

When merging 2 PVDCs in vCloud Director, you see the following error:
“Validation errors during merge of provider VDC, cannot merge provider VDCs because non elastic OVDCs (Reservation Pool or non elastic allocation Pool) exists in the provider VDC to be merged. Merging of Provider VDCs that contain Reservation Pool Org VDCs is not supported”.

Environment

VMware Cloud Director 10.x

Cause

This issue can occur when there are stale entries present in the VMware Cloud Director database even after deleting the non-elastic OVDCs.

Resolution

To resolve the issue, use one or both of the following procedures:

Case 1: Objects in Deleted_object table are not clearing even after multiple attempts.

Perform a force delete from the vCD UI under system > Stranded items 

Case 2: For a particular OVDC, if there is a stale entry left in the VRP table, the following query returns data for OVDCs that no longer exist in the environment:

select vrp.* from prov_vdc_logical_resource join prov_vdc on prov_vdc.id = prov_vdc_logical_resource.prov_vdc_id
and lr_type = 'COMPUTE_HUB_SET' and prov_vdc.name = '<pvdc_name>'
join vrp on vrp.computehub_set_id = fo_id

If the above query returns entries, please open a Support Request with Broadcom Technical Support and note this Article ID (305367) in the problem description. For more information, see Creating and managing Broadcom support cases.