ESXi upgrade pre-check fails with error: Missing host <ESXi_FQDN> from the SDDC Manager inventory

Products

• VMware SDDC Manager
• VMware Cloud Foundation 5.x

Issue/Introduction

• ESXi host upgrade or Upgrade Pre-check fails with  error: Missing host <ESXI_FQDN> from the SDDC Manager inventory".
• In vCenter inventory the ESXi FQDN is esxi01.example.com and in SDDC it is ESXI01.example.com

 

Environment

VMware Cloud Foundation 5.x

Cause

The cause of the issue is due to a mismatch of ESXi host name.

ESXi host name in the vCenter Inventory differs with the host name in SDDC manager.

Resolution

1. Take snapshot of SDDC Manager VM
2. SSH to SDDC Manager with vcf and su to root
3. List the hosts and their ids from the host table (Here you will notice case sensitive difference in the host name.)

   psql -h localhost -U postgres -d platform -c "select id, hostname from host where hostname='ESXI01.example.com'"
   
   for VCF 5.1: 
   /usr/pgsql/13/bin/psql -h localhost -U postgres -d platform -c "select id, hostname from host where hostname='ESXI01.example.com'"

   Sample Output

                     id                  |          hostname
   --------------------------------------+-----------------------------
   ########-####-####-####-########35de | ESXI01.example.com

               

4. Update the host name with the one in the vCenter Inventory.

   psql -h localhost -U postgres -d platform -c "update host set hostname='esxi01.example.com' where id='<id of the host from Step # 3>';
   
   For VCF 5.1:
   /usr/pgsql/13/bin/psql -h localhost -U postgres -d platform -c "update host set hostname='esxi01.example.com' where id='<id of the host from Step # 3>';

5. Re-run the command in Step # 3 to ensure that the host names are updated correctly and matching with the ones in the vCenter Inventory.
6. Now update the hostname and the Keys leveraging fixHostKeys script following the steps mentioned in the KB How to update the SSH host keys on the SDDC Manager
7. Re-run the upgrade pre-check.