Error: "Internal Server Error - No row with the given identifier exists" when trying to perform Migrate Tenant Storage

Products

• VMware Cloud Director

Issue/Introduction

•  While trying to migrate catalog across datastore using the migrate tenant storage option in VMware Cloud Director(VCD) you get the below error:
  
  [ ########-####-####-####-########ddec ] Internal Server Error - No row with the given identifier exists: [com.vmware.vcloud.common.model.VAppVmModel# ########-####-####-####-########7c2d]
  
  
• The above may also be seen when trying to delete a Media item in a Catalog.
  
  
  org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.vmware.vcloud.common.model.VAppVmModel#########-####-####-####-########7c2d]
   at org.hibernate.impl.SessionFactoryImpl$2.handleEntityNotFound(SessionFactoryImpl.java:409)

  at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:171)

  at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)

  at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)

Environment

• VMware Cloud Director 10.6.1.2

Cause

The issue is caused because an ISO or a media file from the catalog is attached to a Virtual Machine(VM) which no longer exists in the VCD DB or VCD UI. 

Resolution

To resolve the issue please contact Broadcom Support and note this Article ID (435518) in the problem description. For more information, see Creating and managing Broadcom support cases.