VMware
 

Knowledge Base

Search the Knowledge Base:
Products:
Search In:
 

After Installing VirtualCenter 2.0.2, VirtualCenter May Fail to Start

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

Feedback

Rating: 1 - Lowest 2 3 4 5 - Highest (0 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? (2000 or fewer characters)
Submit
Rating: 1 - Lowest 2 3 4 5 - Highest (0 Ratings)   
Actions
  • KB Article: 1001680
  • Updated: Aug 14, 2009
  • Products:
    VMware VirtualCenter
  • Product Versions:
    VMware VirtualCenter 2.0.x