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 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)
.....
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 |