Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMFAIL start() failed on resource

Priyanka NegiJul 31 2017 — edited Feb 26 2020

We have a composite where DB Adapter is used to insert data into a table . The service works fine most of the times , but we have been getting the below error while inserting the data. Can't figure out if this is a database related issue or any configuration of the datasource needs to be changed.

Exception occurred when binding was invoked.

Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.

insert failed. Descriptor name: [ABC_Database].

Caused by java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMFAIL start() failed on resource 'GDSDataSource_soa_domain': XAER_RMFAIL : Resource manager is unavailable

javax.transaction.xa.XAException: Internal error: XAResource 'ABCDataSource_soa_domain' is unavailable

at weblogic.transaction.internal.XAResourceDescriptor.checkResource(XAResourceDescriptor.java:1302)

at weblogic.transaction.internal.XAResourceDescriptor.startResourceUse(XAResourceDescriptor.java:718)

at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1310)

at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1244)

at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:292)

at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:585)

at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:490)

at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1749)

at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1651)

at weblogic.jdbc.jta.DataSource.getConnectionInternal(DataSource.java:517)

at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:494)

at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:565)

at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:545)

at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:538)

at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:123)

at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)

at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)

at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:307)

at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)

at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1625)

at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)

at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:613)

at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatch(ParameterizedSQLBatchWritingMechanism.java:149)

at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:134)

at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.writesCompleted(DatabaseAccessor.java:1836)

at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.commitTransaction(DatabaseAccessor.java:426)

at org.eclipse.persistence.internal.sessions.AbstractSession.basicCommitTransaction(AbstractSession.java:761)

at org.eclipse.persistence.sessions.server.ClientSession.basicCommitTransaction(ClientSession.java:174)

at org.eclipse.persistence.internal.sessions.AbstractSession.commitTransaction(AbstractSession.java:965)

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransaction(UnitOfWorkImpl.java:1600)

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1461)

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1531)

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitRootUnitOfWork(UnitOfWorkImpl.java:1351)

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commit(UnitOfWorkImpl.java:1113)

at oracle.tip.adapter.db.transaction.DBTransaction.commit(DBTransaction.java:200)

at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:444)

at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeJcaReference(JCAInteractionInvoker.java:728)

at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeAsyncJcaReference(JCAInteractionInvoker.java:693)

at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAEndpointInteraction.performAsynchronousInteraction(JCAEndpointInteraction.java:628)

at oracle.integration.platform.blocks.adapter.AdapterReference.post(AdapterReference.java:325)

at oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:144)

at oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:233)

at oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:418)

at sun.reflect.GeneratedMethodAccessor1705.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:71)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

at com.sun.proxy.$Proxy406.post(Unknown Source)

at oracle.fabric.CubeServiceEngine.postToMesh(CubeServiceEngine.java:991)

at com.collaxa.cube.ws.WSInvocationManager.invoke0(WSInvocationManager.java:228)

at com.collaxa.cube.ws.WSInvocationManager.invoke(WSInvocationManager.java:301)

at com.collaxa.cube.engine.ext.common.InvokeHandler.__invoke(InvokeHandler.java:1347)

at com.collaxa.cube.engine.ext.common.InvokeHandler.handleNormalInvoke(InvokeHandler.java:687)

at com.collaxa.cube.engine.ext.common.InvokeHandler.handle(InvokeHandler.java:148)

at com.collaxa.cube.engine.ext.bpel.common.wmp.BPELInvokeWMP.__executeStatements(BPELInvokeWMP.java:74)

at com.collaxa.cube.engine.ext.bpel.common.wmp.BaseBPELActivityWMP.perform(BaseBPELActivityWMP.java:188)

at com.collaxa.cube.engine.CubeEngine.performActivity(CubeEngine.java:2924)

at com.collaxa.cube.engine.CubeEngine._handleWorkItem(CubeEngine.java:1267)

at com.collaxa.cube.engine.CubeEngine.handleWorkItem(CubeEngine.java:1162)

at com.collaxa.cube.engine.dispatch.message.instance.PerformMessageHandler.handleLocal(PerformMessageHandler.java:106)

at com.collaxa.cube.engine.dispatch.DispatchHelper.handleLocalMessage(DispatchHelper.java:308)

at com.collaxa.cube.engine.dispatch.DispatchHelper.sendMemory(DispatchHelper.java:387)

at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4955)

at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4879)

at com.collaxa.cube.engine.CubeEngine._createAndInvoke(CubeEngine.java:756)

at com.collaxa.cube.engine.CubeEngine.createAndInvoke(CubeEngine.java:591)

at com.collaxa.cube.engine.delivery.DeliveryService.handleInvoke(DeliveryService.java:638)

at com.collaxa.cube.engine.ejb.impl.CubeDeliveryBean.handleInvoke(CubeDeliveryBean.java:343)

at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.__WL_invoke(Unknown Source)

at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:33)

at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.handleInvoke(Unknown Source)

at com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessageHandler.handle(InvokeInstanceMessageHandler.java:57)

at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:153)

at com.collaxa.cube.engine.dispatch.BaseDispatchTask.process(BaseDispatchTask.java:132)

at com.collaxa.cube.engine.dispatch.BaseDispatchTask.run(BaseDispatchTask.java:90)

at com.collaxa.cube.engine.dispatch.WMExecutor$W.run(WMExecutor.java:239)

at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1754)