Resolve Enhanced Linked Mode (ELM) Drift for Upgraded vCenter Instances Fails with 'BREAK_ELM_ONLY_SUPPORTED_ON_JOINED_MGMT_SSO'

Products

• VMware SDDC Manager / VCF Installer
• VMware Cloud Foundation

Issue/Introduction

• When attempting to resolve Enhanced Linked Mode (ELM) drift for upgraded vCenter instances in VMware Cloud Foundation 9.0.x, the task fails.
• /var/log/vmware/vcf/domainmanager/domainmanager.log on the SDDC Manager contains the following error stack:

  YYYY-MM-DDTHH:MM:SS..061+0000 ERROR [vcf_dm,############,####] [c.v.v.v.c.v1.DomainController,http-nio-127.0.0.1-7200-exec-1]  Failed to update Domain ########-####-####-####-############
  com.vmware.evo.sddc.common.services.error.SddcManagerServicesIsException: Domain LDC1M01 is not joined to the management SSO (ELM).
  
  YYYY-MM-DDTHH:MM:SS..063+0000 DEBUG [vcf_dm,############,####] [c.v.e.s.e.h.LocalizableRuntimeExceptionHandler,http-nio-127.0.0.1-7200-exec-1]  Processing localizable exception Domain LDC1M01 is not joined to the management SSO (ELM).
  YYYY-MM-DDTHH:MM:SS..064+0000 ERROR [vcf_dm,############,####] [c.v.e.s.e.h.LocalizableRuntimeExceptionHandler,http-nio-127.0.0.1-7200-exec-1]  [NCCFL7] BREAK_ELM_ONLY_SUPPORTED_ON_JOINED_MGMT_SSO Domain Domain_Name is not joined to the management SSO (ELM).

Environment

VMware Cloud Foundation 9.0.x

Cause

• This issue occurs because the join_sso_status field for the vCenter Server entries in the SDDC Manager platform database is NULL. Because this field is empty, SDDC Manager does not recognize the domain as being joined to the management SSO, preventing the ELM drift resolution process from proceeding.

Resolution

• To resolve this issue, manually update the join_sso_status in the SDDC Manager platform database.
  
  1.Take a snapshot of the SDDC Manager VM before proceeding with database modifications.
  2.Log in to the SDDC Manager via SSH as the vcf user and switch to root.
  3. Access the platform database:

  psql -h localhost -U postgres -d platform

  4. Identify the affected vCenter entries and verify the current status:

  select id, vm_hostname, join_sso_status from vcenter;

  5. Update the join_sso_status field to 'JOINED' for the specific vCenter IDs identified in the previous step:

  update vcenter set join_sso_status = 'JOINED' where id='[vCenter_ID]';

  6. Once verified, exit the PostgreSQL interface:

  \q

  7. Retry the Resolve Enhanced Linked Mode (ELM) Drift task from the SDDC Manager UI.Resolve Enhanced Linked Mode (ELM) Drift for Upgraded vCenter Instances