top of page

Error Deleting Multiple VM in vCD

This issue started after we rollback the nsx v2t migration. All the VM servers can't edit/modify


Error: No row with the given identifier exists

Base on the error screen capture above the ID reported in the error 'ef116751-8490-4052-9f79-95129330ee24' is for storage profile and it did not exist in the database


Here how we can check it:

  • SSH to primary cell

  • Type su - postgres

  • Type psql vcloud

  • Type \x

  • Running the below DB command will check if the specific ID has DB record


Note: There are 115 VMs that are pointing to this 'storage_class_lr_id' in vapp_vm table and all VMs are experiencing the same problem


  • To check VM count pointing on this DB table 'storage_class_lr_id' in vapp_vm. We can see the output is 115 VM Servers


  • Here to Listed the correct 'storage_class_lr_id' for these VMs using OrgvDC id:


Output:



Fix:

Updated the value of 'storage_class_lr_id' for 2 VMs (VM1 & VM2) to '0a2f9fd1-f9c9-4c73-bc49-8a9c246083c4' which is the ID of storage policy named "DS Performance". 


  • Type update vapp_vm set storage_class_lr_id='0a2f9fd1-f9c9-4c73-bc49-8a9c246083c4' where storage_class_lr_id='ef116751-8490-4052-9f79-95129330ee24' AND name='VM1';

  • Type update vapp_vm_disk_storage_class set storage_class_lr_id='0a2f9fd1-f9c9-4c73-bc49-8a9c246083c4' where storage_class_lr_id='ef116751-8490-4052-9f79-95129330ee24' AND name='VM1';

  • Post which we could successfully able to delete these VMs & associated vApps from vCD UI. 

  • Followed the similar approach for remaining VMs & vApps.


Note: This is my personal and owned experience that I love to share in the VMware Community. I hope you appreciate it, thank you

Recent Posts

See All

Can't delete vApp and VM

Error: [ bfe374cf-fd73-4076-86da-e842ba50b13a ] No row with the given identifier exists: [com.vmware.vcloud.common.model.logicalresource....

Comments


bottom of page