“ERROR: insert or update on table "role_right" violates foreign key constraint fk_roleright_to_rights" when upgrading VMware Cloud Director to 10.3.x versions.

Products

• VMware Cloud Director

Issue/Introduction

Symptoms:

• Upgrade of Cloud Director 10.1.x, 10.2.x to version 10.3.x will fail.
• Database upgrade will fail on Cloud Director 10.3.x when upgrading from versions 10.1.x or 10.2.x
• PSQLException: ERROR: insert or update on table "role_right" violates foreign key constraint "fk_roleright_to_rights" 

Environment

VMware Cloud Director 10.x

Resolution

This is a known issue affecting the Cloud Director 10.3.x versions.

If you cannot migrate to a Cloud Director 10.4 version, please open a Support Request.
The workaround involves Database Manipulation which should always be done in collaboration with VMware Technical Support.