Performance Data Is Not Displayed in VI Client Connected to VirtualCenter 2.0 Server after an Upgrade

Products

• VMware vCenter Server

Issue/Introduction

Performance data is not displayed in VI Client connected to VirtualCenter 2.0 Server after an upgrade.

Environment

VMware VirtualCenter 2.0.x

Resolution

A VirtualCenter 2.0 Server (using an MS SQL Server database) that has been upgraded from VirtualCenter 1.x may not display performance data in the VI Client. This problem does not affect fresh installations of VirtualCenter 2.0, nor any upgrade or fresh installation that uses an Oracle database.

 

If your upgraded VirtualCenter 2.0 with MS SQL Server is not displaying performance data, please use the following procedure to fix the issue:

1. Stop the VirtualCenter Server service.
    
2. Connect to the MS SQL Server with Query Analyzer or a similar tool.
    
3. Ensure the VirtualCenter database is selected (that is, not the "Primary" database).
    
4. Execute the following SQL statement:
   
   UPDATE VPX_SEQUENCE
   SET ID = (SELECT MAX(id) FROM vpx_sample)
   WHERE NAME = 'VPX_SAMPLE_SEQ'
   
   
   Note: If you see the error message, "Invalid object name VPX_SEQUENCE," make sure you're connected to the database as the same user account VirtualCenter uses. You can't use a null logon (NT logon) for database authentication.
    
5. Start the VirtualCenter Server service.

Note: VirtualCenter 2.0.1 resolves this issue.