(92618) Error Received when Generating Letters and Narratives in Argus
(Doc ID 3023565.1)
Last updated on MAY 22, 2024
Applies to:
Oracle Life Sciences Argus Safety - Version 8.2.3 and laterInformation in this document applies to any platform.
Symptoms
Users are reporting receiving the following errors when performing actions such as
- Generating Letters
- Generating Narratives
- Printing Medical Case Summary
Some Users are also reporting errors doing Case Action>Open and Utilities>Logs>View Error Log
Within the Argusvr2.log the following error is being written
Exception DetailsMessage
Error:1; Oracle error 1 occurred.
ORA-20001: Unable to add SQL and SQL bind xml into USER_CACHE database table.
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 209
ORA-06512: at line 1
SQL: BEGIN pkg_utl_sql.P_GET_RESULTS_FOR_VIEW(:PI_SQL, :PI_XMLTYPE_BIND, :PI_FIRST_ROW, :PI_LAST_ROW, :PI_USER_ID, :PI_USER_NAME, :PO_CACHE_ID, :PO_RESULT); END;
Stack Trace
Exception DetailsMessage
Error:1; Oracle error 1 occurred.
ORA-20001: Unable to add SQL and SQL bind xml into USER_CACHE database table.
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 209
ORA-06512: at line 1
SQL: BEGIN pkg_utl_sql.P_GET_RESULTS_FOR_VIEW(:PI_SQL, :PI_XMLTYPE_BIND, :PI_FIRST_ROW, :PI_LAST_ROW, :PI_USER_ID, :PI_USER_NAME, :PO_CACHE_ID, :PO_RESULT); END;
Stack Trace
And within the CMN_ERROR_LOG is written
Argus Safety.COM :- Oracle error 1 occurred.
ORA-20001: Unable to add SQL and SQL bind xml into USER_CACHE database table.
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 209
ORA-06512: at line 1
SQL: BEGIN pkg_utl_sql.P_GET_RESULTS_FOR_VIEW(:PI_SQL, :PI_XMLTYPE_BIND, :PI_FIRST_ROW, :PI_LAST_ROW, :PI_USER_ID, :PI_USER_NAME, :PO_CACHE_ID, :PO_RESULT); END;
PL/SQL Call Stack:
15300543207388985138
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
1 __anonymous_block
ORA-20001: Unable to add SQL and SQL bind xml into USER_CACHE database table.
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 209
ORA-06512: at line 1
SQL: BEGIN pkg_utl_sql.P_GET_RESULTS_FOR_VIEW(:PI_SQL, :PI_XMLTYPE_BIND, :PI_FIRST_ROW, :PI_LAST_ROW, :PI_USER_ID, :PI_USER_NAME, :PO_CACHE_ID, :PO_RESULT); END;
PL/SQL Call Stack:
15300543207388985138
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
1 __anonymous_block
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 |
Cause |
Solution |
References |