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

Last updated on JUNE 02, 2017

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: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: a4649ec9d872ce6c:33375d5d:1513f599467:-8000-0000000000000053,0] [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:

 

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