Today I was facing a weird issue in my vCloud Lab. All my datastores have disappeared from vCloud Director and the storage policy was not showing any datastore. I have included a few snapshots from my lab here:

1: Storage Policies was not listing any datastore

2: Selecting Datastore and Datastore Cluster was not listing any datastore either

3: Due to this my Provider vDC was not able to see any datastores

4: And since Provider vDC had no visibility to any datastore, my Organization vDC was throwing this alert

This was strange as till last night everything was all right in my lab.

I started googling and got a cool VMware KB 2075366 which helped me in resolving my issue.

This is what I done to resolve the issue:

1: SSH to my vCloud Director Server and navigated to directory /opt/vmware/vcloud/bin and fired the following commands:

Note: Before running the below query make sure you have taken backup of your database

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

DELETE FROM qrtz_simple_triggers;
DELETE FROM qrtz_fired_triggers;
DELETE FROM qrtz_cron_triggers;
DELETE FROM qrtz_job_listeners;
DELETE FROM qrtz_scheduler_state;
DELETE FROM qrtz_blob_triggers;
DELETE FROM qrtz_paused_trigger_grps;
DELETE FROM qrtz_triggers;
DELETE FROM qrtz_job_details;

About The Author

Alex Hunt

Hi All
I am Manish Jha. I am currently working in OVH US as Operations Support Engineer (vCloud Air Operations).
I have around 6.5 Years of IT experience and have exposure on VMware vSphere, vCloud Director,vSphere Replication, vRealize Automation, NSX and RHEL.
If you find any post informational to you please press like and share it across social media and leave your comments if you want to discuss further on any post.
Disclaimer:
All the information on this website is published in good faith and for general information purpose only. I don’t make any warranties about the completeness, reliability and accuracy of this information.
Any action you take upon the information you find on this blog is strictly at your own risk. The Views and opinions published on this blog are my own and not the opinions of my employer or any of the vendors of the product discussed.