Error "query did not return a unique result: 2" when editing VM Storage Policy and VM Settings

Products

• VMware Cloud Director

Issue/Introduction

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

query did not return a unique result: 2

Environment

VMware Cloud Director 10.5.1.1

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.