Creating new replications results in the error 'Duplicate key host' and 'Unable to retrieve enhanced replication mappings data'

Products

• VMware Live Recovery

Issue/Introduction

Symptoms:
1. Unable to create new enhanced replications.

Error: "Unable to retrieve enhanced replication mappings data"

"A Runtime error occurred in the vSphere Replication Management Server. Exception deails: 'Duplicate key host-xxxx (attempted merging values 30004.0 and 30004.0)'.

2. Unable to reprotect recovered VMs.

 

/opt/vmware/log/hms.log:

2025-01-11 15:00:24.740 INFO  com.vmware.hms.i18n.class com.vmware.hms.response.filter.I18nActivationResponseFilter [tcweb-35](..response.filter.I18nActivationResponseFilter) [operationID=e25ade59-70f0-4c48-adaa-2a4826974e97-HMS-1116092,sessionID=897A51D7] | The localized message is: A runtime error occurred in the vSphere Replication Management Server. Exception details: 'Duplicate key host-XXXXXX (attempted merging values 30004.0 and 30004.0)'.

Environment

vSphere Replication 9.x

Live Recovery 9.x

Cause

The error is caused by duplicate host entries in the vSphere Replication Server database. These duplicate entries conflict during the replication configuration process, leading to a runtime error.

If during/after upgrades, any ESXi hosts are removed/disconnected/added to vCenter, while legacy replications exists, it can cause the VR log to record duplicate entries in the hbrserverentity database table.

Resolution

See resolution steps in this KB: Unable to retrieve enhanced replication mappings data