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:

Open the command prompt on the host where VirtualCenter was installed.
Change to the directory where VirtualCenter was installed. The default location is

C:\Program Files\VMware\VMware VirtualCenter 2.0\
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
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
After the commands are complete, start VirtualCenter.

Keywords

vc; virtual centre; virtualcentre; virtual center

Feedback

Actions

KB Article: 1001680
Updated: May 26, 2009

Products:
VMware VirtualCenter
Product Versions:
VMware VirtualCenter 2.0.x

Knowledge Base