Provider VDC Values show as N/A in the UI after an inventory clean

Products

• VMware Cloud Director

Issue/Introduction

An inventory clean refers to a process in VMware Cloud Director in which you clean up or reconcile the inventory of objects, such as virtual machines VMs, networks, storage, and other resources, to ensure that the inventory within VCD is accurate and up to date.

This operation is usually performed directly in the embedded Postgres vcloud database.

This process involves removing orphaned or stale objects that no longer exist in the underlying vCenter Server or not correctly synchronised with VCD.

Upon completion of the clean, you might see in the VCD UI that the Storage Containers are empty and the Storage Profile values are displayed as N/A.

 

Environment

VMware Cloud Director 10.3.3.20685133

vCenter 7.0U3

NSX 3.2.0.1

Cause

• This issue exists because the AsyncEventProcessingManagementCoordinatorJob job hasn't run in a while.
• This job is part of the overall PropertyCollectorReader process and plays an integral part in sending information about objects in vCenter down to VCD.

Resolution

• Backup your database
• SSH into your Primary Appliance as root and elevate to Postgres, then drop into the vcloud database:

sudo -i -u postgres psql -d vcloud

• Paste these queries in:

truncate table scheduled_activity_jobs;
truncate table activity_pc_queue;
truncate table activity_pc_event_queue;
truncate table fifo_activity_queue;
truncate table task_activity_queue;
truncate table vc_activity_queue;

• Exit from psql:

\x

• Login to your Provider URL and navigate to vsphere-resources > vCenters and perform a reconnect and refresh on all attached vCenters.