Error: VRM Server UUID not found and missing table ChangeRecordEntity - VMware Live Recovery

Products

• VMware Site Recovery Manager

Issue/Introduction

• Site Recovery UI shows: Server with UUID '[UUID]' not found in VMware Live Site Recovery.
• hms-configtool.log reports: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [ChangeRecordEntity].
• VRMS service fails to start with N7Vmacore23NotInitializedExceptionE

Environment

VMware Live Site Recovery 9.0.x

Cause

The vSphere Replication Management Server (VRMS) database is empty or has lost schema integrity. This can occur due to interrupted upgrades, severe file system corruption, or accidental manual database modifications. Simple reconfiguration fails because the underlying table structure required for persistence is missing.

Resolution

1. Export Configuration: If the protected site is still functional, use the UI or CLI (/opt/vmware/impex/) to export inventory mappings and recovery plans.
2. Redeploy Appliance: Deploy a new SRM/VR Embedded appliance (matching version 9.0.5).
3. Restore Configuration: Use the Configuration Import/Export Tool to import the XML configuration into the new appliance.
4. Re-pair Sites: Establish a new site pair and verify protection groups.