VCSA Upgrade from 7.0.x to 8.0.x failed with pre-check error "Source vCenter Server schema validation found an issue"

Products

• VMware vCenter Server

Issue/Introduction

• vCenter Server upgrade fails in UI at stage-2 with the below error,
  
  

• Log file /var/log/vmware/upgrade/vcdb_req.err will show similar entries to:
  
  Missing constraints: 
1 [P0001](1) ERROR: ERROR ! Missing indexes: VPX_NON_ORM_VM_CONFIG_INFO.PK_N_VM_CONFIG_INFO;VPX_VM_TEXT.PK_VM_TEXT; Missing constraints: VPX_NON_ORM_VM_CONFIG_INFO.PK_N_VM_CONFIG_INFO;VPX_VM_TEXT.PK_VM_TEXT;;

• Log file /var/log/vmware/upgrade/prechecks.json will show similar entries to:

  
          "error": [
            {
                "text": {
                    "id": "vcdb.error.validate.linux.vcdb",
                    "translatable": "Source vCenter Server schema validation found an issue.",
                    "localized": "Source vCenter Server schema validation found an issue."
                },

Environment

vCenter Server 7.x

vCenter Server 8.x

Cause

The error indicates that certain required indexes on the tables vc.vpx_vm_text & vpx_non_orm_vm_config_info are missing, which prevents the upgrade from proceeding.

Resolution

If you encounter the symptoms outlined above, please contact Broadcom Technical Support for further assistance, as the resolution involves re-creating missing indexes on the vCenter Server database, which should be performed with caution.