Changing Event Symptoms/Diagnoses And Saving Case Causes Error: 500 - Internal server error
Last updated on JUNE 08, 2017
Applies to:Oracle Argus Safety Cloud Service - Version 7.0 and later
Oracle Argus Safety - Version 7.0.0 and later
Information in this document applies to any platform.
After events are changed from "Diagnosis" to "Symptom", related to an existing "Diagnosis" and saved, these events cannot be deleted nor reverted back to "Diagnosis". The following error is thrown if the "Symptom" radio button is checked for the event and the case is saved:
There is a problem with the resource you are looking for, and it cannot be displayed.
Additional error messages seen include:
Error Message "Error No 301200101 Description: Please contact your system
administrator." appears upon saving the case.
CMN_ERROR_LOG table has following information.
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-01407: cannot update
("ARGUS_APP"."CASE_RELATIONSHIPS"."DIAGNOSIS") to NULL
ORA-06512: at "ARGUS_APP.GSS_CASE", line 3963
ORA-06512: at line 1
SQL: BEGIN GSS_CASE.P_CASE_RELATIONSHIPS_IU(:PI_CASE_ID, :PI_SEQ_NUM,
:PI_DIAGNOSIS, :PI_SYMPTOM); END
as well as:
Microsoft VBscript runtime error '800a01f4'
Variable is undefined 'CF_SetXMLAttribute'
/CaseForm/Event/CF_Event.asp line 1621
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms