My Oracle Support Banner

Getting "ORA-19202: Error occurred in XML processing" When Saving Data in Event Assessment Tab (Doc ID 2383520.1)

Last updated on APRIL 06, 2018

Applies to:

Oracle Argus Safety - Version 4.2.0 to 8.1.2 [Release 4.2.0 to 8.1]
Information in this document applies to any platform.

Symptoms

 Getting the following errors when attempting to update the as reported causality and as determined causality in event assessment tab and trying to save the case.

the following error occurs.
Upon saving the entered data is being disappeared

-- Error
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00222: error received from SAX callback function
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at "SYS.DBMS_XMLSTORE", line 78
ORA-06512: at "ARGUS_APP.GSS_CASE", line 2190
ORA-06512: at line 1

SQL: begin gss_case.p_case_cea_xml(:P_CASE_ID, :P_CEA_XML); end;

Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00222: error received from SAX callback function
ORA-12899: value too large for column "ARGUS_APP"."GTT_CASE_CEA"."ACJ" (actual: 1389, maximum: 1000)
ORA-06512: at "SYS.DBMS_XMLSTORE", line 78
ORA-06512: at "ARGUS_APP.GSS_CASE", line 2190
ORA-06512: at line 1

SQL: begin gss_case.p_case_cea_xml(:P_CASE_ID, :P_CEA_XML); end;

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

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