"query did not return a unique result" error received when attempting to manage a VM in VMware Cloud Director 10.2

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 vcloud-container-debug.log you see an entry such as
  • at com.vmware.vcloud.common.persist.dao.impl.HibernateManagedServerDao.findHostByValRef(HibernateManagedServerDao.java:106)
• In the vcloud-container-debug.log you see an entry such as
  • at com.vmware.vcloud.fabric.storage.dao.impl.HibernateDatastoreDao.findByValref(HibernateDatastoreDao.java:39)

Environment

VMware Cloud Director 10.x

Cause

This is a Known Issue affecting VMware Cloud Director 10.2.

The issue occurs when new objects such as Datastores or Hosts are added to the vCenter Inventory.

The addition of a new object triggers an update to Cloud Director and when more than one thread starts processing this update, it causes a duplicate entry to be inserted into the Cloud Director Database.

Resolution

To resolve this issue, please open a Support Request.
Database modifications are required to remove those duplicate entries and will require VMware Technical Support assistance.