"Invalid URL parameters provided to construct NSX url" under "Segment Profiles"

Products

• VMware Cloud Director

Issue/Introduction

• Under  tenant portal > Data Centers > Networks > vCD Network > Segment Profiles, vCloud Director UI displays following error:

 java.lang.IllegalStateException: Invalid URL parameters provided to construct NSX url - Invalid URL parameters provided to construct NSX url 

 

Environment

VMware Cloud Director 10.3.3

Cause

This issue occurs because the segment ID is missing from the vCloud Director database, making it impossible to construct the URL

Resolution

1. Take a backup of Cloud Director database
   

   /opt/vmware/appliance/bin/create-backup.sh

2. Connect to the database on the primary cell:
   

   sudo -i -u postgres psql vcloud

3. Run the below commands:
   

   SELECT real_network.id,opaque_network_inv.name, opaque_network_inv.moref,real_network.name AS real_network_name, real_network.portgroup_moref,real_network.logical_switch_id
   FROM opaque_network_inv
   LEFT JOIN real_network ON real_network.logical_switch_id = opaque_network_inv.network_id
   WHERE real_network.name IN (select name from real_network where id in (select rnet_id from logical_network where name in (select name from real_network where portgroup_moref IS NULL) and scope_type=2))
       
   ORDER BY opaque_network_inv.moref ;

   Note: All displayed results will be networks without any reference to the 'portgroup_moref' (segment id) inside the table 'real_network'

   
4. To get the missing values, open in the browser the following url:
   

   https://<vc-url>/mob/?moid=network-XXX

   Note: Replace 'network-XXX' by the appropriate value from Step3, column 'moref'

5. click the property "extraConfig[com.vmware.opaquenetwork.segment.path]"
6. take note of the 'segment_id' which can be seen here: '/infra/segments/<segment_id>"
7. Update vCloud Director database with appropriate missing value:
   

   UPDATE real_network 
     SET portgroup_moref = 'segment_id from STEP6'
     where id = 'id from STEP3';

   Note: id will come from Step3,from row where it matches with 'moref' from Step4

8. Refresh the vCloud Director UI