Error: "ERROR: duplicate key value violates unique constraint "uq_acl_general_pri_id_obj_id_ten_id" Detail: Key (principal_id, object_id, tenant_id)=(<VALUES>)" when attempting to delete a user and reassign owned objects

Products

• VMware Cloud Director

Issue/Introduction

• When attempting to delete another user, cannot reassign owned objects to the currently logged in user
• The Cloud Director (VCD) UI shows an error: 

   

  
  [ <###########> ] could not execute native bulk manipulation query - ERROR: duplicate key value violates unique constraint "uq_acl_general_pri_id_obj_id_ten_id" Detail: Key (principal_id, object_id, tenant_id)=(<##########, ##########, ########>) already exists.

Environment

VMware Cloud Director 10.6.x

Cause

This error is caused by stranded objects in the acl_general table of the DB, during the transfer of objects in the delete user task.  

Resolution

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