"query did not return a unique result ... at com.vmware.vcloud.fabric.compute.cvm.HibernateComputeVmDao.lookupByVmValRef(HibernateComputeVmDao.java:543)" error when attempting to manage a VM in Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

Symptoms:

• In the UI, when managing a VM you see the following error:

org.hibernate.NonUniqueResultException: query did not return a unique result: X
Where X denotes a value such as 2.

• In the /opt/vmware/vcloud-director/logs/vcloud-container-debug.log you see an entry such as:

at com.vmware.vcloud.fabric.compute.cvm.HibernateComputeVmDao.lookupByVmValRef(HibernateComputeVmDao.java:543)

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, please open a Support Request with VMware Technical Support and reference this KB article 95800.
Database modifications may be required to resolve this issue and will require VMware Technical Support assistance.