Error "[UUID] Internal Server Error - query did not return a unique result: 2" while performing "Migrate Storage" from one storage policy to another in VCD

Products

• VMware Cloud Director

Issue/Introduction

• Navigate to Provider UI > Resources > Cloud Resources > Organization VDCs > select org vdc > Policies > Storage > select the storage policy and click on "Migrate Storage", fails with an error:  Internal Server Error - query did not return a unique result: 2
• In the /opt/vmware/vcloud-director/logs/vcloud-container-debug.log, you see an entry similar to:

2025-10-13 10:23:58,576 | ERROR    | task-service-activity-pool-951 | FutureUtil                     | Task future is not complete. | requestId=#######-####-####-####-##########,re
quest=POST https://vcd.example.com/cloudapi/1.0.0/orgVdcStoragePolicies/urn:vcloud:orgvdcstoragepolicy:########-####-####-...,requestTime=1760333035811,remoteAddress=##.##.##.##:#####,userAgent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 ...,accept=application/json;version 40.0.0-alpha vcd=########-####-####-####-############,task=########
-#####-####-####-############ activity=(com.vmware.vcloud.backendbase.management.system.TaskActivity,urn:uuid:########-####-####-####-############)
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
        at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:844)
        at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:328)
        at jdk.internal.reflect.GeneratedMethodAccessor156.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at com.vmware.vcloud.common.db.HibernateClassLoaderHelperBeanPostProcessor$SessionInvocationHandler.invoke(HibernateClassLoaderHelperBeanPostProcessor.java:280)
        at com.sun.proxy.$Proxy150.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:611)
        at com.vmware.vcloud.vdc.VAppParamConversionUtils.computeVmPlacementRequirements(VAppParamConversionUtils.java:1614)
        at com.vmware.vcloud.vdc.VAppParamConversionUtils.computeVmPlacementRequirements(VAppParamConversionUtils.java:1576)
        at com.vmware.vcloud.vdc.VAppParamConversionUtils.vmSubjectForStoragePolicy(VAppParamConversionUtils.java:2686)
        at com.vmware.vcloud.vdc.VAppParamConversionUtils.placementSubjectInfo(VAppParamConversionUtils.java:2634)
        at com.vmware.vcloud.placementfacade.impl.PlacementServiceFacadeImpl.init(PlacementServiceFacadeImpl.java:305)

Environment

VMware Cloud Director 10.6.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 (415513) in the problem description. For more information, see Creating and managing Broadcom support cases.