Loading

×Sorry to interrupt
Uncaught ReferenceError: addCTracking is not defined
throws at https://kb.vmware.com/resource/KM_TealiumTrackingJS?v=0.5:100:1

Refresh

Cookie Preference Center

General Information on cookies

When you visit our website, we use cookies to ensure that we give you the best experience. This information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies by clicking on the different category headings to find out more and change your settings. However, blocking some types of cookies may impact your experience on the site and the services we are able to offer. Further information can be found in our

Cookie Policy.

Strictly Necessary

Strictly Necessary

Always Active

Strictly Necessary

Strictly necessary cookies are always enabled since they are essential for our website to function. They enable core functionality such as security, network management, and website accessibility. You can set your browser to block or alert you about these cookies, but this may affect how the website functions. For more information please visit www.aboutcookies.org or www.allaboutcookies.org.

Cookie Details‎

Performance

Performance

Performance

Performance cookies are used to analyze the user experience to improve our website by collecting and reporting information on how you use it. They allow us to know which pages are the most and least popular, see how visitors move around the site, optimize our website and make it easier to navigate.

Cookie Details‎

Please confirm your settings by refreshing the page.

Functional

Functional

Functional

Functional cookies help us keep track of your past browsing choices so we can improve usability and customize your experience. These cookies enable the website to remember your preferred settings, language preferences, location and other customizable elements such as font or text size. If you do not allow these cookies, then some or all of these services may not function properly.

Cookie Details‎

Advertising

Advertising

Advertising

Advertising cookies are used to send you relevant advertising and promotional information. They may be set through our site by third parties to build a profile of your interests and show you relevant advertisements on other sites. These cookies do not directly store personal information, but their function is based on uniquely identifying your browser and internet device.

Cookie Details‎

Advertising Cookies

Consent Leg.Interest

Select All Vendors

Select All Vendors

Select All Hosts

Select All

Clear Filters

Information storage and access

Apply

Confirm My Choices Reject All Allow All

My Subscriptions

Loading

Knowledge Base

vCenter Server Performance Graphs shows empty result for Historical Stats like Past Day/Week/Month/Year (79204)

Last Updated: 4/26/2022Categories: TroubleshootingTotal Views: 5076Language:
English

2 like this article

Subscribe to get an email
newsletter with new updates

2 people found this helpful Please provide article feedback:

Symptoms

You have recently migrated vCenter Server running on Windows OS with Oracle Database to VCSA

Last Day/Week/Month/Year performance charts shows empty result while checking from UI or WebClient (Monitor -> Performance -> Overview or Advanced ->Select Last Day / Week / Month / Year)

Historical stats in VCDB shows empty rows

Connect to Postgres using command

/opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres

Execute below query
select count( * ) from VPX_HIST_STAT2;
Example:
VCDB=# SELECT COUNT(*) FROM vpx_hist_stat2;
count
-------
0 ---->>> shows 0 rows
(1 row)

Cause

This is caused due to incorrect behavior of Stats Rollup Jobs on vCenter Server

Resolution

Follow below steps to resolve the issue:

Login to VCSA using SSH.

Change shell to bash if you are on appliance shell.

* List APIs: "help api list"
* List Plugins: "help pi list"
* Launch BASH: "shell"

Command> shell
Shell access is granted to root
root@vcsa1 [ ~ ]#

Take backup of /usr/lib/vmware-vpx/sql/postgres.sql file before editing.

cp /usr/lib/vmware-vpx/sql/postgres.sql /usr/lib/vmware-vpx/sql/postgres.sql_backup

Stop VPXD Service.

service-control --stop vmware-vpxd

Note: vCenter Server will be down after stopping VPXD service, stop the service and proceed with the steps if you have downtime.

Edit /usr/lib/vmware-vpx/sql/postgres.sql

vi /usr/lib/vmware-vpx/sql/postgres.sql

Search for strings "query:kQueryStatsStatIdNullDevice1Part" , "query:kQueryStatsStatIdNullDevice2", "query:kQueryStatsStatIdNullDevice3"  and "query:kQueryStatsStatIdNullDevice4" in the postgres.sql file

7. Connect to Postgres using command:

/opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres

8. Download the attached scripts and copy to VCSA (/tmp location) using WinScp, follow

Error when uploading files to vCenter Server Appliance using WinSCP if you face
difficulty to  connect to VCSA.

9. Change ownership of copied files using below command:
chown vpostgres:users /tmp/sql1
chown vpostgres:users /tmp/sql2
chown vpostgres:users /tmp/sql3

10. Recreate the Stats Rollup Procedures by importing the downloaded scripts.
VCDB=# \i /tmp/sql2
VCDB=# \i /tmp/sql1
VCDB=# \i /tmp/sql3
Example:
VCDB=# \i /tmp/SQL2
CREATE FUNCTION
VCDB=# \i /tmp/SQL1
CREATE FUNCTION
VCDB=# \i /tmp/SQL3
CREATE FUNCTION

11. Start VPXD service and refresh the UI Client.
service-control --start vpxd

Note:  It will take some time to populate the historical data post recreating the jobs. You may verify the contents using Postgres query select count( * ) from VPX_HIST_STAT2; This will show the Stats available for Past Week data.

Detectable by VMware SkylineTM

Actions

Copy

link to clipboard
copied!

Print

Language:
English

Attachments

sql3

sql2

sql1

Additional Resources

KB
•
End Of General Availability of the Free vSphere Hypervisor (ESXi 7.x and 8.x) (2107518)

KB
•
[解決済み] AAPP-6843：バッチ インポートで割り当てられたデバイス アセット番号が DEP 経由で加入するデバイスに適用されない (2961233)

KB
•
Download and Install VMware Fusion (2014097)

Results 1-3 of 3

Ask The Community

Get answers quickly from VMware experts in the community

Post Subject

CONTINUE IN COMMUNITIES

Related Products:

VMware vCenter Server Appliance

Related Versions:

VMware vCenter Server Appliance 6.7.x

Take Our Survey

Support Assistant