org.apache.openjpa.util.StoreException: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed. The sequence table is typically created when you run the mappingtool's refresh action on any datastore identity class. If you have not run the mappingtool but want to create the sequence table, run: java org.apache.openjpa.jdbc.kernel.TableJDBCSeq -action add

Oracle Community | 647944 | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Using GenerationType.AUTO failes to create OPENJPA_SEQUENCE_TABLE

    Oracle Community | 8 years ago | 647944
    org.apache.openjpa.util.StoreException: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed. The sequence table is typically created when you run the mappingtool's refresh action on any datastore identity class. If you have not run the mappingtool but want to create the sequence table, run: java org.apache.openjpa.jdbc.kernel.TableJDBCSeq -action add
  2. 0

    Using GenerationType.AUTO failes to create OPENJPA_SEQUENCE_TABLE

    Oracle Community | 8 years ago | 647944
    org.apache.openjpa.util.StoreException: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed. The sequence table is typically created when you run the mappingtool's refresh action on any datastore identity class. If you have not run the mappingtool but want to create the sequence table, run: java org.apache.openjpa.jdbc.kernel.TableJDBCSeq -action add
  3. 0

    Using GenerationType.AUTO failes to create OPENJPA_SEQUENCE_TABLE

    Oracle Community | 8 years ago | 647944
    org.apache.openjpa.util.StoreException: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed. The sequence table is typically created when you run the mappingtool's refresh action on any datastore identity class. If you have not run the mappingtool but want to create the sequence table, run: java org.apache.openjpa.jdbc.kernel.TableJDBCSeq -action add
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    NEED URGENT HELP WITH ENTITY

    Oracle Community | 5 years ago | 929102
    org.apache.openjpa.util.StoreException: Attempt to update the sequence table "OPENJPA_SEQUENCE_TABLE" failed. The sequence table is typically created when you run the mappingtool's refresh action on any datastore identity class. If you have not run the mappingtool but want to create the sequence table, run: java org.apache.openjpa.jdbc.kernel.TableJDBCSeq -action add
  6. 0

    what actually cause UAC length is not zero?

    Oracle Community | 1 decade ago | 800332
    java.sql.SQLException: UAC length is not zero <Aug 17, 2006 11:03:18 AM SGT> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "LEAPUSER" failed with exception: "java.sql.SQLException: OALL8 is in an inconsistent state.".> <Aug 17, 2006 11:03:18 AM SGT> <Error> <JTA> <BEA-110412> <Name=[EJB com.wics.party.ejb.partyService.PartyServiceBean.findParty(com.ea.controller.EJBUserSession,com.wics.party.data.PartySearchCriteriaData)],Xid=BEA1-07AD4D81226816252955(8546999),Status=Committed,HeuristicErrorCode=XA_HEURHAZ,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=1,seconds left=120,activeThread=Thread[ExecuteThread: '10' for queue: 'weblogic.kernel.Default',5,Thread Group for Queue: 'weblogic.kernel.Default'],XAServerResourceInfo[weblogic.jdbc.wrapper.JTSXAResourceImpl]=(ServerResourceInfo[weblogic.jdbc.wrapper.JTSXAResourceImpl]=(state=committed,assigned=myserver),xar=weblogic.jdbc.wrapper.JTSXAResourceImpl@2c1fec,re-Registered = false),SCInfo[MOMUSIT7003Domain+myserver]=(state=committed),properties=({weblogic.transaction.name=[EJB com.wics.party.ejb.partyService.PartyServiceBean.findParty(com.ea.controller.EJBUserSession,com.wics.party.data.PartySearchCriteriaData)], weblogic.jdbc=t3://10.4.36.41:7003}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=myserver+10.4.36.41:7003+MOMUSIT7003Domain+t3+, XAResources={JMS_FileStore, weblogic.jdbc.wrapper.JTSXAResourceImpl},NonXAResources={})],CoordinatorURL=myserver+10.4.36.41:7003+MOMUSIT7003Domain+t3+) completed heuristically: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHazard, (javax.transaction.xa.XAException: Protocol violation)) > <Aug 17, 2006 11:03:18 AM SGT> <Error> <EJB> <BEA-010026> <Exception occurred during commit of transaction Name=[EJB com.wics.party.ejb.partyService.PartyServiceBean.findParty(com.ea.controller.EJBUserSession,com.wics.party.data.PartySearchCriteriaData)],Xid=BEA1-07AD4D81226816252955(8546999),Status=Committed,HeuristicErrorCode=XA_HEURHAZ,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=1,seconds left=120,XAServerResourceInfo[weblogic.jdbc.wrapper.JTSXAResourceImpl]=(ServerResourceInfo[weblogic.jdbc.wrapper.JTSXAResourceImpl]=(state=committed,assigned=myserver),xar=weblogic.jdbc.wrapper.JTSXAResourceImpl@2c1fec,re-Registered = false),SCInfo[MOMUSIT7003Domain+myserver]=(state=committed),properties=({weblogic.transaction.name=[EJB com.wics.party.ejb.partyService.PartyServiceBean.findParty(com.ea.controller.EJBUserSession,com.wics.party.data.PartySearchCriteriaData)], weblogic.jdbc=t3://10.4.36.41:7003}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=myserver+10.4.36.41:7003+MOMUSIT7003Domain+t3+, XAResources={JMS_FileStore, weblogic.jdbc.wrapper.JTSXAResourceImpl},NonXAResources={})],CoordinatorURL=myserver+10.4.36.41:7003+MOMUSIT7003Domain+t3+): javax.transaction.HeuristicMixedException: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHazard, (javax.transaction.xa.XAException: Protocol violation))

    Root Cause Analysis

    1. java.sql.SQLException

      There is no row for mapping "com.thunderhead.backend.entities.JobMessage" in sequence table "OPENJPA_SEQUENCE_TABLE", and the attempt to insert a row has apparently failed.

      at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence()
    2. OpenJPA Aggregate Jar
      JDBCStoreManager.assignObjectId
      1. org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:395)
      2. org.apache.openjpa.jdbc.sql.SQLExceptions.narrow(SQLExceptions.java:146)
      3. org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4150)
      4. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
      5. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:80)
      6. org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:401)
      7. org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:266)
      8. org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60)
      9. org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160)
      10. org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144)
      11. org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:592)
      12. org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:464)
      13. org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:440)
      14. org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:576)
      14 frames
    3. kodo.jdbc.kernel
      KodoJDBCStoreManager.assignObjectId
      1. kodo.jdbc.kernel.KodoJDBCStoreManager.assignObjectId(KodoJDBCStoreManager.java:33)
      1 frame
    4. OpenJPA Aggregate Jar
      BrokerImpl.beforeCompletion
      1. org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:134)
      2. org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:134)
      3. org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:517)
      4. org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:2814)
      5. org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:39)
      6. org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:957)
      7. org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1945)
      8. org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1905)
      9. org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1823)
      9 frames
    5. weblogic.transaction.internal
      ServerTransactionImpl.internalCommit
      1. weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1217)
      2. weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1195)
      3. weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:118)
      4. weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1302)
      5. weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2114)
      6. weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:263)
      6 frames