VMware Update Manager (VUM) Service fails to start with error: "Element with same name already exists"

Products

• VMware vCenter Server
• VMware vCenter Server 7.0
• VMware vCenter Server 8.0

Issue/Introduction

• Unable to start the Update Manager service
• vCenter - /var/log/vmware/vmware-updatemgr/vum-server/vmware-vum-server.log

YYYY-MM-DDTHH:MM:SS info vmware-vum-server[133951] [Originator@6876 sub=BaselineMgr] [baselineMgr 5292] Migrating baseline, id: 361, name: ESXi80U3b-24280767
YYYY-MM-DDTHH:MM:SS verbose vmware-vum-server[133951] [Originator@6876 sub=BaselineMgr] [baselineMgr 1255] Got spec for baseline id: 361, name: ESXi80U3b-24280767
YYYY-MM-DDTHH:MM:SS info vmware-vum-server[133951] [Originator@6876 sub=BaselineMgr] [baselineMgr 5440] Data migration, update baseline for : 361, name: ESXi80U3b-24280767
YYYY-MM-DDTHH:MM:SS error vmware-vum-server[133951] [Originator@6876 sub=BaselineMgr] [baselineMgr 1930] Vcidb ERROR: Element with same name already exists - ESXi80U3b-24280767
-->
-->  Exiting....
-->
YYYY-MM-DDTHH:MM:SS error vmware-vum-server[133951] [Originator@6876 sub=BaselineMgr] [baselineMgr 1930] [backtrace begin] product: VMware Update Manager, version: 8.0.3, build: build-24091160, tag: vmware-vum-server, cpu: x86_64, os: linux, buildType: release
--> backtrace[00] libvmacore.so[0x00530335]

--> [backtrace end]
YYYY-MM-DDTHH:MM:SS error vmware-vum-server[133951] [Originator@6876 sub=VcIntegrity] [vcIntegrity 765] Error is start vum server :Fault cause: vim.fault.AlreadyExists

Resolution

Note: Ensure a valid backup of the vCenter Server(s) or a powered off snapshot has been taken before proceeding as the below steps involve modification of the vCenter Server database.

Identify and delete the duplicate baseline entry.

1. SSH to the vCenter via root
2. Stop the Update Manager Service
   
   service-control --stop vmware-updatemgr
   
   
3. Log in to the VMware Update Manager database. Refer to Accessing the vSphere Lifecycle Manager Database using vumuser.
4. To list the baselines with same name, run the following command:
   
   select id,name from VCI_BASELINES where name='<name of baseline>';
   
   Example
   
select id,name from VCI_BASELINES where name='ESXi80U3b-24280767';

id  | name
----+--------------------
361 | ESXi80U3b-24280767
360 | ESXi80U3b-24280767
   
   
5. Delete the duplicate entry:
   
delete from VCI_BASELINES where id=<id value>; 
   
   Example

delete from VCI_BASELINES where id=361;
   
   
6. Start the Update Manager Service
   
   service-control --start vmware-updatemgr