Unable to delete an empty vApp which may show in "Unresolved" or "Failed creation" state

Products

• VMware Cloud Director

Issue/Introduction

• The vApp is in "Unresolved" state and the delete option is greyed out.
• Deleting a vApp which is in "Failed creation" state from VMware Cloud Director (VCD) UI gives the below error:
  
  [########-####-####-###########] Internal Server Error - java.lang.NullPointerException


• Inspection of the error available from the COPY DEBUG INFORMATION button on the failed task shows the following error: 
  
  com.vmware.vcloud.api.presentation.service.InternalServerErrorException: Internal Server Error
at com.vmware.vcloud.common.future.FutureUtil.convertExecutionException(FutureUtil.java:264)
at com.vmware.vcloud.common.future.FutureUtil.checkCompletedFuture(FutureUtil.java:203)
at com.vmware.vcloud.backendbase.management.system.TaskActivity$PostExecutePhase.invokeInner(TaskActivity.java:883)
at com.vmware.vcloud.backendbase.management.system.TaskActivity$TaskActivityBasePhase.invokeCancelableOperation(TaskActivity.java:378)
at com.vmware.vcloud.common.activity.toolkit.VcdAbstractActivity$CancelablePhase.invoke(VcdAbstractActivity.java:591)
.. 7 more
Caused by:java.lang.NullPointerException
at com.vmware.ssdc.backend.dao.impl.HibernateVAppDao.deleteVAppById(HibernateVAppDao.java:428)
at com.vmware.vcloud.vdc.impl.DeleteVappActivity$RemoveVAppFromDBPhase.lambda$invoke$2(DeleteVappActivity.java:558)
at com.vmware.vcloud.common.persist.ConversationFactoryImpl.execute(ConversationFactoryImpl.java:444)
  
  
• A vApp which is in FAILED CREATION status may also prevent the deletion of an Organization VDC.
• Deleting a vApp created by backup application which is in "Resolved" state from VMware Cloud Director (VCD) UI gives the below error: 

"The object 'vim.VirtualMachine' has already been deleted or has not been completely created"

Environment

• VMware Cloud Director 10.6.x

Cause

• This issue occurs when the vApp is in partially created state or deleted from underlying infrastructure(vSphere).

Resolution

• Database modification is required to resolve this issue. These steps are destructive and must not be performed without a verified database backup.Please contact Broadcom Support and note this Article ID (372992) in the problem description.