Error: "Selected hosts do not match existing host network pool network-pool-######## in cluster" when adding a vSAN host to a cluster in SDDC Manager

Products

• VMware SDDC Manager / VCF Installer

Issue/Introduction

• Adding a commissioned host to a cluster in SDDC Manager fails during the 'Validate Cluster Expansion Specification' validation check with the following error: "Selected hosts do not match existing host network pool network-pool-######## in cluster"
  
  
  
  
• Checking the host_id and the associated network_pool_id in the host_and_network_pool table of the SDDC Manager platform database reveals that the affected host is part of a stale network pool.

1. 1. SSH into the SDDC Manager, login as vcf, and elevate to root with the command: su root
   2. Access the platform database using the following command: psql -h localhost -U postgres -d platform
   3. Retrieve the host ID using the ESX FQDN by running the following command: select id, hostname, status FROM host WHERE hostname = 'ESX_FQDN';
   4. Using the host ID, identify the associated network pool: select id, host_id, network_pool_id  FROM host_and_network_pool where host_id = 'host_id';

Environment

VMware Cloud Foundation (VCF) 9.1

Cause

The target host remains associated with a stale or incorrect network pool entry within the SDDC Manager database. This configuration mismatch prevents the host from aligning with the active network pool of the destination cluster.

Resolution

If the symptoms outlined above occur, contact Broadcom Technical Support for further assistance, as the resolution involves modifying the SDDC database instance and must be performed with caution.