To resolve this issue, reset the Inventory Service database.
Process to reset Inventory Service database:
Notes:
- After resetting an Inventory Storage database, you must recreate Storage Policies/Profiles with the same name. During next sync vCloud Director picks up the Policy/Profile and the associated datastores. A sync occurs every 5 minutes unless triggered. To trigger a sync from vCloud Cloud Director, right-click vCenter Server and click Reconnect.
- If Storage Profiles do not exist within the vCloud Director and the vCenter Server 6.0 environment, then there is no expected effect on vCloud Director.
- If the vCenter Server environment has Site Recovery Manager, you must click Change/Modify and run Repair on Site recovery manager from the Windows Programs and Features to re-register Site Recovery Manager with the vCenter Server and Inventory Service.
- All Object tags are deleted during the reset
Workaround:
To workaround the issue run the following on the vCD DB before the Reset to get the mapping which needs to be recreated:
select virtual_
center.name as VC,storage_profile_
inv.name as Storage_Class, datastore_inv.vc_display_name as Datastore_To_Tag from storage_profile_inv
inner join datastore_profile_inv on datastore_profile_inv.profile_moref = storage_profile_inv.moref
inner join datastore_inv on datastore_inv.moref = datastore_profile_inv.datastore_or_pod_moref
inner join virtual_center on virtual_
center.id = datastore_inv.vc_id
order by VC,Storage_Class