INSERT INTO AUDIT_TRAIL Fails with ' java.sql.SQLIntegrityConstraintViolationException: ORA-00001' (Doc ID 1338478.1)

Last updated on DECEMBER 14, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.4.0 to 11.1.1.5.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

SOA composites fail intermittently with the following exception stack in the SOA log,

<soa_domain>/servers/<soa_server>/logs/<soa_server>*.log

Failed to handle dispatch message ... exception ORABPEL-05002
....

####<Jul 13, 2011 2:21:04 PM EEST> <Error> <EJB> <host> <soa-host-7003> <orabpel.engine.pool-5.thread-23> <> <>
<c4525ee3259aebb5:71e731c7:13122fd9f14:-8000-0000000000005918> <1310556064257> <BEA-010026>
<Exception occurred during commit of transaction Name=[EJB com.collaxa.cube.engine.ejb.impl.bpel.BPELAuditTrailBean.storeLastAuditBatch
(com.collaxa.cube.engine.audit.BatchEvent,com.collaxa.cube.persistence.dto.AuditCounter)],Xid=BEA1-524AFA7B7ACC2587EC33(-627412724),Status=Rolled back.
[Reason=Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SOA_SOAINFRA.AT_PK) violated

Error Code: 1
Call: INSERT INTO AUDIT_DETAILS (CIKEY, DETAIL_ID, BIN_CSIZE, DOC_REF, CI_PARTITION_DATE, BIN, BIN_USIZE) VALUES (?, ?, ?, ?, ?, ?, ?)
bind => [80026, 4, 0, 2CD24760AD4211E0BFDB77D5259BE813, 2011-07-13 14:19:49.342, null, 0]
Query: InsertObjectQuery(com.collaxa.cube.persistence.dto.AuditDetails@da9af7d6)],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,
seconds left=60,XAServerResourceInfo[SOADataSource_soa_domain]=(ServerResourceInfo[SOADataSource_soa_domain]=(state=rolledback,assigned=soa-resbapp3-7003),
ar=SOADataSource,re-Registered = false),SCInfo[soa_domain+soa-resbapp3-7003]=(state=rolledback),properties=({weblogic.transaction.name=[EJB com.collaxa.cube.engine.ejb.impl.bpel.BPELAuditTrailBean.storeLastAuditBatch(com.collaxa.cube.engine.audit.BatchEvent,com.collaxa.cube.persistence.dto.AuditCounter)]}),
local properties=({weblogic.jdbc.jta.SOADataSource=[ No XAConnection is attached to this TxInfo ]}),
OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=soa-resbapp3-7003+resbapp3:7003+soa_domain+t3+,
XAResources={eis/tibjms/Queue, eis/activemq/Queue, WSATGatewayRM_soa-resbapp3-7003_soa_domain, WLStore_soa_domain_UMSJMS17003, eis/tibjmsDirect/Queue,
eis/jbossmq/Queue, CustomSOADataSource_soa_domain, eis/aqjms/Topic, SOADataSource_soa_domain, eis/webspheremq/Queue, eis/AQ/aqSample,
XDSLBasvuruDataSource_soa_domain, WLStore_soa_domain_SOAJMS17003, eis/aqjms/Queue, eis/sunmq/Queue, PRES_JMS_soa_domain, WLStore_soa_domain__WLS_soa-resbapp3-7003,
WLStore_soa_domain_BPMJMS17003, eis/tibjms/Topic, eis/fioranomq/Topic, eis/Apps/Apps, eis/wls/Queue, eis/aqjms/TTNETFaultCF, eis/tibjmsDirect/Topic,
eis/wls/Topic, eis/pramati/Queue, EDNDataSource_soa_domain},NonXAResources={})],CoordinatorURL=soa-resbapp3-7003+resbapp3:7003+soa_domain+t3+):
weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@da9aeab3

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SOA_SOAINFRA.AT_PK) violated

Error Code: 1
Call: INSERT INTO AUDIT_DETAILS (CIKEY, DETAIL_ID, BIN_CSIZE, DOC_REF, CI_PARTITION_DATE, BIN, BIN_USIZE) VALUES (?, ?, ?, ?, ?, ?, ?)
bind => [80026, 4, 0, 2CD24760AD4211E0BFDB77D5259BE813, 2011-07-13 14:19:49.342, null, 0]
Query: InsertObjectQuery(com.collaxa.cube.persistence.dto.AuditDetails@da9af7d6)
at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:1881)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:345)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:239)
at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:623)
at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:455)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:52)
at com.collaxa.cube.engine.ejb.impl.bpel.BPELAuditTrailBean_imuwv4_IAuditTrailLocalBeanImpl.storeLastAuditBatch(Unknown Source)
at com.collaxa.cube.engine.audit.AuditService.storeLastBatchEvent(AuditService.java:94)
at com.collaxa.cube.engine.dispatch.TransactionSynchronization.updateAuditData(TransactionSynchronization.java:251)
at com.collaxa.cube.engine.dispatch.TransactionSynchronization.afterCompletion(TransactionSynchronization.java:72)
at weblogic.transaction.internal.ServerSCInfo.callAfterCompletions(ServerSCInfo.java:998)
at weblogic.transaction.internal.ServerTransactionImpl.callAfterCompletions(ServerTransactionImpl.java:3025)
at weblogic.transaction.internal.ServerTransactionImpl.afterRolledBackStateHousekeeping(ServerTransactionImpl.java:2907)
at weblogic.transaction.internal.ServerTransactionImpl.setRolledBack(ServerTransactionImpl.java:2883)
at weblogic.transaction.internal.ServerTransactionImpl.globalRetryRollback(ServerTransactionImpl.java:3122)
at weblogic.transaction.internal.ServerTransactionImpl.globalRollback(ServerTransactionImpl.java:2873)
at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:409)
at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:388)
at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:572)
at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:455)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:52)
at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.handleCallback(Unknown Source)
at com.collaxa.cube.engine.dispatch.message.instance.CallbackDeliveryMessageHandler.handle(CallbackDeliveryMessageHandler.java:47)
at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:140)
at com.collaxa.cube.engine.dispatch.BaseDispatchTask.process(BaseDispatchTask.java:88)
at com.collaxa.cube.engine.dispatch.BaseDispatchTask.run(BaseDispatchTask.java:65)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:909)
at java.lang.Thread.run(Thread.java:662)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SOA_SOAINFRA.AT_PK) violated

 

The same error can be seen for the constraint 'SOAINFRA.AD_PK' as well.

 

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