Sddc manager stuck in expanding after attempting to expand an edge cluster in a federated environment

Products

• VMware SDDC Manager

Issue/Introduction

Federated environments will not allow the expansion via SDDC Manager

Environment

SDDC 5.x
NSX 4.x

Cause

Federated nsx edge clusters cannot be expanded or shrunk via sddc manager in version 5.2 and below

Resolution

1. Expand the NSX Edge Cluster by following:  Add an NSX Edge Node to an NSX Edge Cluster 
2. Create a snapshot on the SDDC Manager appliance
3. SSH into the SDDC Manager appliance
4. Connect to the platform database:
   psql -h localhost -U postgres -d platform
5. Query the platform database for edge clusters:
   select * from nsxt_edge_cluster;
6. Update the edge cluster and set it to active:
   update nsxt_edge_cluster set status='ACTIVE' where status !='ACTIVE';
7. Restart SDDC Manager services:
   /opt/vmware/vcf/operationsmanager/scripts/cli/sddcmanager_restart_services.sh