Duplicate entries of a virtual machine are seen in Cloud Director UI.

Products

• VMware Cloud Director

Issue/Introduction

• Multiple entries of the same VM are listed in VCD UI.
• While trying to access the VM, "This Operation is denied" error is thrown.
  
  
  
  
• In /opt/vmware/vcloud-director/logs/vcloud-container-debug.log contains the below error:

  2025-##-## ##:30:17,173 | ERROR    | pool-jetty-612781         | AuthorizationMethodInterceptor | Error in authorization. | requestId=########################,request=GET https://<Cloud_Director-FQDN>/api/vApp/vm-################,requestTime=#######,remoteAddress=##.##.##.##:####,userAgent=Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:146.0) Gecko/201...,accept=application/*+xml;version 40.
  0.0-alpha
  org.hibernate.HibernateException: More than one row with the given identifier was found: ########################, for class: com.vmware.vcloud.fabric.storage.model.publicview.VirtualMachineView
          at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:92)
          at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)
          at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3072)

Environment

Cloud Director 10.6

Cause

This issue occurs if the connectivity between Cloud Director and vCenter fails due to the authorization.

Resolution

• Update vCenter credentials in VCD.
  
  From VCD Provider UI, navigate to Resources -> Infrastructure Resources -> Select the vCenter in question -> Edit -> Update the credentials and click on Save.
  
  
• Select the vCenter in question and click on Reconnect, Refresh and Refresh Policies.
  

After the refresh, only one entry for a VM in the UI should appear. If the issue still persists, please refer to the steps mentioned in the kb:

Error: 'More than one row with the given identifier was found: <uuid>' when trying to view Virtual Machines in VMware Cloud Director