Unable to re-configure replication for some VM’s

A few weeks ago I run into the problem where I have performed recovery of some virtual machines. After performing recovery deleted the VMs from the recovery site. But it wasn’t deleted from VR database

– Attempt to reconfigure replication from the primary site failed with the following error ”

Unable to configure replication for the virtual machine because the group cannot be created. Another virtual machine  has same instance UUID  already exists on protection site.

I did some workaround and didn’t find the solution. So after logged a complaint in Vmware support , here is the solution :

Setep-1  Took a backup of VR databases on both the sites. Following are the steps:

cd /opt/vmware/vpostgres/9.3/bin

./psql -U vrmsdb
Setep-2 – Took a snapshot of the appliances.

Step-3– Run this SQL Query on the primary site appliance. Zero rows retrieved.

SELECT a.group_movalue AS “PRIMARY GID”, b.name AS “virtual_machine Name”, ‘https://’ || c.address || ‘:8043/mob/?moid=’ || a.group_movalue || ‘&vmodl=1’ AS “Link to Paste” FROM primaryvirtualmachineentity a, virtualmachineentity b, localserverentity c WHERE a.movalue = b.movalue ORDER BY name;

Step-4–   From SSH session to DR site replication appliance, cd to navigate to this directory:
cd /opt/vmware/vpostgres/9.3/bin

Step-5 Run this command to access the embedded database:

./psql -U vrmsdb

Step-5 Run this query on the remote VRMS to get the GID of the orphaned job and generate a URL to review it using the MOB:

SELECT a.group_movalue AS “SECONDARY GID”, b.name AS “VM Name”, ‘https://’ || c.address || ‘:8043/mob/?moid=’ || a.group_movalue || ‘&vmodl=1’ AS “Link to Paste” FROM secondaryvirtualmachineentity a, virtualmachineentity b, localserverentity c WHERE a.movalue = b.movalue ORDER BY name;

Step-6– Copy the MOB URL you acquired from the database and paste in to your browser.

Step-7– Select the destroy method and click Invoke Method to remove the VRMS database entry related to the problematic replication job.

The orphaned job no longer exists in the VR UI and you can configure replication for the affected virtual machine as normal.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s