Unique Constraint Issue

rashidawan Dec 13, 2010 8:03 AM

JBoss 3.2.7

Oracle 10g

JDBC2

3 separate JBoss Instances each using separate set of JMS tables

Occasionally we get following error for one of the instance of JBoss.

2010-11-26 10:04:58,276 ERROR TransactionRolledbackException in method: public abstract com.banctec.caseware.helpers.InformationHolder com.banctec.caseware.server.cpc.CPC.getBusinessFunctionForInstance(com.banctec.caseware.helpers.InformationHolder) throws com.banctec.caseware.exceptions.CaseWareException,java.rmi.RemoteException, causedBy:

org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=ba-efirst02//6058701, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.mq.SpyXAException: - nested throwable: (org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolled back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not store message: 886588 msg=295340 hard NOT_STORED PERSISTENT queue=TOPIC.AuditTopic.ID:2.-2147483648 priority=4 lateClone=false hashCode=1917777053; - nested throwable: (java.sql.SQLException: ORA-00001: unique constraint (EFP.SYS_C0090245) violated

))))

org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=hostname//6058701, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.mq.SpyXAException: - nested throwable: (org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolled back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not store message: 886588 msg=295340 hard NOT_STORED PERSISTENT queue=TOPIC.AuditTopic.ID:2.-2147483648 priority=4 lateClone=false hashCode=1917777053; - nested throwable: (java.sql.SQLException: ORA-00001: unique constraint (EFP.SYS_C0090245) violated

))))