Error: "Unable to complete sync for catalog" when synchronizing catalogs from publisher catalog to the subscriber catalog

Products

• VMware Cloud Director

Issue/Introduction

• Subscribed catalogs in VMware Cloud Director (VCD) display a "Not Synced" status. 
• When you start the synchronization (manually or automatically) it shows the status as syncing templates and after a few seconds it deletes the templates automatically from the subscribed catalog.
• Within the failed task in the UI the following details are visible:
  
  com.vmware.cl.exception.ContentLibraryException: Unable to complete sync for catalog urn:uuid:########-####-####-####-############
at com.vmware.cl.SyncManager. submitAndWaitItemsForSync (SyncManager. java: 364)
at com.vmware.cl.SyncManager. syncLibraryTask(SyncManager. java: 318)
at com.vmware.c1.SyncManager.executeTask(SyncManager.java:423)
  
  
• You will see the below errors in the /opt/vmware/vcloud-director/logs/vcloud-container-debug.log

DEBUG    | content-library-activity-pool74451 | ClspLibrarySynchronizer        | Publisher returned empty items list, deleting item (id: urn:uuid:########-####-####-####-############, name: <Name of the Template>) from subscriber side. | requestId=########-####-####-####-########7a1d,request=POST https://<vcd-fqdn>/api/catalog/########-####-####-####-########/action/sync,requestTime=<Time-Format>,remoteAddress=xx.xx.xx.xx:xxxxx,userAgent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) 

Environment

VMware Cloud Director 10.6.1

Cause

Catalog items copied from a subscribed catalog in the publisher site incorrectly retain a populated source_uri column in the VCD database. When publishing this catalog to another site, the synchronization logic interprets the non-null source_uri as reference it cannot validate, causing the publisher to return an empty items list.

Resolution

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