Unable to start Identity Portal after upgrading to 14.5.1

Products

• CA Identity Suite

Issue/Introduction

We have a standalone installation of Identity Manager and Identity Portal. Recently, we upgraded from version 14.4.2 to 14.5, and then to 14.5.1. However, after upgrading to 14.5.1, the portal fails to start. The following error is displayed:

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FKsv5ynskj41sirgc25mqkefstd". The conflict occurred in database "TestIDMPortal", table "dbo.Request", column 'id'.

Environment

Release : 14.5.1
Component : CA Identity Portal

Resolution

We checked if there is any data integrity violation using below query:
SELECT rootId FROM request_backend WHERE rootId NOT IN (SELECT id FROM Request);

There are 3 rootId values in request_backend that are not in Request.

Deleted the orphan records from the request_backend table, committed the changes, and then the Identity Portal started without any issues.