My Oracle Support Banner

Event Occured As Consequence Error On Case Save - ORA-02291: integrity constraint (ARGUS_APP.FK_CASE_EVENT_DETAIL_SEQ_NUM) violated - parent key not found (Doc ID 2426583.1)

Last updated on JULY 26, 2018

Applies to:

Oracle Argus Safety - Version 7.0.5 and later
Information in this document applies to any platform.

Symptoms

On Applications Oracle Argus Safety Version : 7.0.5

If an event with an entry in event occurred as a consequence of it being deleted without having saved the event/consequence combination once. It is not possible to save the case.

e.g.

Error message: Error No:301200101
Description: Please contact your system administrator



On checking [Utilities] - Logs - Error Log below entry is created:

Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-02291: integrity constraint (ARGUS_APP.FK_CASE_EVENT_DETAIL_SEQ_NUM) violated - parent key not found
ORA-06512: at "ARGUS_APP.GSS_CASE", line 4783
ORA-06512: at line 1
SQL: BEGIN GSS_CASE.P_CASE_EVENT_CONSEQUENCE_IU(:PI_CASE_ID, :PI_SEQ_NUM, :PI_ED_SEQ_NUM, :PI_EVT_CONSEQUENCE_ID, :PI_CONSEQUENCE, :PI_TERM, :PI_CONSEQUENCE_J, :PI_TERM_J);
END;


Another error is displayed when the event was saved without an entry in the event occured as consequence of, then the an entry is completed but not saved and then the entire event is being deleted

Error No:
305100016
Description: Unexpected error occured during execution of Delete Case_event_details ! -- 2292 :ORA-02292: integrity constraint (ARGUS_APP.FP_CASE_EVENT_DETAIL_SEQ_NUM) violated - child record found Please inform your administrator!




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!


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