deleting an organization in VCFA 9 failed with error 'update or delete on table "organization" violates foreign key constraint "fk_vc_ip_sp_or_a2organization" on table "vcf_ip_space_org_quota"'

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Deleting an organization failed with Error:

[ ########-####-####-####-############ ] Could not execute JDBC batch update - Batch entry 0 /* Method: unknown */ /* Method: unknown */ /* delete com.vmware.vcloud.common.model.Organization */ delete from organization where org_id=('########-####-####-####-############'::uuid) was aborted: ERROR: update or delete on table "organization" violates foreign key constraint "fk_vc_ip_sp_or_a2organization" on table "vcf_ip_space_org_quota" Detail: Key (org_id)=(########-####-####-####-############) is still referenced from table "vcf_ip_space_org_quota". Call getNextException to see other errors in the batch.

 

Environment

VCF Automation 9.0

Cause

The organization is still configured with regional networking.

Resolution

Remove the organization networking configuration within the organization, Networking tab. If this is failing login to NSX and delete each VPC for this project.