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!

Unexpected exception while enlisting XAConnection java.sql.SQLException - B2B

Ch.BhargaviApr 20 2017 — edited Apr 21 2017

Hi,

I see below error in my logs, can anyone tell the reason behind this error.

During this time i don't see any SOA instances created.

<Apr 19, 2017, 7:24:35,35 PM EDT> <Error> <oracle.soa.b2b.engine> <BEA-000000> <Local Exception Stack:

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160526-8f41838): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 3603 seconds

BEA1-0016233CCBFFB2873AFC

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

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

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:591)

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

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

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

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:309)

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

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

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

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

at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)

at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2056)

at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)

at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)

at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)

at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)

at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:281)

at org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:197)

at org.eclipse.persistence.queries.DataReadQuery.executeDatabaseQuery(DataReadQuery.java:152)

at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)

at org.eclipse.persistence.queries.DataReadQuery.execute(DataReadQuery.java:137)

at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:3271)

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)

at org.eclipse.persistence.internal.sessions.AbstractSession.retryQuery(AbstractSession.java:1928)

at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.retryQuery(DatabaseSessionImpl.java:1018)

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1894)

at org.eclipse.persistence.internal.sessions.AbstractSession.retryQuery(AbstractSession.java:1928)

at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.retryQuery(DatabaseSessionImpl.java:1018)

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1894)

at org.eclipse.persistence.internal.sessions.AbstractSession.retryQuery(AbstractSession.java:1928)

at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.retryQuery(DatabaseSessionImpl.java:1018)

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1894)

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1790)

at org.eclipse.persistence.platform.database.oracle.Oracle9Platform.getTimestampFromServer(Oracle9Platform.java:544)

at oracle.tip.b2b.utility.Utility.getTimeStampFromServer(Utility.java:1706)

at oracle.tip.b2b.utility.Utility.updateServerTime(Utility.java:1717)

at oracle.tip.b2b.utility.Utility.getTimestamp(Utility.java:1688)

at oracle.tip.b2b.system.B2BContext.<init>(B2BContext.java:82)

at oracle.tip.b2b.msgproc.DbAccess.createB2BContext(DbAccess.java:7341)

at oracle.tip.b2b.transport.InterfaceSequencingHelper.run(InterfaceSequencingHelper.java:65)

at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:184)

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

at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)

at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)

at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)

at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)

at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)

at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:618)

at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:39)

Caused by: weblogic.transaction.TimedOutException: Transaction timed out after 3603 seconds

BEA1-0016233CCBFFB2873AFC

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

... 54 more

Error Code: 0

Call: SELECT SYSTIMESTAMP FROM DUAL

Query: ValueReadQuery(sql="SELECT SYSTIMESTAMP FROM DUAL")

at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:316)

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