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
Comments