Error: "Internal Server Error - The operation encountered an unspecified error. - No row with the given identifier exists: com.vmware.vcloud.common.model.VAppVmModel###]" occurs during catalog synchronization task

Products

• VMware Cloud Director

Issue/Introduction

• You are unable to synchronize the subscribed catalogs from the specific Organization (Org) inside VMware Cloud Director(VCD) UI.
• Synchronized Media File operation fails with an error similar to:
  
  Internal Server Error - The operation encountered an unspecified error. - No row with the given identifier exists: com.vmware.vcloud.common.model.VAppVmModel###########-####-####-####-##########]
  
  
• In /opt/vmware/vcloud-director/logs/vcloud-container-debug.log the provider might see the following errors :
  
  com.vmware.vcloud.api.presentation.service.BusyEntityException: The entity Ref: com.vmware.vcloud.entity.catalogitem:####-####-####-####-############ is busy completing an operation LIBRARY_ITEM_SYNC.
at com.vmware.ssdc.backendbase.dao.impl.BusyObjectDaoImpl.createBusyEntityException(BusyObjectDaoImpl.java:##)
at jdk.internal.reflect.GeneratedMethodAccessorXXXX.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:##)
at java.base/java.lang.reflect.Method.invoke(Method.java:####)
  
  or 
  
  Caused by: com.vmware.cl.exception.InternalServerErrorException: The operation encountered an unspecified error.
at com.vmware.cl.impl.LibraryItemServiceImpl.deleteLibraryItemAndBacking(LibraryItemServiceImpl.java:1052)
at com.vmware.cl.impl.LibraryItemServiceImpl.delete(LibraryItemServiceImpl.java:923)
at com.vmware.cl.impl.LibraryItemServiceImpl.delete(LibraryItemServiceImpl.java:917)
at com.vmware.cl.clsp.sync.ClspLibrarySynchronizer.validateAndProcessItemToSync(ClspLibrarySynchronizer.java:109)
at com.vmware.cl.activities.LibraryItemSyncActivity.fetchAndResolveSubscribedItem(LibraryItemSyncActivity.java:389)
at com.vmware.cl.activities.LibraryItemSyncActivitySSyncInitializationPhase. invoke(LibraryItemSyncActivity.java:279)
.. 7 more
Caused by: org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.vmware.vcloud.common.model.VAppVmModel############-####-####-####-##########]
at org.hibernate.impl.SessionFactoryImp1$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.5.1.x
VMware Cloud Director 10.6.x

Cause

This issue occurs when there are stale entries present inside the catalog_item table in VCD DB, which makes VCD unable to synchronize the respective catalog. 

Resolution

If you encounter this issue contact Broadcom Support and note this Article ID (393712) in the problem description. For more information, see Creating and managing Broadcom support cases.