Error: Duplicate vROps entries and incorrect versioning (8.6.x) in SDDC Manager after Certificate Update

Products

• VMware SDDC Manager

Issue/Introduction

In VMware Cloud Foundation after performing a certificate replacement or "re-trust" operation for Aria Operations via Aria Suite Lifecycle (vRSLCM), the SDDC Manager UI displays duplicate entries for the Aria Operations component. One entry correctly reflects the current version (e.g., 8.18.5), while a stale entry persists showing an older version (e.g., 8.6.2). This inconsistency prevents subsequent lifecycle management tasks and disrupts the "Aria Suite" management view.

Environment

VMware Cloud Foundation (VCF) 4.x, 5.x

Aria Operations 8.18.5

SDDC 5.2.X

 

Cause

The root cause is a transactional failure in the SDDC Manager Inventory Service during the certificate "re-trust" phase. When certificates are updated, SDDC Manager must update the thumbprint and resource details in its internal database. If the API callback from vRSLCM to SDDC Manager fails to properly reconcile with the existing record, the system triggers "create" logic instead of "update" logic, resulting in a secondary row in the vrops table of the platform database.

Resolution

To resolve this issue, the stale record must be manually removed from the SDDC Manager platform database.

1. Pre-check: Take a non-memory snapshot of the SDDC Manager VM before proceeding.

2: SSH: Log in to the SDDC Manager via SSH as the vcf user and switch to root.

3:Identify the Stale Record

Access the PostgreSQL database and query the vrops table:

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

SELECT id, version, vrops_hostname, status FROM vrops;

5:Remove the Stale Entry
Execute the deletion using the specific ID of the stale record: DELETE FROM vrops WHERE id = '<STALE_ID_FROM_PREVIOUS_STEP>';

6:Restart SDDC Manager services to refresh the cache:

Bash
/opt/vmware/vcf/operationsmanager/scripts/cli/sddcmanager_restart_services.sh