"Could not execute JDBC batch update; SQL [/* Method: OrgService.deleteUser */ /*" error when deleting a user in VMware Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

Symptoms:

• The following error is seen in the UI when deleting a user:
• Could not execute JDBC batch update; SQL [/* Method: OrgService.deleteUser */ /* delete com.vmware.vcloud.common.model.OrganizationMember */ delete from org_member where org_member_id=?]; constraint [fk_custom_entity2org_member]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update - Could not execute JDBC batch update - Batch entry 0 /* Method: OrgService.deleteUser */ /* Method: OrgService.deleteUser */ /* delete com.vmware.vcloud.common.model.OrganizationMember */ delete from org_member where org_member_id='xxx'::uuid was aborted: ERROR: update or delete on table "org_member" violates foreign key constraint "fk_custom_entity2org_member" on table "defined_entity" Detail: Key (org_member_id)=(xxx) is still referenced from table "defined_entity". Call getNextException to see other errors in the batch. - ERROR: update or delete on table "org_member" violates foreign key constraint "fk_custom_entity2org_member" on table "defined_entity" Detail: Key (org_member_id)=(xxx) is still referenced from table "defined_entity".

Environment

VMware Cloud Director 10.x

Cause

• This issue occurs when there are Stale entries in the database blocking Cloud Director's ability to transfer the user's owned objects before deletion.

Resolution

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