oracle.AQ.AQOracleSQLException: Not in a transaction

Oracle Community | 3004 | 2 decades ago
  1. 0

    ORA-17063

    Oracle Community | 2 decades ago | 3004
    oracle.AQ.AQOracleSQLException: Not in a transaction
  2. 0

    AQOracleSQLException:Not in a transaction

    Oracle Community | 2 decades ago | 3004
    oracle.AQ.AQOracleSQLException: Not in a transaction
  3. 0

    Upgrade to RAC, now AQ is broken.

    Oracle Community | 8 years ago | 510188
    oracle.AQ.AQOracleSQLException: ORA-21779: duration not active ORA-21779: duration not active ORA-06512: at "SYS.DBMS_AQIN", line 571 ORA-06512: at line 1at oracle.AQ.AQOracleQueue.dequeue(AQOracleQueue.java:1795)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    known issues for WLS 8.1 SP4 and Oracle 10.2.0.... | Oracle Community

    oracle.com | 1 year ago
    oracle.AQ.AQOracleSQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 52 seconds Xid=BEA1-104364F28A3455331FEE(20681893),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=52,seconds left=50,activeThread=Thread[ExecuteThread: '11' for queue: 'weblogic.kernel.Default',5,Thread Group for Queue: 'weblogic.kernel.Default'],XAServerResourceInfo[S4N_XA_Pool]=(ServerResourceInfo[S4N_XA_Pool]=(state=started,assigned=none),xar=S4N_XA_Pool,re-Registered = false),SCInfo[io+sfnserver]=(state=active),local properties=({weblogic.jdbc.jta.S4N_XA_Pool=weblogic.jdbc.wrapper.TxInfo@9be15f}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=sfnserver+22.42.151.75:7011+io+t3+, XAResources={},NonXAResources={})],CoordinatorURL=sfnserver+22.42.151.75:7011+io+t3+)
  6. 0

    known issues for WLS 8.1 SP4 and Oracle 10.2.0.3.0.?

    Oracle Community | 9 years ago | 666705
    oracle.AQ.AQOracleSQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 52 seconds Xid=BEA1-104364F28A3455331FEE(20681893),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=52,seconds left=50,activeThread=Thread[ExecuteThread: '11' for queue: 'weblogic.kernel.Default',5,Thread Group for Queue: 'weblogic.kernel.Default'],XAServerResourceInfo[S4N_XA_Pool]=(ServerResourceInfo[S4N_XA_Pool]=(state=started,assigned=none),xar=S4N_XA_Pool,re-Registered = false),SCInfo[io+sfnserver]=(state=active),local properties=({weblogic.jdbc.jta.S4N_XA_Pool=weblogic.jdbc.wrapper.TxInfo@9be15f}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=sfnserver+22.42.151.75:7011+io+t3+, XAResources={},NonXAResources={})],CoordinatorURL=sfnserver+22.42.151.75:7011+io+t3+)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.AQ.AQOracleSQLException

      Not in a transaction

      at oracle.AQ.AQOracleSession.getQueueTable()
    2. oracle.AQ
      AQOracleSession.getQueueTable
      1. oracle.AQ.AQOracleSession.getQueueTable(AQOracleSession.java:354)
      1 frame
    3. AQServerReceive
      AQServerReceiveBean.waitForMessage
      1. AQServerReceive.AQServerReceiveBean.waitForMessage(AQServerReceiveBean.java:73)
      1 frame