Worklist Error No 305100048 While Importing XML Files
(Doc ID 2657643.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Interchange - Version 8.1.1 and laterOracle Life Sciences Argus Safety - Version 8.1.1 and later
Information in this document applies to any platform.
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
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 |
References |