ESX Upgrade and interop compatibility checks failed - ESX upgrade bundle is not compatible with your existing version

Products

• VMware SDDC Manager

Issue/Introduction

• ESXi upgrade prechecks fail with the below error :-
  ESX upgrade bundle is not compatible with your existing version
• There is a mismatch for ESXi host FQDN in vCenter and SDDC.
  Example :- In vCenter inventory, the ESXi FQDN is esxi-4.lab.com and in SDDC, it is ESXI-4.lab.com
  
• Below errors are seen in /var/log/vmware/vcf/lcm/lcm.log
  Compatibility checks failed for ESX at ESX_UPGRADE_VUM_STAGE_PRECHECK . Due to error: Cannot invoke "com.vmware.evo.sddc.common.version.VMwareProductVersion.hashCode()" because "this.version" is null

Environment

• VCF 5.2.0

Cause

This is caused by a mismatch in ESXi hostname between the managing vCenter Server and the SDDC database.

Resolution

Update the ESXi hostnames in the SDDC Database to match that of the vCenter Server.

Warning: Any edit of the database does come with risks.  Ensure you have taken a proper backup or snapshot of the SDDC Manager before beginning the steps below.  

1. SSH to the SDDC manager with the VCF user, elevate to root, and connect to the postgres database using the following command:
/usr/pgsql/13/bin/psql -U postgres -h localhost -d platform

2. List out the current ESXi hosts and their IDs: 
select id,hostname from host;

Example output:
select id,hostname from host;

                  id                  |       hostname        
--------------------------------------+-----------------------
 ########-####-####-####-74f4adc62111 | esxi-1.lab.com       
 ########-####-####-####-0d6cd6979cf5 | esxi-2.lab.com        
 ########-####-####-####-b98cc35bc935 | esxi-3.lab.com 
 ########-####-####-####-6a825e538b50 | ESXI-4.lab.com

3. Using the ID from step 2, update the hostname for the target ESXi host within the database:
update host set hostname='esxi-4.lab.com' where id='########-####-####-####-6a825e538b50';

4. Confirm the change by listing out the hosts again from the database:
select id,hostname from host;

Example output: 
select id,hostname from host;

                  id                  |       hostname        
--------------------------------------+-----------------------
 ########-####-####-####-74f4adc62111 | esxi-1.lab.com       
 ########-####-####-####-0d6cd6979cf5 | esxi-2.lab.com        
 ########-####-####-####-b98cc35bc935 | esxi-3.lab.com 
 ########-####-####-####-6a825e538b50 | esxi-4.lab.com
 
5. Quit the database prompt: 
\q

6. Restart the SDDC Manager services:
/opt/vmware/vcf/operationsmanager/scripts/cli/sddcmanager_restart_services.sh