Health Status displays as "Unknown" in the vCenter Server Management Interface (VAMI) on port 5480.

Products

• VMware vCenter Server

Issue/Introduction

• Health Status displays as "Unknown" in the vCenter Server Management Interface (VAMI) on port 5480 as per below:
  
  
  
  
• Logs on vCenter server located at /var/log/vmware/applmgmt/applmgmt.log shows entries similar to:
  

  
  YYYY-MM-DDThh:mm:ss [19271]ERROR:vmware.appliance.monitoring.statsMonitor:Failed to initialize stats retrieval module. Error: no such table: request_mapping
YYYY-MM-DDThh:mm:ss [19271]ERROR:vmware.vapi.provider.local:Error in invoking com.vmware.appliance.health in messages - 'Failed to initialize stats retrieval module. Error: no such table: request_mapping'
Traceback (most recent call last):
  File "/usr/lib/applmgmt/monitoring/py/vmware/appliance/monitoring/statsMonitor.py", line 201, in constructStatTableMap
    cur.execute(CMD_GET_STAT_TABLE_OBSERVABILITY)
sqlite3.OperationalError: no such table: request_mapping

  During handling of the above exception, another exception occurred:

  Traceback (most recent call last):
  File "/usr/lib/applmgmt/vapi/lib/vapi_runtime-2.100.0-py2.py3-none-any.whl/vmware/vapi/provider/local.py", line 277, in invoke
    method_result = self._invoke_int(
  File "/usr/lib/applmgmt/vapi/lib/vapi_runtime-2.100.0-py2.py3-none-any.whl/vmware/vapi/provider/local.py", line 249, in _invoke_int
    method_result = iface.invoke(ctx, method_id, input_value)
  File "/usr/lib/applmgmt/vapi/lib/vapi_runtime-2.100.0-py2.py3-none-any.whl/vmware/vapi/bindings/skeleton.py", line 371, in invoke
    meth_output = method(**meth_args)
  File "/usr/lib/applmgmt/health/py/vmware/appliance/health/healthmsg_impl.py", line 58, in messages
    resourceHealth.fetchHealth()
  File "/usr/lib/applmgmt/health/py/vmware/appliance/health/healthUtil.py", line 132, in fetchHealth
    self.contents = self._stats_calculator.calculate()
  File "/usr/lib/applmgmt/monitoring/py/vmware/appliance/monitoring/stats.py", line 905, in calculate
    reader = StatsReader(None)
  File "/usr/lib/applmgmt/monitoring/py/vmware/appliance/monitoring/statsMonitor.py", line 323, in __init__
    super(StatsReader, self).__init__(dbPath)
  File "/usr/lib/applmgmt/monitoring/py/vmware/appliance/monitoring/statsMonitor.py", line 159, in __init__
    self.statsmap = self.constructStatTableMap()
  File "/usr/lib/applmgmt/monitoring/py/vmware/appliance/monitoring/statsMonitor.py", line 210, in constructStatTableMap
    raise FailedToInitialize("Failed to initialize stats retrieval"
vmware.appliance.monitoring.statsMonitor.FailedToInitialize: 'Failed to initialize stats retrieval module. Error: no such table: request_mapping'

Environment

vCenter Server 8.x

Cause

This issue occurs due to corruption in one of the database instances within the VMware vCenter Server appliance.

Resolution

If you encounter the symptoms outlined above, contact Broadcom Technical Support for further assistance, as the resolution involves modifying vCenter server database instance, which should be performed with caution.