Error on power off or suspend. - No row with the given identifier exists: [com.vmware.vcloud.fabric.compute.model.ComputeHubModel] causes Power Off or Suspend VM tasks to fail

Products

• VMware Cloud Director

Issue/Introduction

• Tasks such as Suspend VM, Power Off VM, or viewing vApp details fail with an Internal Server Error.
  
  Error on power off or suspend. - No row with the given identifier exists: [com.vmware.vcloud.fabric.compute.model.ComputeHubModel#########-####-####-####-############]
  
  
• The detailed error log shows debug error information similar to the following 

[#########-####-####-####-############ ] Error on power off or suspend. - No row with the given identifier exists: [com.vmware.vcloud.fabric.compute.model.ComputeHubModel##########-####-####-####-############]
com.vmware.ssdc.library.exceptions.UndeployVMException: Error on power off or suspend. 
    at com.vmware.ssdc.backend.UndeployVirtualMachinesActivity$UndeployVMComputeFabricPhase.invoke(UndeployVirtualMachinesActivity.java:247) 
    at com.vmware.vcloud.activity.executors.ActivityRunner.runPhase(ActivityRunner.java:175) 
    at com.vmware.vcloud.activity.executors.ActivityRunner.run(ActivityRunner.java:112) 
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) 
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) 
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) 
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) 
    at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.vmware.vcloud.fabric.compute.model.ComputeHubModel#1#########-####-####-####-############] 
    at org.hibernate.impl.SessionFactoryImpl$2.handleEntityNotFound(SessionFactoryImpl.java:409) 
    at org.hibernate.event.def.DefaultLoadEventListener.returnNarrowedProxy(DefaultLoadEventListener.java:258) 
    ...
Caused by: java.lang.NullPointerException 
    at com.vmware.vcloud.fabric.compute.chs.HibernateComputeHubSetDao.getVcIdMoRefByModel(HibernateComputeHubSetDao.java:333) 
    at com.vmware.vcloud.fabric.compute.chs.HibernateComputeHubSetDao.getVALRefByModel(HibernateComputeHubSetDao.java:369) 
    at com.vmware.vcloud.fabric.compute.vrp.GenericVirtualResourcePool.computeResourcePoolConfig(GenericVirtualResourcePool.java:2044) 
    ...

• Issue typically occurs after manually detaching a Cluster Resource Pool or removing Storage Policies associated with a Provider VDC.

Environment

VMware Cloud Director 10.x

Cause

This issue occurs because VMware Cloud Director retains stale database references to a Compute Hub (the logical representation of a vCenter Resource Pool) that no longer exists or has been disconnected. When VCD attempts to perform compute-related operations or synchronize state, the underlying Hibernate logic fails to locate the row in the computehub table, triggering the exception.

Resolution

The workaround for this issue requires modification of the Cloud Director database.
For assistance, contact Broadcom Support and note this Article ID (442697) in the problem description. For more information, see Creating and managing Broadcom support cases