Troubleshooting database issues during vCenter Server 6.0 upgrade
book
Article ID: 336200
calendar_today
Updated On:
Products
VMware vCenter Server
Issue/Introduction
Symptoms:
When upgrading to vSphere 6.0, you may see an error similar to:
Error: Unsupported database driver: file_name Resolution: Verify you're using vCenter Server with supported driver.
The pre-install validation fails with the error:
Incompatible MSSQL version with vCenter Server 6.0
In the %temp%\msint.log file, you see entries similar to:
<YYYY-MM-DD>T<time>| vcsInstUtil-2562624| I: ParsePreUpgradeOutput: Export disk req: 0 MB, Import disk req: 0 MB. <YYYY-MM-DD>T<time>| vcsInstUtil-2562624| I: PitCA_MessageBox: Displaying message: "Error: Source vCenter Server validation found an issue: ERROR: Incompatible MSSQL version with vCenter Server 6.0 Resolution: Make sure your database is configured to meet vCenter Server upgrade requirements." </time></time>
In the C:\ProgramData\VMware\vCenterServer\logs\firstboot\CollectRequirements_com.vmware.vcdb_date.log file, you see entries similar to:
<YYYY-MM-DD>T<time> ERROR vcdb Error while validating source vCenter Server database: ERROR: Incompatible MSSQL version with vCenter Server 6.0
</time>
The database had been upgraded from multiple versions of vCenter Server
In the %TEMP%\...\vcsUpgrade\vcdb_req.err file, you see entries similar to:
'1 [42000](50000) [Microsoft][SQL Server Native Client 11.0][SQL Server]ERROR ! Missing constraints: VPX_EXT_SERVER_EMAIL.FK_VPX_EXT_EMAIL_REF_EXT_SERVER; VPX_EXT_TYPE_IDS.FK_VPX_EXT_TYPE_IDS_REF_EXT; Extra tables or columns: VPX_FEATURE.FEATURE_ID; VPX_FEATURE.FEATURE_NAME; VPX_FEATURE.FEATURE_ORDER; VPX_INVT_REP.COLLECT_DATE; VPX_INVT_REP.INVENTORY_ID; VPX_INVT_REP_VAL.FEATURE_ID; VPX_INVT_REP_VAL.INVENTORY_ID; VPX_INVT_REP_VAL.INVT_FEATURE_VAL; Extra constraints:VPX_EXT_SERVER_EMAIL.FK_VPX_EMAIL_REF_SERVER; VPX_EXT_TYPE_IDS.FK_VETI_REF_EXT; VPX_FEATURE.PK_VPX_FEATURE; VPX_INVT_REP.PK_VPX_INVT_REP; VPX_INVT_REP_VAL.FK_VPX_INVT_REP_VAL_REF_FEATID; VPX_INVT_REP_VAL.FK_VPX_INVT_REP_VAL_REF_INVTID;'
You see the error:
re-configure your DSN to use one of the supported drivers
The VMware VirtualCenter Server service does not start.
In the C:\ProgramData\VMware\VMware VirtualCenter\Logs\vpxd.log file, you see entries similar to:
ODBC error: (IM014) - [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.
In the C:\ProgramData\VMware\VMware VirtualCenter\Logs\vpxd.log file, you see entries similar to: