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 03, 2017

Applies to:

Oracle WebCenter Enterprise Capture - Version 11.1.1.8.0 and later
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)

 

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