Previewing VMs associated with tag in VLCR ui does not populate all the VMs and results in replication failure.

Products

• VMware Live Recovery

Issue/Introduction

• Previewing VMs in protection group settings does not populate all the VMs associated with the tag. 
• vCenter inventory shows all the object for the tag correctly. 
• For example: VMs associated with tag on vCenter shows 300+ objects, however, the vLCR UI previewing the VMs, only shows 14 VMs.
• Protection group replication tasks may fail with error " No VMs match membership query in protection group" 
• Protection group replication task may also fail with error " The last snapshot of protection group "example protection group" failed because it did not include any VMs"

• /da/data/var/log/sysmgmt/irr/irrServer.log show below exception

  Could not handle POST /persistvmdetail/persist {}da.core.exception$DaExceptionIrrInternal$Throwable: org.postgresql.util.PSQLException: ERROR: nextval: reached maximum value of sequence "vm_details_id_seq"

  at com.datrium.irr.exception.IRRExceptionUtils.createIRRInternalException(IRRExceptionUtils.java:184)
  at com.datrium.irr.services.cloudview.VmDetailsPersistorService.persist(VmDetailsPersistorService.java:91)

Environment

VMware Live Cyber Recovery 7.27.x and older

Cause

This is a known issue caused by vm_details.id primary key Integer overflow in the database.

Resolution

This is fixed in VMware Live Cyber Recovery version 7.28.x and later. 

Engage VMware by Broadcom support to implement the workaround if an upgrade is not an option.