vSAN Skyline health is missing "Hardware compatibility" and "Hyperconverged Cluster configuration Compliance" checks

Products

• VMware vSAN

Issue/Introduction

To fix the issue with missing hardware compatibility & HCI configuration Compliance checks i vSAN Health Plugin

Symptoms:

vSAN health check shows green but Skyline health is missing hardware compatibility & HCI configuration Compliance checks

Environment

VMware vSAN 6.7.x
VMware vSAN 7.0.x

Cause

Hyperconverged Cluster configuration Compliance check missing is an expected behavior. It is by design that only when the vSAN cluster is configured with HCI (QuckStart) or completed HCI configuration.

 

The hardware compatibility issue, we identified that there was inconsistency in the vCenter Database.

Resolution

This issue is fixed in vSAN 7.0.3 and above

Workaround:

1. Run this command on vCenter Server to grep the password for vcdb

grep password /usr/lib/vmware-updatemgr/bin/configvalues.txt | awk -e '{ print substr($1, 13) }'

 

2. and then run

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

 

after hitting this 2nd command, you need to enter the password which you got in 1st command

 

3. once step2 is done, you will get a environment where you can execute sql queries as per your need like

SELECT * FROM PM_PCI_DEVICE_VCG_PRODUCT_ID_OVERRIDES;

 

Sample output

 

VCDB=> SELECT * FROM PM_PCI_DEVICE_VCG_PRODUCT_ID_OVERRIDES;                     

entity_id | pci_vendor_id | pci_device_id | pci_subvendor_id | pci_subsystem_id | firmware_version

| part_number | product_id | capacity | driver_name | driver_version | vcg_product_id

-----------+---------------+---------------+------------------+------------------+------------------

+-------------+------------+----------+-------------+----------------+----------------

 domain-c8 | 8086     | 0a54     | 1590       | 0262       |

|       |      |    0 |       |        | 44048

(1 row)

 

3. Then update the capacity from 0 to 1 for all rows by command

 

UPDATE PM_PCI_DEVICE_VCG_PRODUCT_ID_OVERRIDES set capacity=1 where capacity=0;

 

4. Retest vSAN health summary

Additional Information

Impact/Risks:

 Unable to validate the hardware compatibility using vSAN health check