Password operation in SDDC Manager fails with a reference to two powered-on VMs having the same FQDN.

Products

• VMware Cloud Foundation

Issue/Introduction

Symptoms:

• Error message seen in SDDC Manager UI:

Found 2 powered-on VMs with FQDN hostname.corp.local, should be 1.

• Logging found in /var/log/vmware/vcf/operationsmanager/operationsmanager.log:

2023-06-30T11:15:32.055+0000 DEBUG [vcf_om,ee75f942c2d6cf7a,12df] [c.v.v.p.helper.GuestProgramService,om-exec-12] Fetched list of powered on virtual machines [ManagedObjectReference: type = VirtualMachine, value = vm-14,
serverGuid = 12f0da5f-b7b5-4ceb-b45d-1d634ba79e8b, ManagedObjectReference: type = VirtualMachine, value = vm-74, serverGuid = 12f0da5f-b7b5-4ceb-b45d-1d634ba79e8b] whose DNS name prefixes FQDN hostname.corp.local from cluster PROD-Cluster-1

Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.

Environment

VMware Cloud Foundation 4.x

Cause

While fetching the list of virtual machines whose DNS name prefixes the FQDN, we are also returning virtual machines with an empty or blank DNS value.

Resolution

This has been resolved in VMware Cloud Foundation 4.5.1 and 5.0

Workaround:
Following steps make changes to the Postgres database. Always ensure recent backups are available prior to making any database edits.

Use the following steps as a workaround:

1. Open an SSH session to vCenter.
2. Connect to the VCDB:

/opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres
 

3. Retrieve the entries for the two VMs using the IDs found in operationsmanager.log:

select * from vpx_vm where id='74';
select * from vpx_vm where id='14';
 

4. Update the dns_name column with the relevant information:

update vpx_vm set dns_name='Relevant_FQDN' where id='74';
update vpx_vm set dns_name='Relevant_FQDN' where id='14';