Facing 404 error after upgrade to ARD 3.2.7

Products

• CA Agile Requirements Designer

Issue/Introduction

We upgraded to ARD 3.2.7 and currently we are facing below errors in the UI:

Error 404: resource not found.

 

General Keycloak client error from reason: HTTP 500 Internal Server Error

The flow-storage log shows below error:

2022-11-23 18:07:22.543 ERROR [flow-storage,,] 18149 --- [main] o.f.core.internal.command.DbMigrate      : Migration of schema [DBO] to version "0.1.0.790 - InsertIntoFolderNewExamples" failed! Changes successfully rolled back.
2022-11-23 18:07:22.557 ERROR [flow-storage,,] 18149 --- [main] ardflowstorage.dal.TenantSchemaDao       : Flyway migration failed.

org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: Migration V0_1_0_790__InsertIntoFolderNewExamples.sql failed
------------------------------------------------------------
SQL State  : 23000
Error Code : 547
Message    : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Folder_Collection". The conflict occurred in database "ARDFlowStorage", table "dbo.Project", column 'id'.
Location   : ardflowstorage/sql/tenant/mssql/V0_1_0_790__InsertIntoFolderNewExamples.sql (/opt/SP/ard/apache-tomcat/webapps/ard#flow-storage/WEB-INF/classes/ardflowstorage/sql/tenant/mssql/V0_1_0_790__InsertIntoFolderNewExamples.sql)
Line       : 1

Environment

Release : 3.2.7

Cause

This issue was caused due to missing Examples project in the backend as it was deleted accidently. 

When starting for the first time after upgrade, the application will try to add new flows into examples project. Since the project was missing, it failed and caused the UI error.

Resolution

To resolve the issue, below property can be added in settings.properties and updated in application.properties files at following locations. 

flow_storage.database.populate_example_project=false

.ard\conf\settings.properties

tomcat_home\webapps\ard#flow-storage\WEB-INF\classes\application.properties

This action will skip the task of adding new flows to the examples project and will not impact if examples project exists or not.