"Source vCenter Server has unsupported version of host" error while upgrading to vCenter Server 6.7

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• Upgrading to vCenter Server 6.7 fails with this Pre-Check error:
  
  "Source vCenter Server has unsupported host version"
   
• In the vcdb_req.err log file, you see entries similar to:
  
  WARNING: esx-version -> 5.5.0 host IP: 192.168.11.84
  ERROR: wrong-host-version-count -> 1

Environment

VMware vCenter Server Appliance 6.7.x
VMware vCenter Server 6.7.x

Cause

This issue occurs because vCenter Server 6.7 does not support ESXi 5.1 and 5.5 host. Ensure that there is no reference of ESXi 5.1, 5.5 host or the details in host profile or image profile.

Resolution

To resolve this issue:

Note: If there is any ESXi host running on version 5.1 or 5.5, remove it from the inventory and retry the upgrade else perform the steps below.

1. Take a snapshot of the Source vCenter Server.
2. Take SSH/Putty session to source vCenter Server.
3. Connect to VCDB by running this command:
   
   /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres

4. Run the below command to check id and product version from vpx_host table:
   
   VCDB=# select id,product_version from vpx_host;
   You may see output similar to:
   -[ RECORD 1 ]---+------
   id              | 12
   product_version | 5.5.0
   -[ RECORD 2 ]---+------
   id              | 28
   product_version | 6.5.0

5. Update the product version using below command if the ESXi host:
   
   VCDB=# update vpx_host set product_version='6.5.0' where id = 12;
   You may see output similar to:
   UPDATE 1

6. Proceed with upgrading the vCenter Server to 6.7.