Troubleshooting database issues during vCenter Server 6.0 upgrade

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:
   
  • In Oracle:
    
    ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied
    
    or
    
    ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-12541: TNS:no listener
     
  • In SQL:
    
    ODBC error: (08001) - [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied

Environment

VMware vCenter Server 6.0.x

Resolution

DSN/ODBC issues	Upgrading vCenter Server fails with the error: DSN is pointing to an unsupported ODBC driver or unsupported database driver (1015804) vCenter Server installation fails with ODBC and DSN errors (1003928)
Compatibility issues	Verify that the database is supported for vCenter Server 6.0. For more information, see: The vCenter Server for Windows Database Requirements section in the vSphere Installation and Setup guide. VMware Product Interoperability Matrix   Installing or Upgrading to vCenter Server 6.0 fails with the error: Incompatible MSSQL version with vCenter Server 6.0 (2111541)
Configuration issues	The Configure Microsoft SQL Server Databases section in the vSphere Installation and Setup guide. The Configure Oracle Databases section in the vSphere Installation and Setup guide. The Required Database Privileges section in the Installing and Administering VMware vSphere Update Manager guide The Verify That vCenter Server Can Communicate with the Local Database section in the vSphere Installation and Setup guide.
Schema issues	Upgrading to vCenter Server 6.0 fails with the error: Source vCenter Server schema validation found an issue (2113439)

 

If the issue persists file a support request with VMware Support. For information on filing a support request, see Filing a Support Request in Customer Connect (2006985).

Additional Information

vCenter Server installation fails with ODBC and DSN errors
Upgrading vCenter Server fails with the error: DSN is pointing to an unsupported ODBC driver or unsupported database driver
Installing or Upgrading to vCenter Server 6.0 fails with the error: Incompatible MSSQL version with vCenter Server 6.0
Upgrading to vCenter Server fails with the error: Source vCenter Server schema validation found an issue
对有关 vCenter Server 6.0 升级失败的数据库问题进行故障排除
失敗した vCenter Server 6.0 のアップグレードにおけるデータベースの問題のトラブルシューティング