0 Replies Latest reply on Dec 13, 2010 8:03 AM by rashidawan

    Unique Constraint Issue

    rashidawan
    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
      ))))

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

      ))))