Error "query did not return a unique result: 2" when deleting VM or editing VM Storage Policy and VM Settings in VMware Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

• Unable to edit VM Settings such Storage Policy or delete VM resources in VCD
• Attempts to modify VM settings fail with the following error:

query did not return a unique result: 2

Environment

VMware Cloud Director 10.x

Cause

This issue occurs due to the presence of duplicate entries in the database for the affected Virtual Machine. Specifically, the duplicates are found in the 'computevm' table

Resolution

To resolve this issue, please Contact Broadcom Support.

Removal of duplicate entries requires database modifications, which must be performed with assistance from VMware Technical Support.