ERROR: update or delete on table "storage_class" violates foreign key constraint "fk_vm_dis_sto_cl2storage_class" on table "vm_disk_storage_class" while deleting the Storage Policy from Provider VDC

Products

• VMware Cloud Director

Issue/Introduction

• When attempting to delete a Storage Policy from a Provider VDC, the following error message is displayed:
  
  ERROR: update or delete on table "storage_class" violates foreign key constraint "fk_vm_dis_sto_cl2storage_class" on table "vm_disk_storage_class"
  
  
  
• The Storage Policy no longer appears in the Provider Portal GUI

Cause

This issue occurs when stale entries remain in the database for VMs that references the storage policy being deleted.

Resolution

Database modification is needed. Please contact Broadcom Support and note this Article ID (427933) in the problem description.
For more information, see Creating and managing Broadcom support cases.