301300103 Error When Try To Open A Case
(Doc ID 1554645.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety Japan - Version 6.0 and laterInformation in this document applies to any platform.
Symptoms
When user tries to open a case, the following error message is displayed and the case cannot be opened.
Error Shown for English User:
-------------------------------------------------------------------------
Error No: 301300103 Description: The case id is not valid. It does not exist. Please try again.
-------------------------------------------------------------------------
Error Shown for Japanese User:
-------------------------------------------------------------------------
エラー番号: 301300103 詳細: *** J The case id is not valid. It does not exist. Please try again.
-------------------------------------------------------------------------
When this symptom occurs, the following error messages are recorded in the CMN_ERROR_LOG table and Sqltimes log file.
-------------------------------------------------------------------------
YY-MM-DD Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-19202: Error occurred in XML processing
ORA-01427: single-row subquery returns more than one row
ORA-06512: at "SYS.DBMS_XMLGEN", line 7
ORA-06512: at "SYS.DBMS_XMLGEN", line 147
ORA-06512: at "ARGUSOWNER01.GSS_CASE_DLP", line 1089
ORA-06512: at line 1
SQL: begin gss_CASE_dlp.P_CASE_LOAD(:PI_CASE_ID, :PI_ASSESSMENT, :PI_PARTIAL, :PI_1050, :PI_1051, :PO_CLOB, :PI_OPEN_READ_ONLY); end;
-------------------------------------------------------------------------
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 |