Troubleshooting database issues during vCenter Server 6.0 upgrade
search cancel

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:
     
    • 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

Compatibility issues

Configuration issues

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 のアップグレードにおけるデータベースの問題のトラブルシューティング