Changing Event Symptoms/Diagnoses And Saving Case Causes Error: 500 - Internal server error (Doc ID 2275007.1)

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.

Symptoms

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:

500 - Internal Server Error
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

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms