"vSAN Services" / Storage view is missing

Products

• VMware vCenter Server 8.0

Issue/Introduction

• "vSAN Services" - Storage tab displays error:

"Unable to extract requested data. Check vSphere Client logs for details" 

• In vpxd.log file:

<timestamp>  error vpxd[06923] [Originator@6876 sub=MoCluster opID=<OPID>] Managed object not found for DVPG {vim.dvs.DistributedVirtualPortgroup:dvportgroup-XX}

• VCDB vpx_hci_nw_settings table,  dvportgroup-XX is configured for HCI

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

VCDB=# select * from vpx_hci_nw_settings;
 dvpg_id | service_type | dvs_id | cluster_id
---------+--------------+--------+------------
      XX | vsan         |   s_id>| <cluster_id>
(1 rows)

• While listing portgroups associated to DVS   <dvs_id>, dvportgroup-XX does not exist.

VCDB=# select id,dvs_id,dvportgroup_key from vpx_dvportgroup where dvs_id=<dvs_id>;

id       |  dvs_id | dvportgroup_key
---------+---------+--------------------
      YY | <dvs_id>|   dvportgroup-YY

(1 rows)

Environment

vCenter Server 8.x

Cause

This issue occurs with the following scenario:

• VSAN cluster had been created with quickstart 
• VSAN portgroup created by quickstart had been deleted
• A new host is added to the cluster

 

Resolution

This issue will be fixed in a future vCenter release

Workaround

1.  Snapshot or Backup the VCSA
   
   
2. Connect to VCDB
   
   #/opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres
   
   
3. Execute command (where XX is the missing dvpg_id)
   
   #DELETE FROM vpx_hci_nw_settings WHERE dvpg_id=XX;
   
   
4.  Restart vpxd and vsphere-ui services
   
   service-control --restart vpxd
service-control --restart vsphere-ui