Upgrading ARD 3.0 / 3.1 Docker version the upgrade fails when trying to go directly to ARD 3.2.5 Docker version

Products

• CA Agile Requirements Designer

Issue/Introduction

We followed the documentation to upgrade are ARD Hub Docker implementation from ARD 3.1 to ARD 3.2.5 and we 
found that the keycloak image is not starting.
The logs have errors in it such as below:
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 64) Error has occurred while updating the database: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/jpa-changelog-13.0.0.xml::default-roles::keycloak:
     Reason: liquibase.exception.DatabaseException: Cannot add or update a child row: a foreign key constraint fails (`keycloak`.`KEYCLOAK_ROLE`, CONSTRAINT `FK_6VYQFE4CN4WLQ8R6KT5VDSJ5C` FOREIGN KEY (`REALM`) REFERENCES `REALM` (`ID`)) [Failed SQL: INSERT INTO keycloak.KEYCLOAK_ROLE (ID, CLIENT_REALM_CONSTRAINT, CLIENT_ROLE, DESCRIPTION, NAME, REALM_ID, REALM) VALUES ('ff1b119e-8465-4e99-aeb7-cbb1f9121409', 'ARD', 0, '${role_default-roles-ard}', 'default-roles-ard', 'ARD', 'ARD')]

Environment

Agile Requirments Designer 3.2.5
ARD 

Cause

There is a problem with the ARD.SH upgrade script.

Resolution

During the upgrade process, a backup was automatically made.
If you do not have a system-wide backup from before the upgrade started to restore please follow the documentation below to restore the Upgrade process backup.
Upgrade, Reconfigure, or Back Up ARD Hub (broadcom.com)

This will restore you to a working copy of your original ARD 3.1 installation.
Next please upgrade to ARD 3.2 FIRST
Then you can redo the upgrade to the final ARD 3.2.5