General Error While Creating E2B Report (402000609) Due to PATIENTMEDICALCOMMENT Length (Doc ID 979357.1)

Last updated on MAY 06, 2015

Applies to:

Oracle Argus Interchange - Version 5.0.0 to 5.0.2 [Release 5.0.0]
Information in this document applies to any platform.
***Reviewed for currency: 09-JUN-2013***
***Reviewed for Currency: 05-May-2015***

Symptoms

Generic E2B generation error observed by users when generating an E2B report:

General error while creating E2b report (402000609)


Below is the associated error logged in the ESM schema in the ERROR_LOG table:

The SGML could not be generated for parent element: MEDICALHISTORYEPISODE and child element: PATIENTEPISODENAMEMEDDRAVERSION. The following error occurred: ORA-12899: value too large for column "ARGUS_ESM"."MEDICALHISTORYEPISODE"."PATIENTMEDICALCOMMENT" (actual: 103, maximum: 100)
ORA-06512: at "ARGUS_ESM.ESM_PKG", line 4226
ORA-01722: invalid number. Stored Procedure: GET_LEVEL3_SGML

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