Troubleshooting Datastore Cluster Disappearance Issue in vCloud Director


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.

About Alex Hunt

Hi All I am Manish Kumar Jha aka Alex Hunt. I am currently working in VMware Software India Pvt Ltd as Operations System Engineer (vCloud Air Operations). I have around 5 Years of IT experience and have exposure on VMware vSphere, vCloud Director, RHEL and modern data center technologies like Cisco UCS and Cisco Nexus 1000v and NSX. 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.
This entry was posted in vCloud Director, Vmware and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s