Hi, recently I found the issue with deleting the Endpoint from vRA 7.4 but also heard that this issue exist in other version so I thought that good to will be describe this behavior and show how I resolved this.
I had problem with one of my endpoint which I wanted to delete so basicaly I deleted all Compute Resource, all Fabric Group, all Business Group, Reservation and so on. But still had statement that for my endpoint there is a connection with active or non-active Compute Resources.
To resolve issue with vmware technology as always I searched vmware kb and found KB2150548
In this KB we have information how to delete endpoint with Cloud Client. So as they said I downloaded CC in version 4.4 and 4.6 and following the steps, I tried delete Endpoint. Unfortunatelly in my case this also not worked with few errors
I started dig in and saw another error in vRealize Appliance logs which forced me to think. How looks the DB fo vRA. Because error talked that there is a Reference in vcac DB
So do not think any more I’ve login to the vRA SQL and searching for that table dbo.Host and tried to delete this information about my vCenter Cluster assigned to vRA
This was not easy because there was many other Reference with other table but after deleted all I was able to delete main row from dbo.Host.
My reference was:
dbo.ManagementEndpoint
dbo.ResourcePool (all ResourcePools and vApp from vCenter)
dbo.VirtualMachin (all VM from vCenter cluser)
After delete that row I was able to delete endpoint from vRealize Portal and create the new one with same data