VMware
Changing the Cloud Director DB dstore_moref value in bulk
As co-author Bryan described in great detail a situation can occur where the dstore_moref value of a VM in the cloud director database is empty. Preventing you from making any changes to that VM. Read all about it in this post: How to fix VMware Cloud Director ‘Index 0 out of bounds for length 0 error’ Recently I encountered that same issue but upon inspection I learned that the cloud director database had not one but quite a lot of VMs that had this symptom. This lead me to create a more extensive SQL query to solve this issue for all VMs.