In the SDDC Manager UI - vCenter Server status appears as ‘Not Available’

Products

• VMware SDDC Manager
• VMware vCenter Server

Issue/Introduction

Following the breaking of Enhanced Linked Mode (ELM) between VCF instances management VC nodes, the vCenter Server component under the Management Domain marked as "Not Available" in the SDDC Manager interface.

Navigate to INVENTORY > WORKLOAD DOMAINS > MGMT-DOMAIN > SERVICES > COMPONENT

Environment

SDDC Manager 5.x

VMware vCenter Server

Cause

Database query output confirms the Management Domain vCenter is in an ERROR state,

• Connect to Platform DB to validate the status,
  
  

• • Connect to the SDDC Platform database:
    • psql -h localhost -U postgres -d platform

• • # select * from vcenter ;
                  id                  | creation_time | modification_time | bundle_repo_datastore | datastore_name  | ssh_host_key | ssh_host_key_type | status |
   type    |       version        |          vm_hostname           | vm_management_ip_address |  vm_name   | join_sso_status
--------------------------------------+---------------+-------------------+-----------------------+-----------------+----------

#########-5550-43da-ae36-###########| ######## | lcm-bundle-repo       | vSAN_DS_Name |              |          ssh-rsa      | ERROR|
MANAGEMENT | 8.0.3.00300-#######| vCSA_FQDN> | ##.##.###.##| vCSA_FQDN>|

Resolution

Follow below steps to resolve the issue,

1. Take a Snapshot of SDDC Manager.

2. Connect to the PostgreSQL database:

   • psql -h localhost -U postgres -d platform

   • select vm_hostname,id,status from vcenter;


3. Update the vCenter Status to ACTIVE:

   • update vcenter set status = 'ACTIVE' where id = '<Management_vCenter_ID>';


4. Verify the status and quit from DB:

   • select vm_hostname,id,status from vcenter;

   • \q

5. Restart LCM service;

   • systemctl restart lcm