NSX Edge node password update in SSDC manager fails with an error "Unable to find edge cluster with name "edge test client"

Products

• VMware SDDC Manager

Issue/Introduction

This article provides the steps to validate and compare Edge cluster node name in SDDC/NSX UI with SDDC database. The conflict of the names is only observed in SDDC database wherein the desired/correct name reflects in SDDC/NSX UI. 

Note: Please avoid making any changes to the database if the above conflict doesn't match 

 

Confirm Edge cluster name by navigating to NSXT UI > System > Fabric > Nodes > Edge Cluster

In the above example we see, Edge cluster name as "Edge test server" and "Edge test client". In comparison to the database, correlating with its associated ID, the name differs. 

You will find the name mismatch mentioned in operationsmanager.log, similar to below entries. 

less /var/log/vmware/vcf/operationsmanager/operationsmanager.log

YYYY-MM-DDThh:mm ERROR [vcf_om,67b4f36e4c4XXXd8cef512f57cbc4ff9,ef45] [c.v.v.p.u.changers.NsxtEdgeChanger,om-exec-28] Exception occurred while changing NSXT Edge node credentials java.lang.IllegalArgumentException: Unable to find edge cluster with name edge-test-corp

Environment

SDDC Manager 4.x & 5.x

Cause

Edge cluster name mismatch in SDDC Manager Platform DB

Resolution

 

Note: Take snapshot of SDDC Manager before making any changes to SDDC DB

 

1. SSH to SDDC manager with VCF user and su to root

2. Connect to SDDC database using command

psql -h localhost -U postgres -d platform

3. Run below command to get edge cluster information in SDDC

select id,status,name from nsxt_edge_cluster;

Note: From the below output we see, the Edge cluster names are different in SDDC database and NSXT (NSXT UI > System > Fabric > Nodes > Edge Cluster)

2864a7c0-XXXX-4ele-9cc0-1c441338d93e | status | ACTIVE | edge test corp - - - - - - - This is the conflicting name 

b6989193-aa87-4d2c-XXXX-0f1c72ffbef4 | status | ACTIVE | edge test client 

4. Make a note of the Cluster id (Refer to the above output shown in step 3)

5. Run below command to change edge cluster name in SDDC database to match the one configured in NSXT UI

update nsxt_edge_cluster set name='edge-node1' where id='2864a7c0-XXXX-4ele-9cc0-1c441338d93e' (Cluster id from step 3)