My Oracle Support Banner

Document Error Information not Available in dc-client if Commit Exception Text is Greater than 255 Characters (Doc ID 2066380.1)

Last updated on JULY 13, 2020

Applies to:

Oracle WebCenter Enterprise Capture - Version 11.1.1.8.0 to 11.1.1.9.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

If a batch is released to Commit Processor and there is an error where the error description is more than the column length of the ECDOCUMENTCOMMITRESULTS table's ECMESSAGE column (default 255 characters), then the error description cannot be viewed in the dc-client page when attempting to review the batch errors.  In the commit process to WebCenter Content, the following CommitException occurs when several required fields do not have values:

oracle.odc.exception.CommitException: The following required fields do not have values: [CR_Producto, CR_Proceso, CR_SubClasificacion_Proceso, Region, Tipo_Persona, Tipo_Identificacion, Numero_Identificacion, Id_Producto, Tipo_Documental, SubTipo_Documental, Documento_Comun, CR_Cuenta_Seguridad, CR_Seccion_Expediente, Fecha_Emision] at oracle.odc.commitprocessor.CommitProcessor.processBatch(CommitProcessor.java:309) at oracle.odc.batchprocessor.BatchProcessorBean.processMessage(BatchProcessorBean.java:135) at oracle.odc.batchprocessor.CommitProcessorBean.onMessage(CommitProcessorBean.java:58)
.....

Message
javax.ejb.TransactionRolledbackLocalException: Error committing transaction:; nested exception is: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException

Supplemental Detail
Internal Exception: java.sql.SQLException: ORA-12899: value too large for column "TBNS3OCAP_CAPTURE"."ECDOCUMENTCOMMITRESULTS"."ECMESSAGE" (actual: 296, maximum: 255) Error Code: 12899 Call: INSERT INTO ECDOCUMENTCOMMITRESULTS (ECRESULTID, ECATTEMPTS, ECCOMMITPROFILENAME, ECMESSAGE, ECRESULT, ECCOMMITPROFILEID, ECDOCUMENTID) VALUES (?, ?, ?, ?, ?, ?, ?) bind => [7 parameters bound] Query: InsertObjectQuery(oracle.odc.entity.DocumentCommitResultEntity@50f30cf6)

 

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
References


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