Error: "query did not return a unique result ... at com.vmware.vcloud.fabric.compute.cvm.HibernateComputeVmDao.lookupByVmValRef(HibernateComputeVmDao.java:543)" when editing a VM

Products

• VMware Cloud Director

Issue/Introduction

• When attempting to manage a VM in the VMware Cloud Director (VCD) UI, you see an error similar to:
  
  [ ########-####-####-####-########de22 ] query did not return a unique result: #
  Where # denotes a value such as 2.
  
  
• On the VCD cell in the /opt/vmware/vcloud-director/logs/vcloud-container-debug.log you see an entry similar to:
  
  DEBUG    | task-service-activity-pool-2283 | CJob                           | updateFailedJob(org.hibernate.NonUniqueResultException) with locale=en_US | requestId=#######-####-####-####-#######,request=POST https://vcloud.example.com/api/vApp/vm-#######-####-####-####-#######/action/reconfigureVm,requestTime=1777280067710,remoteAddress=<ipaddress>:46608,userAgent=Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/201...,accept=application/*+xml;version 40.0.0-alpha vcd=#######-####-####-####-#######,task=#######-####-####-####-####### activity=(com.vmware.vcloud.backendbase.management.system.TaskActivity,urn:uuid:#######-####-####-####-#######)
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
        at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:844)
        at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:328)
        at jdk.internal.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at com.vmware.vcloud.common.db.HibernateClassLoaderHelperBeanPostProcessor$SessionInvocationHandler.invoke(HibernateClassLoaderHelperBeanPostProcessor.java:280)
        at com.sun.proxy.$Proxy151.uniqueResult(Unknown Source)
        at com.vmware.vcloud.common.persist.CriteriaProxy.uniqueResult(CriteriaProxy.java:261)
        at com.vmware.vcloud.fabric.compute.cvm.HibernateComputeVmDao.lookupByVmValRef(HibernateComputeVmDao.java:611)

Environment

VMware Cloud Director 10.x

Cause

This issue can occur if Cloud Director has duplicate references to a VM in its database.

Resolution

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

Alternatively, the VM can be removed from vCenter and VCD, then re-imported into VMware Cloud Director. For more information, see How to remove a virtual machine from Management in Cloud Director.