My Oracle Support Banner

t2t_KDD_CASE_CUST_ADDR job failed with ORA-02291 (Doc ID 2751475.1)

Last updated on FEBRUARY 15, 2021

Applies to:

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

Symptoms

On : 8.0.7 version, Web UI

t2t_KDD_CASE_CUST_ADDR job failed with ORA-02291.

Error is in below task logs.


Information Date: 20210105
Batch Run ID: BDFCCMINFO_1574180238072_20210105_1
Task ID: Task260
Task Description: t2t_KDD_CASE_CUST_ACCT
Metadata Value: t2t_KDD_CASE_CUST_ACCT
Component ID: LOAD DATA
Task Status: [10105] Failed

MessageID Description Severity Time
736625 [10862] Fetched information regarding the given Information Domain INFORM 2021-01-06 14:03:25
736643 [17372] Error in executing Insert Statement. ORA-00001: unique constraint (SHBAATM.PK_1723) violated FATAL 2021-01-06 14:03:26
736644 [10874] No. of rows Successfully Loaded ->:5 INFORM 2021-01-06 14:03:26
736645 [10875] No of rows Rejected->:1 INFORM 2021-01-06 14:03:26
736646 [10900] Loading Failed, exceeded the reject threshold FATAL 2021-01-06 14:03:26
736647 [10865] Loading Failed. FATAL 2021-01-06 14:03:26

Information Date: 20210105
Batch Run ID: BDFCCMINFO_1574180238072_20210105_1
Task ID: Task277
Task Description: t2t_KDD_CASE_CUST_ADDR
Metadata Value: t2t_KDD_CASE_CUST_ADDR
Component ID: LOAD DATA
Task Status: [10105] Failed

MessageID Description Severity Time
736615 [10862] Fetched information regarding the given Information Domain INFORM 2021-01-06 14:03:24
736628 [17372] Error in executing Insert Statement. ORA-02291: integrity constraint (SHBAATM.FK_1724_1) violated - parent key not found FATAL 2021-01-06 14:03:25
736629 [10874] No. of rows Successfully Loaded ->:0 INFORM 2021-01-06 14:03:25
736630 [10875] No of rows Rejected->:1 INFORM 2021-01-06 14:03:25
736631 [10900] Loading Failed, exceeded the reject threshold FATAL 2021-01-06 14:03:25
736632 [10865] Loading Failed. FATAL 2021-01-06 14:03:25
 
.

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
Cause
Solution
References


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