Error:"Not able to delete VRP with id ########-####-####-####-############ " when running fix-mismatch-with-vc

Products

• VMware Cloud Director

Issue/Introduction

When attempting to run the Cell Management tool fix-mismatch-with-vc the following error is generated:

        /opt/vmware/vcloud-director/bin/cell-management-tool detect-rp-mismatches --fix-mismatch-with-vc
     Row with VRP.id = ########-####-####-####-############ is not referenced by table ORG_PROV_VDC.
     Delete stale row? y
     Not able to delete VRP with id ########-####-####-####-############.
     Finished fixing resource pool mismatches with VC.

Environment

VMware Cloud Director 10.x

Cause

The resource pool could not be deleted due to stale VM records in the computevm table. The organization VDC(OVDC) where these VMs were present was deleted.

Resolution

Database modification is needed to resolve this issue to set the enabled flag to false. Please contact Broadcom Support and note this Article ID (368325) in the problem description. For more information, see Creating and managing Broadcom support cases