SDDC - Unable to update NSX,vCenter or ESXi in one workload domain

Products

• VMware SDDC Manager

Issue/Introduction

During Plan Patching - Error: 
"Saving domain target version failed. Validation failures occurred while trying to save the target version: Domain WLD1 or some of its components are not in active state"

 

Environment

SDDC 5.2.x

Cause

Host entry in "ERROR" status:  

/usr/pgsql/13/bin/psql -U postgres -h localhost -d platform

select id, name, status from host where status != 'ACTIVE';

id                                   name                                            status

│ #########-######### │ dc-wld-esx##.rrrr.net     │ ###.##.##.#### │ 8.0.3-24674464 │ ERROR  │ f      │ ###.##.##.#### │ \N

Resolution

Workaround:

Collect a snapshot of the SDDC manager before the process, and run the command below on the SDDC manager CLI

# /usr/pgsql/13/bin/psql -U postgres -h localhost -d platform

update host set status = 'ACTIVE' where id = '<Host-ID>';

\q