My Oracle Support Banner

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

Last updated on JUNE 09, 2020

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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.