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".
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.
