VCF Usage Meter Appliance Management monitor not display utilization

Products

• VMware Usage Meter

Issue/Introduction

• Disks Utilization display "Not available" on Usage Meter VAMI Monitor page
  
  
• Network on Usage Meter VAMI Monitor page not display Errors/Sample status

Environment

Usage Meter 9.0.x

Cause

This is due to CAP Appliance Management Monitoring API timeout to query Disk / Network monitorig status from DB.

Resolution

This is known issue and will fix in future release.

Workaround:
Delete old data from SQLite DB.

Follow steps below to clean up disk and network-related monitoring data older than 30 days.

1. Connect through SSH to Usage Meter as usagemeter user.
2. Switch to the root user.
   

   su

3. Take a backup of the SQLite DB file.
   

   cp /var/vmware/applmgmt/appliance_stats.sqlite <Location_of_your_choice>

4. connect to SQLite DB
   

   sqlite3 /var/vmware/applmgmt/appliance_stats.sqlite

5. cleanup older data.
   

   DELETE FROM stat_storage WHERE timestamp < (strftime('%s', 'now') - (30 * 86400));
   
   DELETE FROM stat_network WHERE timestamp < (strftime('%s', 'now') - (30 * 86400));

6. Disconnect from the DB by typing '.quit' followed by the 'Enter' key
   

   .quit