top of page

Unable to delete duplicate Media in vCD

I notice that there were duplicate entries of media in vCD UI and I try to delete one of them and I get error with specific ID reference >> Error: [ 0a1c91ef-6684-4532-924c-73e08af19fd6 ] query [ ref:!00Df403u6t.!5005G01osWE7:ref ]


To further check and fix the issue please see the steps below:

  • Login to Primary Cell through SSH

  • Then Backup the Cell DB

  • Take VM Cell Snapshot

  • After that login to DB Cell

  • Type su -postgres

  • Type psql vcloud

  • Type select * from managed_media where media_name = 'Win_Server_2019_1909_DC_STD.ISO';

  • In this scenario this is the media name that has an issue "Win_Server_2019_1909_DC_STD.ISO"

Here is the output

Note: In this case we just need to take note the media_id that has creation status error


  • Now it's time to delete the duplicate entry causing the error

  • Type delete from managed_media where media_id ='a5327cc0-ed89-4819-a9db-bc3cf5d413d1';

  • At this time we deleted those duplicate entries from the database. 

  • You can refresh your browser and you can see now that the duplicate media is cleared


Solution Recommendation Summary:  

  • We took Database backup

  • Snapshots of all the cells

  • We deleted one of the duplicate entry where the creation status showed :Error

  • select * from managed_media where media_name name = '';

  • delete from managed_media where media_id = '';


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