Add host to cluster in SDDC Manager is failing at - Validate IP Address Availability for Edge Overlay (TEP) IP Assignment

Products

• VMware Cloud Foundation

Issue/Introduction

• Add host to cluster in SDDC Manager is failing at

  Validate IP Address Availability for Edge Overlay (TEP) IP Assignment

   

• Error in SDDC Manager UI

  Message: Failed to get {0} data from the logical inventory
  Remediation Message: Verify the common services app's health and retry the request
  Reference Token: #####
  Cause:

   

• Add host wizard in SDDC Manager shows the warning message
  
  
  
  
• Error in SDDC Manager /var/log/vmware/vcf/domainmanager/domainmanager.log

  ERROR [vcf_dm,##############,d90b] [c.v.v.h.a.h.NsxtIpAssignmentValidationAction,dm-exec-14]  Failed to fetch the the IP pool for validation
  com.vmware.evo.sddc.common.services.error.SddcManagerServicesIsException: Failed to get VDSes data from the logical inventory
          at com.vmware.evo.sddc.common.services.adapters.inventoryservice.InventoryServiceAdapterImpl.getVdsUsedByNsxOverlayForCluster(InventoryServiceAdapterImpl.java:1209)
          
  Caused by: java.util.NoSuchElementException: No value present
          at java.base/java.util.Optional.get(Optional.java:143)
          at com.vmware.evo.sddc.common.services.adapters.inventoryservice.InventoryServiceAdapterImpl.getVdsUsedByNsxOverlayForCluster(InventoryServiceAdapterImpl.java:1204)
          ... 18 common frames omitted
  		
  ERROR [vcf_dm,##############,d90b] [c.v.e.s.o.model.error.ErrorFactory,dm-exec-14]  [2470D5] FAILED_TO_FETCH_INVENTORY_DATA Failed to get {0} data from the logical inventory
  com.vmware.evo.sddc.orchestrator.exceptions.OrchTaskException: Failed to get {0} data from the logical inventory

Environment

VMware Cloud Foundation

Cause

• transportType mismatched between SDDC Manger database and NSXT Manager
  • transportType OVERLAY incorrectly tagged as VLAN in SDDC Manager database

Resolution

Update SDDC Manager database to update the transportType in vds table

Follow the below steps:

1. Take snapshot of SDDC Manager VM
2. SSH to SDDC Manager using vcf and su to root
3. List the vds details from vds table in SDDC Manager platform database

   psql -h localhost -U postgres -d platform -c "select id,name,nsxt_switch_config from vds where name='<vds name in vSphere inventory>'"

   Sample output

   psql -h localhost -U postgres -d platform -c "\x" -c "select id,name,nsxt_switch_config from vds where name='sample-nsx-vds'"
   
   id                 | ba7c####-####-####-####-########6c66
   name               | sample-nsx-vds
   nsxt_switch_config | {"transportZones":[{"name":"sample-tz-overlay01","id":"4530####-####-####-####-########0ad2","transportType":"VLAN"},{"name":"sample-tz-vlan02","id":"a556####-####-####-####-########2000","transportType":"VLAN"}]}

    

   Here transportzone sample-tz-overlay01 is incorrectly tagged as VLAN. Validate the details from NSXT Manager UI (System > Fabric > Transport Zones)

4. Update transportType as OVERLAY in SDDC Manager database

   psql -h localhost -U postgres -d platform -c "update vds set nsxt_switch_config='<updated switch config with transportType OVERLAY>' where id='<id of vds from step# 3>'"

   
   Sample

   psql -h localhost -U postgres -d platform -c "update vds set nsxt_switch_config='{"transportZones":[{"name":"sample-tz-overlay01","id":"4530####-####-####-####-########0ad2","transportType":"OVERLAY"},{"name":"sample-tz-vlan02","id":"a556####-####-####-####-########2000","transportType":"VLAN"}]}' where id='ba7c####-####-####-####-########6c66'"

    

5. Retry the host add from SDDC Manager