"Cannot enable download" error when downloading a vApp Template in Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

Symptoms:

• Downloading a vApp Template in Cloud Director fails with an error:

Cannot enable download

• The task details shows an error similar to:

query did not return a unique result: 2

• The /opt/vmware/vcloud-director/logs/vcloud-container-debug.log file shows entries similar to:

Caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 2
com.vmware.vcloud.common.persist.dao.AbstractHibernateDaoBase.findUniqueByCriteria(AbstractHibernateDaoBase.java:320)
at com.vmware.vcloud.common.persist.dao.impl.HibernateManagedServerDao.findHostByDisplayName(HibernateManagedServerDao.java:98)

Cause

This issue can be caused by duplicate ESXi host entries in the managed_server table in the Cloud Director database for the same ESXi host name.

Resolution

To resolve this issue, please open a Support Request with VMware Technical Support and reference this KB article 89987.
Database modifications may be required to resolve this issue and will require VMware Technical Support assistance.