Error: "could not execute update query - ERROR: update or delete table "logical_network" violates foreign key constraint "fk_net_interface2logical_net" on table "network_interface" Detail: Key (id)=(#######-####-##" when deleting Organization VDC networks

Products

• VMware Cloud Director

Issue/Introduction

• You are unable to remove Org VDC networks from an Organization VDC.
• Attempting to delete Org VDC networks from the VMware Cloud Director (VCD) UI fails, and you see a message similar to:

Error: [ #######-####-####-####-########### ] could not execute update query - ERROR: update or delete table "logical_network" violates foreign key constraint "fk_net_interface2logical_net" on table "network_interface" Detail: Key (id)=(#######-####-####-####-###########) is still referenced from table "network_interface".

• The message may be related to another referenced network such as:

ERROR: update or delete on table "logical_network" violates foreign key constraint "fk_logical2logical_network" on table "logical_network" Detail: Key (id)=(#######-####-####-####-###########) is still referenced from table "logical_network".

Environment

• VMware Cloud Director 10.5.x
• VMware Cloud Director 10.6.x

Cause

This issue occurs because of stale child entries in the Cloud Director database that prevent the deletion of an affected Organization VDC network.

Resolution

This is a known issue which can affect all versions of VMware Cloud Director.

Workaround:

To work around this issue, contact VMware Cloud Director Support and note this Article ID (375420) in the problem description.