Error: "update or delete on table "app_template" violates foreign key constraint "<Template Name>" on table "catalog_item"" when attempting to delete a stuck Catalog Item in Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

• Error when we are trying to remove this Template/ISO from Catalogs in Cloud Director UI

Details : [ #########-####-####-####-############ ] Internal Server Error
 - Could not execute JDBC batch update; SQL [/* Method: unknown */ /* delete com.vmware.vcloud.common.model.contenthub.AppTemplateModel */ delete from app_template where id=?]; constraint [<Template Name>]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
 - Batch entry 0 /* Method: unknown */ /* Method: unknown */ /* delete com.vmware.vcloud.common.model.contenthub.AppTemplateModel */ delete from app_template where id='#########-####-####-####-############'::uuid was aborted: ERROR: update or delete on table "app_template" violates foreign key constraint "<Template Name>" on table "catalog_item"
  Detail: Key (id)=(#########-####-####-####-############) is still referenced from table "catalog_item".  Call getNextException to see other errors in the batch.

• You might notice the following error during NSX V2T cleanup 

vcdOperations]:[migrateCatalogItems]:3768 [WARNING] [hostedsol]| Media Items - vappTemplate-#########-####-####-####-############,vappTemplate-#########-####-####-####-############,vappTemplate-#########-####-####-####-############,vappTemplate-#########-####-####-####-############,vappTemplate-#########-####-####-####-############,vappTemplate-#########-####-####-####-############,vappTemplate-#########-####-####-####-############,vappTemplate-#########-####-####-####-############ with no catalog linked to them exists. Migration of catalog might fail. Please remove stale items manually.

Environment

VMware Cloud Director 10.x

Cause

This issue may occur when uploading a vApp Template to a Catalog and cancelling the task midway.

Resolution

If the Catalog Item cannot be deleted from the Cloud Director UI or API please contact Broadcom Support and note this Article ID (372652) in the problem description.
For more information, see Creating and managing Broadcom support cases.