Error "update or delete on table "virtual_center" violates foreign key constraint "fk_vm_virtualcenter" on table "vm"" while unregistering the vCenter from VCD

Products

• VMware Cloud Director

Issue/Introduction

• While attempting to unregister the vCenter in VMware Cloud Director, it fails with an error: update or delete on table "virtual_center" violates foreign key constraint "fk_vm_virtualcenter" on table "vm"

• From "/opt/vmware/vcloud-director/logs/vcloud-container-debug.log", you will notice following exception while unregistering the vCenter:

ERROR    | task-service-activity-pool-699 | JDBCExceptionReporter  | ERROR: update or delete on table "virtual_center" violates foreign key constraint "fk_vm_virtualcenter" on table "vm"

Detail: Key (id)=(#########-####-####-####-##########) is still referenced from table "vm". | requestId=########-####-####-####-############,request=POST https://VCD_URL/api/admin/extension/vimserver/########-####-####-####-##########/action/unregister,requesttime=##########,remoteaddress=xx.xx.xx.xx:33728,useragent=mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (...,accept=application/*+json;version 38.0.0-alpha vcd=########-####-####-####-############,task=########-####-####-####-############ activity=(com.vmware.vcloud.backendbase.management.system.TaskActivity,urn:uuid:########-####-####-####-############)

Environment

VMware Cloud Director 10.x

Cause

This issue occurs when there are still vm objects in the database which are referencing to this vCenter that most likely have not been deleted. 

Resolution

1. This requires modification of the Cloud Director database
2. Take a backup of Cloud Director before proceeding. For Appliance based Cloud Director Cells see the VMware Cloud Director documentation, Backup and Restore of VMware Cloud Director Appliance
3. For assistance, contact Broadcom Support and note this Article ID (378732) in the problem description. For more information, see Creating and managing Broadcom support cases