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