My Oracle Support Banner

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

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences 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

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.