Error: "No row with the given identifier exists" when accessing or trying to delete a vApp or VM from VMware Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

• Unable to access a vApp and the VMs inside it.
• Accessing or even trying to delete a virtual machine from the Cloud Director UI shows the error:
  
  [########-###-###-########7853] No row with the given identifier exists: [com.vmware.vcloud.common.model.logicalresource.LogicalDiskModel#########-###-###-########3456]

• The /opt/vmware/vcloud-director/logs/vcloud-container-debug.log on the VMware Cloud Director (VCD) Cells show errors of the form:
  
  org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.vmware.vcloud.common.model.logicalresource.LogicalDiskModel#########-###-###-########3456]
    at org.hibernate.impl.SessionFactoryImpl$2.handleEntityNotFound(SessionFactoryImpl.java:409)
    at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:171)

Environment

VMware Cloud Director 10.x

Cause

This issue occurs due to a stale media entry in the Cloud Director Database.

Resolution

The workaround for this issue requires modification of the Cloud Director database.

For assistance, contact Broadcom Support and note this Article ID (325669) in the problem description. For more information, see Creating and managing Broadcom support cases

Additional Information

NOTE: The resolution procedure modifies the VMware Cloud Director database. Ensure to take a backup of the database before proceeding as per documentation Backup and Restore of Your VMware Cloud Director Appliance