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 laterInformation 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 |