Knowledge Base

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

Performance charts display only the past day's data when viewing past week, month, and year charts (1032755)

Symptoms

After upgrading to vCenter Server 4.1 or later with Oracle database, you experience these symptoms:
  • When viewing the performance charts of past week, month, or year, only a day's data is displayed
  • Performance graphs do not display data beyond the past day regardless of the graph type
  • All data prior to the upgrade are available

Resolution

This issue is resolved in VMware vCenter Server 4.1 Update 2. For more information, see the resolved issues section in the VMware vCenter Server 4.1 Update 2 Release Notes.

This issue may occur if the stored procedures for the vCenter Oracle database does not populate the appropriate tables correctly.
 
To resolve the issue, you must re-create the index on the vpx_sample_time table.
 
To re-create the index: 
  1. Download the 1032755_recreate_sample_indexes.txt file attached to this article.
  2. Open SQL Plus.
  3. Click File > Open > File.
  4. Navigate to the location of the 1032755_recreate_sample_indexes.txt script, so you can invoke the script.
  5. Open a SQL Plus session using an user account that has access to the Oracle tables, jobs, and schedules related to vCenter Server.

    Note: Before running the below SQL script, stop the vCenter Server service as a safety measure. For further information, see Stopping, starting, or restarting vCenter services (1003895). This service can be restarted once the SQL script has completed.

  6. Run the SQL script in the 1032755_recreate_sample_indexes.txt file.

    Note: If you are using SQL*Plus, identify the path where you install sqlplus. Usually, this tools is installed in the same location as the Oracle DB server. For example, $ORACLE_HOME/bin directory. Go the location of the 1032755_recreate_sample_indexes.txt script and invoke sqlplus. At the SQL> command prompt, run this command:

    @<file>.sql

    For more information about using SQL*Plus, see http://www.orafaq.com/wiki/SQL*Plus_FAQ.
  7. Ensure that the global Oracle setting JOB_QUEUE_PROCESSES is not set to 0 as this disables all job processing. To check this, login as sysdba to verify the value by invoking this SQL statement - "select value from v$parameter where name=’job_queue_processes’;"
After recreating the index, wait for a minimum of 48 hours and then verify if more than a days data is available in the past week, month, and year charts.

Additional Information

For more information, see:

Tags

vcenter-database-upgrade-fails  vcenter-db-stored-procedures  vcenter-database-oracle  vcenter-database-sql

Update History

10/12/2011 - Added note on command to use when using SQL*Plus 07/17/2012 - Added information that the issue is resolved in vCenter Server Update 2 with link to release notes.

Attachments

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

  • 13 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)
  • 13 Ratings
Actions
KB: