Error: "Underlying system error: Connection control operation failed for disk 'ide0:0'." when attempting to remove ISO file from Content Library

Products

• VMware Cloud Director

Issue/Introduction

• Trying to remove an ISO file from their content library catalog failing with error message:

Underlying system error:  Connection control operation failed for disk 'ide0:0'. vCenter Server task (moref: task-#######) failed in vCenter Server '<VCENTER_NAME>' 

• The status of the ISO file in the catalog is 'Not Ready'

Environment

Cloud Director 10.6.1.x

Cause

VMs still have the ISO mounted and locked.

Resolution

To resolve the issue is required that the ISO is unmounted from the VMs.

Workaround

1. Log in to the Cloud Director Tenant portal and navigate to Content Hub > Content > Media.
2. Locate the ISO to be removed, and click the Eject option in the action menu (three dots).
3. Select an attached VM from the list and click Eject.
4. If you get the Message "Waiting for Input", you will need to click on the message and select Yes.
5. Repeat this operation until the ISO has been ejected from all VMs.
6. Once the ISO has been ejected from all VMs, reattempt the delete operation.
7. If you are not able to eject using the above steps, the ISO can be ejected individually from all the VMs.
8. To have a list of VMs which have the ISO mounted, you will need to SSH to the Cloud Director Primary node.
9. Then connect to the Cloud Director database: 
   
   sudo -i -u postgres psql vcloud


10. Run the following query to generate the list of vApps/VMs:
    
    select 
organization.name AS "Org Name", 
vm_container.name AS "vApp Name", 
vapp_vm.name AS "VM Name", 
logical_disk.name AS "Media Name",
vapp_vm_logical_disk.vms_id as vms_id, 
logical_disk.id as mountedmedia_id 
From vapp_vm
JOIN vm_container ON vm_container.sg_id = vapp_vm.vapp_id
JOIN organization ON organization.org_id=vm_container.org_id
JOIN vapp_vm_logical_disk ON vapp_vm_logical_disk.vms_id=vapp_vm.id
JOIN logical_disk ON logical_disk.id = vapp_vm_logical_disk.mountedmedia_id
Where logical_disk.name = '<IMAGE_NAME>';
11. Once you got the list of VMs you will need to eject the ISO individually from each VM.