"CREATE INDEX failed because the following SET options have incorrect settings" while installing/upgrading VC 6.0 fails with Virtual Center firstboot
search cancel

"CREATE INDEX failed because the following SET options have incorrect settings" while installing/upgrading VC 6.0 fails with Virtual Center firstboot

book

Article ID: 305900

calendar_today

Updated On:

Products

VMware vCenter Server

Issue/Introduction

Symptoms:
  • Installing or upgrading to vCenter Server 6.0 fails during database upgrade with the error:
CREATE INDEX failed because the following SET options have incorrect settings
  • Installing or upgrading to vCenter Server 6.0 fails with the error:

    CREATE INDEX failed because the following SET options have incorrect settings
     
  • In the %TEMP%\vminst.log file, you see entries similar to:

    015-07-27 21:42:49.666-05:00| vcsInstUtil-2656758| I: ParseStatusFile: curr error msg: "VMware VirtualCenter failed firstboot."
    015-07-27 21:42:49.666-05:00| vcsInstUtil-2656758| I: ParseStatusFile: curr error msg: "Database in-place upgrade failed. Please see vcdb_inplace.err and vcdb_inplace.out for details."
    015-07-27 21:42:49.666-05:00| vcsInstUtil-2656758| E: ParseStatusFile: Displaying error message for "install.vpxd.action.failed": "VMware VirtualCenter failed firstboot.

     
  • In %ALLUSERSPROFILE%\VMWare\vCenterServer\log\vmware-vpx\vpxd.log file, you see entries similar to:

    [42000](1934) [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE INDEX failed because the following SET options have incorrect settings: 'ANSI_NULLS, CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
    ERROR: Cannot execute statement(rc=-1).
    CREATE INDEX VPXI_EVENT_DVS_ID on VPX_EVENT (DVS_ID) WHERE DVS_ID IS NOT NULL;

    ODBC error: (42000) - [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

    Note: This log excerpt is an example. Date, time, and environmental variables may vary depending on your environment.


Environment

VMware vCenter Server 6.0.x

Cause

This is issue is caused by incorrect settings in the ODBC Driver configuration of the vCenter Server DSN.

Resolution

To resolve this issue:
  1. Log in to the vCenter Server as an administrator.
  2. Click on Start > Control Panel > Administrative Tools > Data Sources (ODBC).
  3. Click the System DSN tab.
  4. Edit the vCenter Server DSN.
  5. Navigate through the wizard until you see the window with the option Use ANSI nulls, paddings and warnings.
  6. Ensure that this option is checked and complete the wizard.
  7. Run the upgrade process again.

    Example of an incorrectly configured DSN:
    Use ANSI nulls, paddings and warnings


Additional Information