Atomikos Forum

Hi I am using Atomikos3.4.
Application is working for all the times except for few instances where I get following kind of exception.

I do not have sys.dba_pending_transactions table in databases, but still it is working for most of the time.
Can anyone please help in identifying what the below error is?

Caused by: com.atomikos.datasource.ResourceException: resume for XID com.closepf.iprompt.global_transaction_manager0056400162com.closepf.iprompt.global_transaction_manager96741 raised -3: the XA resource detected an internal error
at com.atomikos.datasource.xa.XAResourceTransaction.resume(XAResourceTransaction.java:402)
at com.atomikos.datasource.xa.session.BranchEnlistedStateHandler.(BranchEnlistedStateHandler.java:60)
at com.atomikos.datasource.xa.session.NotInBranchStateHandler.checkEnlistBeforeUse(NotInBranchStateHandler.java:60)
at com.atomikos.datasource.xa.session.TransactionContext.checkEnlistBeforeUse(TransactionContext.java:88)
at com.atomikos.datasource.xa.session.SessionHandleState.notifyBeforeUse(SessionHandleState.java:179)
at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:197)
at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:132)
at $Proxy25.prepareStatement(Unknown Source)
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:168)
at $Proxy26.prepareStatement(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)

Hi,

Hard to say what this is without extra effort... A detailed analysis of the logs would be needed, so:

Please mail debug-level tm.out files to support at atomikos dot com. For timely resolution, I strongly advise getting a developer support ticket and mentioning the transaction ID in your email. Otherwise, we will only be able to look at the case as soon as we have some spare time.

Cheers

Hi,

Can you please email me cost of various support provided by Atomikos in UK?

Many Thanks,
Nimit