thehaverer
Contributor
Contributor

Can't delete Organization

Hi, I have a vCloud setup but I want to scrap it and start again.  I have removed all the vApps, Media and disks but cannot delete anything else.

When I try to delete the Organization VDC is says: "you must remove all edge gateways, networks, vApps, media and disks from this VDC before you can delete it". 

However If I try to remove the edge gateway I get:  Edge gateway has org VDC Networks attached to it.  Please delete the network(s) before attempting to delete the edge gateway".

Any thoughts??

0 Kudos
24 Replies
jlabonte
Contributor
Contributor

not shared.

Might have to dig in the db? yelp?!

Sent from Samsung Mobile

0 Kudos
admin
Immortal
Immortal

I would recommend opening up a Support Request with VMware support. We can dive into the DB if necessary but may be worth while having us look first hand to see what's up.

-Eric

0 Kudos
jlabonte
Contributor
Contributor

a call ticket was opened an hour ago with vmware.

waiting for a call back.

I'll do a webex with anyone at this point. Smiley Happy

Sent from Samsung Mobile

0 Kudos
jlabonte
Contributor
Contributor

thanks Eric, I appreciate the quick reply.

Sent from Samsung Mobile

0 Kudos
jlholbrook
Enthusiast
Enthusiast

I've fixed this in vCD 5.x+ using MS-SQL with the following query, if you are familiar with T-SQL this should help guide you in the right direction. Take a backup before modifications and keep in mind this is not provided as a supported solution from VMware. As such, I can't be held responsible for any issues this causes, I have the luxury of a non-production environment.

--OLD OrgvDC you are prevented from deleting

DECLARE @oldOrgvDCname AS varchar

SET @oldorgvdcname = 'Cloud ServiceFabric Development'

--A New OrgvDC within the same datacenter (Shared Networks)

DECLARE @newOrgvDCname AS varchar

SET @newOrgvDCname = 'CSF-Demonstration-OrgvDC01'

-- Replace the Logical Resource Mapping

UPDATE dbo.vdc_logical_resource

SET vdc_id = (Select id from org_prov_vdc Where name = @newOrgvDCname)

WHERE lr_type = 'NETWORK' AND vdc_id = (Select id from org_prov_vdc Where name = @oldorgvdcname)

-- From here you should be able to delete the empty OrgvDC.

0 Kudos