My Oracle Support Banner

Correlation job 508 Of Behavior Detection Is Finished On Error (Doc ID 2431624.1)

Last updated on SEPTEMBER 08, 2018

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 version, Alert Post Process

Job 508 of Behavior Detection is finished on error

The process is taking a close alert to Correlation Alerts, below the error of the Job

08/02/2018 17:02:02 DEBUG : Thread ID = 139937773606656: Alert Correlation: File = AlertCorrelationRun.cc: Line = 1154: BEGIN ofsaafccm.pkg_prmtcase.p_linkcase('326,325,324,317,314,313,312,311,310,309,308,303,302,298,293,292,290,286,285,284,283','4241',NULL,'SYSTEM','Y',:O1);END;
Error Msg :-> ORA-02291: integrity constraint (OFSAAFCCM.FK_931_2) violated - parent key not found
ORA-06512: at "OFSAAFCCM.PKG_PRMTCASE", line 3262
ORA-06512: at "OFSAAFCCM.PKG_PRMTCASE", line 2160
ORA-06512: at "OFSAAFCCM.PKG_PRMTCASE", line 387
ORA-06512: at line 1

08/02/2018 17:02:04 FATAL : Thread ID = 139937773606656: Alert Correlation: File = UtilityFunctions.cc: Line = 71: ERROR : Could not Execute

 

ERROR
-----------------------
ORA-02291: integrity constraint (OFSAAFCCM.FK_931_2) violated - parent key not found




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run correlation job start_mantas.sh 508

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are not able to run correlation




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.