Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

After Installing VirtualCenter 2.0.2, VirtualCenter May Fail to Start (1001680)

Details

If a fresh installation of VirtualCenter 2.0.2 was performed and not upgraded from a previous release, but pointed to a database created by a previous VirtualCenter release, VirtualCenter will fail to start after installation completes.

Under these conditions, the database is not upgraded during the installation process. The logs may show the following errors:

Sequence VPX_INVENTORY_SEQ is not defined on the database

Failed to initialize VMware VirtualCenter. Shutting down...

The vpxa log files contain errors similar to:

[2007-09-18 13:07:03.245 'App' 3972 error] "ODBC error: (42S02) - [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'vpx_sequence'." is returned when executing SQL statement "select id from vpx_sequence where name = ?"

Solution

To resolve this issue:
  1. Open the command prompt on the host where VirtualCenter was installed.  

  2. Change to the directory where VirtualCenter was installed.  The default location is

    C:\Program Files\VMware\VMware VirtualCenter 2.0\

  3. Run the following commands for MS SQL:

    vpxd.exe -f DropVpxStatsRollupProc.sql -m
    vpxd.exe -f rollup_mssql1.sql
    vpxd.exe -f rollup_mssql2.sql
    vpxd.exe -f rollup_entity_mssql1.sql
    vpxd.exe -f rollup_entity_mssql2.sql
    vpxd.exe -f updatedb_mssql.sql -m

  4. Run the following commands for Oracle:

    vpxd.exe -f rollup_oracle.sql
    vpxd.exe -f rollup_entity_oracle.sql 
    vpxd.exe -f updatedb_oracle.sql -m

  5. After the commands are complete, start VirtualCenter.

Keywords

vc; virtual centre; virtualcentre; virtual center

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 1 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 1 Ratings
Actions
KB: