Host details on SDDC Manager UI displays empty (-)

Products

• VMware Cloud Foundation
• VMware SDDC Manager

Issue/Introduction

• After a host is reconfigured outside SDDC/ VCF Operations UI, the details of the host (Network Pool, Configuration State, Domain Name) is blank.
• On SDDC Manager UI, navigate to Inventory > Hosts > Assigned Hosts :   
  
  

Cause

The host ID in the platform database on the SDDC Manager, does not match the host id of the host from the vCenter Server. 

Resolution

Proceed to update the host ID on the SDDC Manager database to match with the vCenter Server database.

1. SSH to vCenter Server with root credentials.
2. Run the following command to obtain the correct ID for the host that has the details missing :
   /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres -c "select id,name from vpx_entity where type_id=1"
   
   
3. SSH into the SDDC Manager as vcf user and use the su command to elevate to root.
4. Run the following command to obtain the ID of the affected host in SDDC Manager : 
   psql -h localhost -U postgres -d platform -c "select * from host where hostname='<host_FQDN>'"
   
   
5. Take snapshot of the SDDC Manager VM.
6. Run the following command to update the affected host's ID in SDDC Manager :
   psql -h localhost -U postgres -d platform -c "update host set source_id='host-<id from Step 2>' where source_id='<id from Step 4>'"
   
   
7. Restart the services on the SDDC Manager :
   /opt/vmware/vcf/operationsmanager/scripts/cli/sddcmanager_restart_services.sh