Error: "Internal Server Error - query did not return a unique result: 2; nested exception is org.hibernate.NonUniqueResultException" occurs when attempting to set a new default sizing policy

Products

• VMware Cloud Director

Issue/Introduction

• Want to change a different default sizing policy, but get an error stating:
  
  Internal Server Error - query did not return a unique result: 2; nested exception is org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  
  
• Within the Cloud Director log /opt/vmware/vcloud-director/logs/vcloud-container-debug.log the following exception is found:
  
  Caused by: 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 com.vmware.vcloud.common.repository.impl.SessionFactoryRepositoryTemplate.findUniqueByCriteria(SessionFactoryRepositoryTemplate.java:311)
    at jdk.internal.reflect.GeneratedMethodAccessor253.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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:241)
    at com.sun.proxy.$Proxy103.findUniqueByCriteria(Unknown Source)
    at com.vmware.ssdc.backend.dao.impl.ComputePolicyDaoImpl.getComputePolicyVdcLrModel(ComputePolicyDaoImpl.java:4201)
    at com.vmware.ssdc.backend.dao.impl.ComputePolicyDaoImpl.setVdcComputePolicyAsDefault(ComputePolicyDaoImpl.java:2888)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Environment

VMware Cloud Director 10.6.1

Cause

This issue occurs if there are multiple entries within the vdc_logical_resource table with the same fo_id linked to the tenant Org VDC.

Resolution

To resolve this issue, contact Broadcom Support and note this Article ID (419753) in the problem description. For more information, see Creating and managing Broadcom support cases.