Unable to view ESXi host in list while trying to add host to cluster from SDDC

Products

• VMware SDDC Manager

Issue/Introduction

We can see the mentioned host as "Unassigned" under the list of hosts. 

However, when we try to add it to the cluster, it does not appear in the Host Selection list. 

 

 

Environment

SDDC Manager, VCF 4.x, 5.x

Cause

The primary datastore name has changed.

A new primary datastore is being used in the environment - this change has not been reflected in the SDDC Manager database.

Resolution

1. Take a snapshot of the SDDC Manager 
2. ssh to the SDDC Manager as vcf and su to root
3. Reflect the change in the datastore name in the SDDC Manager
4. Connect to the database - 
   • psql -U postgres -h localhost -d platform
5. Retrieve the information on the primary datastore name currently set -
   • select id,datacenter,name,primary_datastore_name from cluster where primary_datastore_name=´what_sddc_understands_it_to_be_currently`;
6. The command above returns an id xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
7.  Set the primary_datastore_name of id xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx to what the new primary datastore name is actually now
   • update cluster set primary_datastore_name='what_it_actually_is_now' where id ='xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx';
8. Exist the database -
   • \q

You should be able to see the host in the list now.