Attempting to remove a Network Pool in Cloud Director may return error: "Cannot delete network pool {Network Pool Name}. it's in use currently, has networks"

Products

• VMware Cloud Director

Issue/Introduction

• Attempting to remove a Network pool the following error is displayed:

Cannot delete Network Pool : name:Example-VXLAN-NP , Id:urn:uuid:1<NetworkPool_UUID> , Description:. Its in use currently, has networks:
[[ Name: Network_name_1, id: urn:uuid:<Network_UUID_1>, deployState: null ] :
[ Name: Network_name_2, id: urn:uuid:<Network_UUID_2>, deployState: null ] :
[ Name: Network_name_3, id: urn:uuid:<Network_UUID_3>, deployState: null ] :
[ Name: Network_name_4, id: urn:<Network_UUID_4>, deployState: null ] :
[ Name: Network_name_5, id: urn:uuid:<Network_UUID_5>, deployState: null ]

Environment

VMware Cloud Director 10.x

Cause

This issue occurs when Cloud Director believes there are Networks still deployed which are consuming the Network Pool.

Resolution

1. Connect to the Cloud Director Database

sudo -i -u postgres psql vcloud

     2. Run the following to see what is mapped to the Network Pool

select
real_network.id as real_network_id,
real_network_backing.id as real_network_backing_id,
logical_network.id as Logical_Network_id,
logical_network.scope_type as logical_network_type,
logical_network.name as logical_network_name,
vmc.name as vApp,
ovdc.name as VDC
from network_pool
left join real_network on real_network.pool_id = network_pool.id
left join real_network_backing on real_network_backing.rnet_id = real_network.id
left join logical_network on logical_network.rnet_id = real_network.id
left join vapp_logical_resource vapplr on vapplr.fo_id = logical_network.id
left join vm_container vmc on vmc.sg_id = vapplr.vapp_id
left join org_prov_vdc ovdc on ovdc.id = vmc.org_vdc_id
where network_pool.name ='<network pool>';

     3. If there are references for vApp, you will need to remove these from the UI.
     4. When there are no vApps listed, attempt to remove the Network Pool from the UI.
     5. If you have removed all vApps and it is still failing, please contact Broadcom Support