Worklist Error No 305100048 While Importing XML Files (Doc ID 2657643.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

We are facing the below error while accepting the xml file from ICSR pending screen

Error No 305100048 : Esm Failed to create entry in worklist for loaded ICSR case.

Error from CMN_ERROR_LOG:

Argus Safety.COM :- Oracle error 1 occurred. ORA-00001: unique constraint (ARGUS_APP.PK_USER_ACCESS) violated
Argus Safety.COM :- Oracle error 1 occurred. ORA-02291: integrity constraint (ARGUS_APP.FK_CSRO_CASE_ID) violated - parent key not found
Argus Safety.COM :- Oracle error 1 occurred. ORA-01403: no data found
Argus Safety.COM :- Oracle error 1 occurred. ORA-20006: ORA-01403: no data found


Error from SQL times:

[EnterpiseID: 1] 13-Aug-2019, 12:12:52:856, [8], UserId: XXXX, Exception DetailsMessage
Error:1; What: ORA-00001: unique constraint (ARGUS_APP.PK_USER_ACCESS) violated
Stack Trace


[EnterpiseID: 1] 13-Aug-2019, 12:12:52:887, [8], UserId: XXXX, Exception DetailsMessage
Error:1; Oracle error 1 occurred.
ORA-00001: unique constraint (ARGUS_APP.PK_USER_ACCESS) violated
SQL: insert into user_access (user_id, case_id) select gss_wnds.get_user_id(), :P_CASE_ID from dual
Stack Trace


[EnterpiseID: 1] 13-Aug-2019, 12:12:53:231, [8], UserId: XXXX, Exception DetailsMessage
Error:1; What: ORA-02291: integrity constraint (ARGUS_APP.FK_CSRO_CASE_ID) violated - parent key not found
Stack Trace


[EnterpiseID: 1] 13-Aug-2019, 12:12:53:231, [8], UserId: XXXX, Exception DetailsMessage
Error:1; Oracle error 1 occurred.
ORA-02291: integrity constraint (ARGUS_APP.FK_CSRO_CASE_ID) violated - parent key not found
SQL: Insert into CASE_ROUTING (case_id, seq_num, route_date, user_id, sort_id, comment_txt, comment_txt_j, workflow_seq_num, to_state_id, fr_state_id, Followup_Num, LAST_UPDATE_TIME) select :P_CASE_ID, :PI_ROUTING_SEQ_NUM , gss_util.gmt, GSS_WNDS.GET_USER_ID, 1, :P_ROUTE_CMNT, :P_ROUTE_CMNT_J, :PI_CM_WF_SEQ_NUM , :PI_CM_STATE_ID , 4, NULL, gss_util.gmt from DUAL
Stack Trace

Changes

Cause

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