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.
  
  
• In the /opt/vmware/vcloud-director/logs/vcloud-container-debug.log, you see an entry similar to:
  
  org.hibernate.NonUniqueResultException: query did not return a unique result: #
    ...
    at com.sun.proxy.$Proxy153.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:635)
    ...

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.