My Oracle Support Banner

Error In Upgrade From 802 To 805 (Doc ID 2751296.1)

Last updated on FEBRUARY 16, 2021

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Errors thrown during OFS-BD 805 upgradation from Ver802.

[Thu  04/2/2021 01:09:36] [OFSAAI] [ INFO] - Executing file:/app/AML/Ofsaa/fichome2021.02.04.12.07.21/SQLScripts/AtomicSchema/Application_Scripts/AM/INSERT_KDD_ROLE_ACTIVITY_TYPE.sql
[Thu  04/2/2021 01:09:36] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS860', 'AMANALYST2')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:09:36] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS860', 'AMANALYST3')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:09:36] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS860', 'AMSUPVISR')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found
Line 1593: [Thu  04/2/2021 01:09:36] [OFSAAI] [ INFO] - # of errors in file=3



file:/app/AML/Ofsaa/fichome2021.02.04.12.07.21/SQLScripts/AtomicSchema/Application_Scripts/AM/AM_KDD_ROLE_ACTIVITY_TYPE.sql
[Thu  04/2/2021 01:13:03] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS860', 'AMANALYST2')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:13:03] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS860', 'AMANALYST3')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:13:03] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS860', 'AMSUPVISR')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:13:03] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS851', 'AMANALYST2')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:13:03] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS851', 'AMANALYST3')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:13:03] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS851', 'AMSUPVISR')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:13:03] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS869', 'AMANALYST2')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:13:03] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS869', 'AMANALYST3')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:13:03] [OFSAAI] [ERROR] - Query:'
insert into KDD_ROLE_ACTIVITY_TYPE (ACTVY_TYPE_CD, ROLE_CD)
values ('MTS869', 'AMSUPVISR')
'
   Error:ORA-02291: integrity constraint (MANTAS.FK_597_1) violated - parent key not found

[Thu  04/2/2021 01:13:03] [OFSAAI] [ INFO] - # of errors in file=9

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.