My Oracle Support Banner

When the WebCenter Content: Imaging Input Agent is Processing a Document, Error "ORA-00001: unique constraint" Occurs (Doc ID 2082515.1)

Last updated on APRIL 17, 2024

Applies to:

Oracle WebCenter Content: Imaging - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

When the WebCenter Content: Imaging Input Agent is processing a document, the batch id is not created and the following errors occur:

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CIENA_IPM.SYS_C0011453) violated

Error Code: 1
Call: INSERT INTO BATCH (BATCHID, CREATEDBYPROCESS, CURRENTSTATE, ENDTIME, FAILEDDOCCOUNT, SOURCENAME, SOURCETIME, STARTTIME, SUCCESSFULDOCCOUNT, INPUT_ID, INPUT_NAME, APP_ID, APP_NAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [13 parameters bound]
Query: InsertObjectQuery(18:3:Invoices)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:840)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162)
at org.eclipse.persistence.internal.queries.StatementQueryMechan

2015-11-25T11:21:03.383-05:00] [IPM_server1] [ERROR] [TCM-00157] [oracle.imaging.agents] [tid: <TID>] [userId: <UID>] [ecid: <ECID>] [APP: imaging] An error occurred filing file /ipmdata/wcid/inputdata/InputAgent/Input/Invoices/Stage/Invoice_20150109100921_1.txt.InpSrvExt.1448467562904.[[
oracle.imaging.ImagingException: TCM-00777: A database error occurred.
stackTraceId: 7-1448468463369
faultType: DATABASE
faultDetails:

 

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


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