Error: "ORA-02298: cannot validate" when running the Update Readiness Tool

Products

• Data Loss Prevention Core Package
• Data Loss Prevention
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

When running the URT (Nov2024), it fails with the following error:

Start: Upgrade Foreign Keys - 2025-05-30 00:24:20
   Error - ALTER TABLE INCIDENT ADD CONSTRAINT INCIDENT_FK4 FOREIGN KEY (CUSTOMATTRIBUTESRECORDID) REFERENCES CUSTOMATTRIBUTESRECORD(CUSTOMATTRIBUTESRECORDID) D
EFERRABLE INITIALLY IMMEDIATE - ORA-02298: cannot validate (DLPRTOOL.INCIDENT_FK4) - parent keys not found
   Error - ALTER TABLE INCIDENTACTIONPARAMETER ADD CONSTRAINT INCIDENTACTIONPARAMETER_FK1 FOREIGN KEY (INCIDENTACTIONID) REFERENCES INCIDENTACTION(INCIDENTACTIO
NID) ON DELETE CASCADE DEFERRABLE INITIALLY IMMEDIATE - ORA-02298: cannot validate (DLPRTOOL.INCIDENTACTIONPARAMETER_FK1) - parent keys not found
End  : Upgrade Foreign Keys - elapsed 26s - FAILED (2 errors)

Cause

This failure is the result of the dlprtool schema not having the expected primary keys for the CUSTOMATTRIBUTESRECORD and INCIDENTACTION tables.

This can be verified by running the following SQL queries while logged using dlprtool.

select table_name,constraint_name,status,validated,index_owner,index_name from user_constraints where table_name in ('CUSTOMATTRIBUTESRECORD','INCIDENTACTION') and constraint_type='P';
select table_name,index_name,status from user_indexes where table_name in ('CUSTOMATTRIBUTESRECORD','INCIDENTACTION') and index_name like '%PK';

Resolution

The dlprtool user will need to be rebuilt.
Contact Support for assistance correcting this issue.