Error: "null id in com.vmware.vcloud.common.model.event.AuditTrailEventModel entry (don't flush the Session after an exception occurs)" when trying to delete an Organization

Products

• VMware Cloud Director

Issue/Introduction

• Deletion of the organization fails with port profiles error as below:
  
  [ ########-####-####-####-############ ] You must delete this Organization's Application Port Profiles before you can delete the organization.
  
  
• Force deleting organization via API as per the article Error: "You must delete this Organization's Application Port Profiles before you can delete the organization." when deleting an organization in VMware Cloud Director fails with:

 [ ########-####-####-####-############ ] null id in com.vmware.vcloud.common.model.event.AuditTrailEventModel entry (don't flush the Session after an exception occurs)
- null id in com.vmware.vcloud.common.model.event.AuditTrailEventModel entry (don't flush the Session after an exception occurs)

• The disabled organization previously used VMware Cloud Director Container Service Extension(CSE) 3.x in their environment and was recently decommissioned.
  
  
• The /opt/vmware/vcloud-director/logs/vcloud-container-debug.log file shows deletion of app profiles were completed and there are no user objects found. But then it fails with:
  
  ERROR    | task-service-activity-pool-######## | JDBCExceptionReporter          | Batch entry 0 /* Method: unknown */ /* Method: unknown */ /* delete com.vmware.vcloud.common.model.OrganizationMember */ delete from org_member where org_member_id='1#######-####-####-####-############'::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)=(1#######-####-####-####-############) is still referenced from table "defined_entity".  Call getNextException to see other errors in the batch. ...
  
  
• There are no child objects as seen from the VMware Cloud Director(VCD) UI in this organization other than users.

Environment

VMware Cloud Director 10.6.1

VMware Cloud Director Container Service Extension 3.x

 

Cause

This issue is caused when VCD is deleting the users as part of the organization deletion.

As there are stale references for some of these users to the old CSE 3.x clusters, the deletions are failing.

Resolution

For assistance, contact technical support and note this Knowledge Article ID (403300) in the problem description. For more information, see How to Submit a Support Request.