Atomikos Forum

Hi,
we are using atomikos 3.9.22 with spring, mybatis, hornetq and oracle 11g.

Facing the below issue sometimes. Its intermittent.

We are unable to understand the cause of the issue :

ERROR com.acn.hps.aops.cm.events.common.dao.impl.QuickLinkIntelligenceDAOImpl - executePLSQL() :: CallableStatementCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA]
    with heuristic messages:
    XA resource 'aopsXA' accessed with Xid '3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639'; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA]
    with heuristic messages:
    XA resource 'aopsXA' accessed with Xid '3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639'
org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA]
    with heuristic messages:
    XA resource 'aopsXA' accessed with Xid '3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639'; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA]
    with heuristic messages:


 com.atomikos.jdbc.AtomikosSQLException: Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA]
    with heuristic messages:
    XA resource 'aopsXA' accessed with Xid '3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639'
    at com.atomikos.jdbc.AtomikosSQLException.throwAtomikosSQLException(AtomikosSQLException.java:46)
    at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:237)
    at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:142)
    at com.sun.proxy.$Proxy45.prepareCall(Unknown Source)
    at com.acn.hps.aops.arch.services.AopsCallableStatementCreator.createCallableStatement(AopsCallableStatementCreator.java:101)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1014)
    ... 105 common frames omitted

Caused by: com.atomikos.datasource.xa.session.InvalidSessionHandleStateException: Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA]
    with heuristic messages:
    XA resource 'aopsXA' accessed with Xid '3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639'
    at com.atomikos.datasource.xa.session.BranchEnlistedStateHandler.<init>(BranchEnlistedStateHandler.java:74)
    at com.atomikos.datasource.xa.session.BranchSuspendedStateHandler.transactionResumed(BranchSuspendedStateHandler.java:81)
    at com.atomikos.datasource.xa.session.TransactionContext.transactionResumed(TransactionContext.java:124)
    at com.atomikos.datasource.xa.session.SessionHandleState.notifyBeforeUse(SessionHandleState.java:173)
    at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:227)
    ... 109 common frames omitted

Can anyone help us to know the reason why this kind of thing happens.

Why its failing while resuming the branch of the transaction.