Loading Posts...

vCenter 6.5 Upgrade Error: VMware Migration Assistant Failed Due To An Extra Indexes Of The vCenter Database

This issue appeared in the VMware Migration Assistant and it was failing the pre-checks of the vCenter due to extra indexes of The vCenter Database. I hope you already aware of the vCenter 6.5 Windows to VMware vCenter Appliance Migration process and you can read the Windows to vCenter 6.7 Migration process in my previous post. There is no difference in the vCenter 6.5 VCSA migration process when compared to the vCenter server 6.7 Migration which I explained in that post.

Also, If you have a separate Single Sign-On server and you are planning to migrate them to a separate PSC and vCenter you can follow this article which I published earlier.

This error message showed up as below in the screen capture of my Migration Assistant.

Error: Source vCenter Server Schema Validation found and Issue.

Resolution: Read the vcdb_req.err log file and address the issues found.

Extra Indexes Of The vCenter Database: Error

Migration assistant log file was showing some error entries and below error appeared in each error section

1 [42000](50000) [Microsoft][SQL Server Native Client 11.0][SQL Server]ERROR ! Extra indexes: VPX_EVENT.VPX_EVENT_ALLColumns;

So this was due to the extra indexes of The vCenter database tables and those indexes should be removed before proceed with the Migration Assistant, this happens when the vCenter server migrated from older versions to newer versions, in my case this vCenter server was upgraded from vCenter server 4.1 to 5.5 and 6.0 , this error appeared when we were upgrading from vCenter server 6.0 to 6.5 Appliance.

This type of similar entries could be seeing in the “vcdb_req.err” log

Extra Indexes Of The vCenter Database : Log error

Remove The Indexes From The Database

So we took a backup of the database as the safety measure and executed below database query to remove this index

Note: Please note that in this scenario there was only one extra index and there can be multiple tables and indexes in the database, you have to adjust your query to remove those indexes.

For example: VPX_EVENT.HFX_VPX_EVENT_Cover01; VPX_STAT_COUNTER.IX_VPX_STAT_COUNTER_STAT; VPX_TASK.HFX_VPX_TASK_Cover01;

After removing the extra indexes of the database make sure to check the vCenter Server functionality and run the VMware Migration Assistant, this would fix the problem and I can confirm this worked all the time in our upgrades.

If you found this post as useful please rate the post and share it!

vCenter 6.5 Upgrade Error: VMware Migration Assistant Failed Due To An Extra Indexes Of The vCenter Database
5 (100%) 10 vote[s]

Aruna Lakmal

Associate Technical Lead at Pearson, Sri Lanka. Technology junky, enthusiast, a VMware vExpert and a blogger with more than 6 years of Experience in Information Technology more focusing on VMware Virtualization, Microsoft and Datacenter Technologies.

Get Updates Directly To Your Inbox!

   

Leave a Reply

Loading Posts...