To prevent vCenter Server upgrade process failure when upgrading from version 6.0 to 6.5.
Symptoms:
- Upgrading vCenter Server from 6.0 to 6.5 and using a database that was initially created by VMware Virtual Infrastructure 3 or earlier
- The database had been upgraded from multiple versions of vCenter Server
- In the %TEMP%\...\vcsUpgrade\vcdb_req.err file, you see entries similar to:
Error while executing ./Upgrade-v2015-to-v2016/oracle/validate_oracle.sql:239, reason: Cannot execute statement(rc=-1).
DECLARE
l_text_full VARCHAR2(32767) := NULL;
l_text VARCHAR2(2000) := NULL;
l_verid int;
BEGIN
1 [HY000](20000) [Oracle][ODBC][Ora]ORA-20000: ERROR ! Missing constraints: VPX_EXT_TYPE_IDS.FK_VETI_REF_EXT,VPX_EXT_SERVER_EMAIL.FK_VPX_EMAIL_REF_SERVER; Extra tables or columns: VPX_HIST_STAT_TMP.COUNTER_ID,VPX_HIST_STAT_TMP.STAT_VAL,VPX_HIST_STAT_TMP.TIME_ID; Extra indexes: VPX_HIST_STAT_TMP.IX_VPX_HIST_STAT_TMP_TID; Extra constraints: VPX_EXT_TYPE_IDS.FK_VPX_EXT_TYPE_IDS_REF_EXT;
ORA-06512: at line 199
ERROR: Cannot execute statement(rc=-1).
DECLARE
l_text_full VARCHAR2(32767) := NULL;
l_text VARCHAR2(2000) := NULL;
l_verid int;
BEGIN
1 [HY000](20000) [Oracle][ODBC][Ora]ORA-20000: ERROR ! Missing constraints: VPX_EXT_TYPE_IDS.FK_VETI_REF_EXT,VPX_EXT_SERVER_EMAIL.FK_VPX_EMAIL_REF_SERVER; Extra tables or columns: VPX_HIST_STAT_TMP.COUNTER_ID,VPX_HIST_STAT_TMP.STAT_VAL,VPX_HIST_STAT_TMP.TIME_ID; Extra indexes: VPX_HIST_STAT_TMP.IX_VPX_HIST_STAT_TMP_TID; Extra constraints: VPX_EXT_TYPE_IDS.FK_VPX_EXT_TYPE_IDS_REF_EXT;
ORA-06512: at line 199