vCD says “…does not exist in our inventory, but vCenter Server claims that it does.”

database-parts

 

This issue is caused by a sync issue with QRTZ and Inventory.  It is easily remedied, however it will require down time as the cells will need to be shut down in the process.  And don’t forget…BACKUP, BACKUP, BACKUP.  You can never have too much backup 🙂  Just follow the steps below…

Step 1

Shut down the vCloud Director cells.  Stopping the service on all cells will NOT re-sync the Inventory.  Cells must be shut down.

Follow the procedures in the VMware KB on proper shutdown of vCD

Now is a good time to backup the DB.

Step 2

Connect to the vCD Database to run the following query:

delete from QRTZ_SCHEDULER_STATE;
delete from QRTZ_FIRED_TRIGGERS;
delete from QRTZ_PAUSED_TRIGGER_GRPS;
delete from QRTZ_CALENDARS;
delete from QRTZ_TRIGGER_LISTENERS;
delete from QRTZ_BLOB_TRIGGERS;
delete from QRTZ_CRON_TRIGGERS;
delete from QRTZ_SIMPLE_TRIGGERS;
delete from QRTZ_TRIGGERS;
delete from QRTZ_JOB_LISTENERS;
delete from QRTZ_JOB_DETAILS;

Once this has been executed successfully, run the following query on the vCD DB (Do not worry, this does NOT remove any objects like VM’s vApps, etc.):

delete from compute_resource_inv;
delete from custom_field_manager_inv;
delete from cluster_compute_resource_inv;
delete from datacenter_inv;
delete from datacenter_network_inv;
delete from datastore_inv;
delete from datastore_profile_inv
delete from dv_portgroup_inv;
delete from dv_switch_inv;
delete from folder_inv;
delete from managed_server_inv;
delete from managed_server_datastore_inv;
delete from managed_server_network_inv;
delete from network_inv;
delete from resource_pool_inv;
delete from storage_pod_inv;
delete from storage_profile_inv;
delete from task_inv;
delete from vm_inv;
delete from property_map;

Step 3

Start up the first cell.

Do NOT start any other cells until this first cell is up and running and you are able to login to vCD.

Once you have verified the cell is up, go ahead and power on the remaining cells.

 

SIDE NOTE

In vCloud Director, check your hosts in the system area to verify they are enabled.  I have seen where vCD sometimes disables the hosts after this process.

 

You may also like