java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EIBUSCON.SYS_C0010517) violated

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EIBUSCON.SYS_C0010517) violated

book

Article ID: KB0084049

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect 6.X.X

Description

Following is the stack trace for the exception
========
2017 Jan 23 23:31:58:531 GMT -0500 BW.BusinessConnect-I9-E Error [bw.logger] BW-EXT-LOG-100000 java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EIBUSCON.SYS_C0010517) violated 

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) 
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) 
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) 
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) 
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) 
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) 
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) 
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) 
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) 
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) 
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) 
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875) 
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361) 
at com.tibco.ax.fw.db.DbAccess$1.update(DbAccess.java:258) 
at com.tibco.ax.fw.db.DbAccess$DBUpdater.execute(DbAccess.java:2267) 
at com.tibco.ax.fw.db.DbAccess.dispatchedLog(DbAccess.java:552) 
at com.tibco.ax.fw.db.DbAccess.Log(DbAccess.java:151) 
at com.tibco.ax.fw.db.AuditAccessImpl.auditLog(AuditAccessImpl.java:181) 
at com.tibco.ax.fw.db.AuditAccessImpl.createOrUpdateAuditLog(AuditAccessImpl.java:230) 
at com.tibco.ax.tibedi.runtime.pf.batch.AddTransaction.TxnAddedToBatchLog(AddTransaction.java:511) 
at com.tibco.ax.tibedi.runtime.pf.batch.AddTransaction.Start(AddTransaction.java:134) 
at com.tibco.ax.tibedi.runtime.pf.outbound.ConvertMsgInfo.addToSchdTask(ConvertMsgInfo.java:771) 
at com.tibco.ax.tibedi.runtime.pf.outbound.ConvertMsgInfo.PostProcess(ConvertMsgInfo.java:568) 
at com.tibco.ax.tibedi.runtime.pf.outbound.ConvertMsgInfo.run(ConvertMsgInfo.java:383) 
at com.tibco.ax.tibedi.runtime.pf.outbound.ConvertMsgInfo.Start(ConvertMsgInfo.java:115) 
at com.tibco.ax.tibedi.runtime.pf.outbound.PrepareOutbound.prepareMsg(PrepareOutbound.java:1063) 
at com.tibco.ax.tibedi.runtime.pf.outbound.PrepareOutbound.Start(PrepareOutbound.java:162) 
at com.tibco.ax.tibedi.runtime.pf.outbound.TransportCanonicalizer.sendThruNonGateway(TransportCanonicalizer.java:934) 
at com.tibco.ax.tibedi.runtime.pf.outbound.TransportCanonicalizer.Process(TransportCanonicalizer.java:905) 
at com.tibco.ax.tibedi.runtime.pf.outbound.TransportCanonicalizer.Initialize(TransportCanonicalizer.java:184) 
at com.tibco.ax.tibedi.runtime.pf.outbound.TransportCanonicalizer.Start(TransportCanonicalizer.java:83) 
at com.tibco.ax.tibedi.runtime.outbound.EDIOBBMHService.validateAndBuildMsgContext(EDIOBBMHService.java:1772) 
at com.tibco.ax.tibedi.runtime.outbound.EDIOBBMHService.preProcessMsg(EDIOBBMHService.java:173) 
at com.tibco.ax.fw.runtime.impl.AbstractService.preProcessor(AbstractService.java:291) 
at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:497) 
at com.tibco.plugin.gateway.InvokeOperationActivity.sInvokeServiceOp(InvokeOperationActivity.java:246) 
at com.tibco.plugin.gateway.InvokeOperationActivity$OperationThread.run(InvokeOperationActivity.java:376) 
at com.tibco.pe.util.ThreadPool$ThreadPoolThread.run(Unknown Source)
=========

Issue/Introduction

Why I am seeing java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EIBUSCON.SYS_C0010517) violated exception in BC log file

Environment

All

Resolution

This is a harmless exception that can happen when multiple engines try to insert first log of a batch,.  The failed engine will try to update the record rather than trying to insert. 

This exception will not impact any feature, and can be safely ignored.