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 APRIL 16, 2024

Applies to:

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


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( at oracle.odc.batchprocessor.BatchProcessorBean.processMessage( at oracle.odc.batchprocessor.CommitProcessorBean.onMessage(

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)





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

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