ORACLE.AS.J2EE.TRANSACTION.TPC.STORE$STOREEXCEPTION when enabling XA with Oracle Apps/AQ Adapter (Doc ID 973014.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle(R) BPEL Process Manager 10g - Version 10.1.3.4 and later
Information in this document applies to any platform.
***Checked for relevance on 08-03-2012***


Symptoms

When setting up the SOA system for XA following this document: 

Oracle SOA Suite 10g XA and
RAC Database Configuration Guide
An Oracle White Paper
May 2009
Oracle SOA Suite XA and RAC Database Configuration Guide (PDF)
You setup a BPEL project that uses the Oracle Apps or AQ Adapter with the intention of making the adapter XA capable.  When starting the system get an error as follows:

<2009-11-10 11:26:34,761> <ERROR> <default.collaxa.cube.activation> <AQ Adapter::Inbound> AQDequeuer_Error in afterDelivery
<2009-11-10 11:26:34,764> <ERROR> <default.collaxa.cube.activation> <AQ Adapter::Inbound>
javax.resource.ResourceException: javax.transaction.RollbackException
at oracle.tip.adapter.fw.jca.messageinflow.MessageEndpointImpl.afterDelivery(MessageEndpointImpl.java:251)
at oracle.tip.adapter.aq.inbound.AQActivationSpecDequeuer.afterDelivery(AQActivationSpecDequeuer.java:563)
at oracle.tip.adapter.aq.inbound.AQActivationSpecDequeuer.run(AQActivationSpecDequeuer.java:288)
at oracle.tip.adapter.fw.jca.work.WorkerJob.go(WorkerJob.java:51)
at oracle.tip.adapter.fw.common.ThreadPool.run(ThreadPool.java:280)
at java.lang.Thread.run(Thread.java:595)
Caused by: javax.transaction.RollbackException
at com.evermind.server.ApplicationServerTransaction.handleCommitSystemException(ApplicationServerTransaction.java:874)
at com.evermind.server.ApplicationServerTransaction.twoPhaseCommit(ApplicationServerTransaction.java:813)
at com.evermind.server.ApplicationServerTransaction.commitBasedOnResourceCount(ApplicationServerTransaction.java:640)
at com.evermind.server.ApplicationServerTransaction.doCommit(ApplicationServerTransaction.java:279)
at com.evermind.server.ApplicationServerTransaction.commit(ApplicationServerTransaction.java:162)
at com.evermind.server.ApplicationServerTransactionManager.commit(ApplicationServerTransactionManager.java:472)
at oracle.tip.adapter.fw.jca.messageinflow.MessageEndpointImpl.afterDelivery(MessageEndpointImpl.java:228)
... 5 more
Caused by: javax.transaction.SystemException: Store exception
at oracle.as.j2ee.transaction.tpc.Coordinator.doPrepare(Coordinator.java:236)
at oracle.as.j2ee.transaction.tpc.Coordinator.doResolve(Coordinator.java:314)
at oracle.as.j2ee.transaction.tpc.Coordinator.resolve(Coordinator.java:104)
at oracle.as.j2ee.transaction.tpc.TwoPhaseCommitEngine.commit(TwoPhaseCommitEngine.java:111)
at com.evermind.server.ApplicationServerTransaction.twoPhaseCommit(ApplicationServerTransaction.java:811)
... 10 more
Caused by: oracle.as.j2ee.transaction.tpc.Store$StoreException: No RMId provided for [oracle.tip.adapter.aq.AQXAResource@2e157d, Xid( Global Id 37.9b.bb.88.ff.ff.ff.a7.e8.d5.dd.24.01.00.00.04.01.00.00.00.00.00.00, Format Id 1330790740, Branch Id 76.c6.63.43.00.00.00.00.00.00.00.00.00.00.00.00), null, state={AVE}, exception error code=])

at oracle.as.j2ee.transaction.tpc.Store.validateRMId(Store.java:48)
at oracle.as.j2ee.transaction.tpc.Store.noteResources(Store.java:96)
at oracle.as.j2ee.transaction.tpc.PresumedAbortStrategy.creationEvent(PresumedAbortStrategy.java:49)
at oracle.as.j2ee.transaction.tpc.Coordinator.initializeGlobalTransaction(Coordinator.java:370)
at oracle.as.j2ee.transaction.tpc.Coordinator.doPrepare(Coordinator.java:226)
... 14 more

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms