Error "aborted\"role\" violates foreign key constraint \"fk_orgmember_to_role\" on table \"org_member\"\" when attempting to delete Object Storage Extension Add-On from VMware Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

• When attempting to delete the Object Storage Extension (OSE) Add-On from the VMware Cloud Director 10.6.1 environment, the task fails with an “Internal Server Error (500)”.
  
  (VCD UI > More > Solution Add-On > OSE Deployment > Tasks )
  
  
  
  
• In the Task Details, the following error is observed:
  
  Could not execute JDBC batch update\n - Batch entry 0 /* Method: unknown */ /* Methoccom.vmware.vcloud.common.model.rights.Role */ delete from role where role_id=('########-####-####-####-############' :: uuid) was aborted\"role\" violates foreign key constraint \"fk_orgmember_to_role\" on table \"org_member\"\n Detail: Key (role_id)=('########-####-####-####-############' from table \"org_member\".

Environment

VMware Cloud Director 10.6.1
Object Storage Extension 3.1  

Cause

The OSE Add-On deployment in VMware Cloud Director failed during the installation phase leaving stale references for role “Object Storage Operator”. As a result, the deletion task fails due to foreign key constraint dependencies in the database.

Resolution

Database modifications are required to remove role references from Cloud Director. To resolve this issue, please open a Support Request with Broadcom Technical Support and note this Article ID (417864) in the problem description.  For more information, see Creating and managing Broadcom support cases

Additional Information

For more information on OSE Add-On, refer: Creating a VMware Cloud Director Object Storage Extension add-on instance fails with an error