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

ste-1

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

ste-2

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

ste-3

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

ste-4

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:

[root@vcd bin]# ./cell-management-tool -u svcvcloud -p MYPassword cell –quiesce true
[root@vcd bin]# service vmware-vcd stop

2: Login to SQL Server Management Studio and selected my vCloud Database and ran the following SQL query

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;

3: Started the vCloud Service again

[root@vcd bin]# service vmware-vcd start
Starting vmware-vcd-watchdog: [ OK ]
Starting vmware-vcd-cell              [ OK ]

After this when I checked in my vCloud Director web console my datastores were back

ste-5

All the datastores are visible here:

ste-6

My provider vDC is now able to see the datastores now

ste-7

I also came across a few blogs related to same issues. Have a look on those too:

DISAPEARING DATASTORE CLUSTER IN VCLOUD AFTER ADDING DATASTORE TO VCENTER WITH STORAGE PROFILES

Storage Profile is gone on vCloud 5.5

vCloud Director *(Any) Storage Profile

I hope this post is informational to you. Keep sharing and be sociable.

Leave a reply