Windows vCenter Server upgrade from 5.5 to 6.5 fails at the pre-install check with error: "This installation attempt was cancelled. Source vCenter Server schema validation found an issue."

Products

• VMware vCenter Server

Issue/Introduction

• Windows vCenter Server Upgrade from 5.5 to 6.5 fails at the Pre-Install Checks "This installation attempt was cancelled. Source vCenter Server schema validation found an issue."
• The vcdb_req,err log records the following entries:

     1 [42000](50000) [Microsoft][SQL Server Native Client 10.0][SQL Server]ERROR ! Missing indexes: VPX_HIST_STAT1_169.IX_VPX_HIST_STAT1_169_TIME_ID; VPX_HIST_STAT1_169.PK_VPX_HIST_STAT1_169;
     ERROR: Cannot execute statement(rc=-1).

Environment

VMware vCenter Server 6.x
VMware vCenter Server 5.5.x

Cause

This issue is due to some inconsistencies in the DB schema with respect to the indexes.

Resolution

Take a valid backup/snapshot of the vCenter Database before you proceed with the below steps:

1. Connect to the embedded Postgres Database by following the KB: Connecting to the embedded vPostgres Database in a Windows installed vCenter Server 6.x 

2. Run the following commands to re-create the missing indexes :

         1. CREATE INDEX IX_VPX_HIST_STAT1_169_TIME_ID  ON VPX_HIST_STAT1_169(TIME_ID);
         2. ALTER TABLE VPX_HIST_STAT1_169  ADD CONSTRAINT PK_VPX_HIST_STAT1_169  PRIMARY KEY (COUNTER_ID, TIME_ID);