XA Transaction Error "Oracle Error code is : 17002" on Websphere Talking to 10g Database Through JDBC Driver 10g (Doc ID 444365.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Oct-2012***

Symptoms

When attempting to run XA JDBC program on Websphere, the following runtime error occurs:

13544 [5/18/07 10:29:24:538 MST] 00000084 WSRdbXaResour E DSRA0304E: XAException occurred.
XAException contents and details are:
13545 The XA Error is : -7
13546 The XA Error message is : Resource manager is unavailable.
13547 The Oracle Error code is : 17002
13548 The Oracle Error message is: Internal XA Error
13549 The cause is : null.
13550 [5/18/07 10:29:24:538 MST] 00000084 WSRdbXaResour E DSRA0302E: XAException occurred.
                                          Error code is: XAER_RMFAIL (-7). Exception is: <null>
13551 [5/18/07 10:29:24:538 MST] 00000084 WSRdbXaResour 3 XAER_RMFAIL connection error occurred
13552 [5/18/07 10:29:24:538 MST] 00000084 WSRdbXaResour 3 process connection error occurred
                                          event for XAResource com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@43e4a31d
13553 [5/18/07 10:29:24:538 MST] 00000084 WSJdbcConnect > close Entry
13554 com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@5f13637b
13555 [5/18/07 10:29:24:538 MST] 00000084 WSJdbcConnect 1 state --> CLOSED
13556 [5/18/07 10:29:24:538 MST] 00000084 GenericDataSt 3 doConnectionCleanupPerCloseConnection is not implemented
13557 oracle.jdbc.driver.LogicalConnection@5c86a30b
13558 false
13559 <null>
13560 [5/18/07 10:29:24:538 MST] 00000084 WSJdbcConnect 3 doConnectionCleanupPerCloseConnection on [helper, mc, sqlCon, returned value]
13561 com.ibm.websphere.rsadapter.Oracle10gDataStoreHelper@5c142319
13562 WSRdbManagedConnectionImpl@3778a30b
13563 oracle.jdbc.driver.LogicalConnection@5c86a30b
13564 false
13565 [5/18/07 10:29:24:538 MST] 00000084 WSJdbcConnect < close Exit
13566 [5/18/07 10:29:24:538 MST] 00000084 WSRdbManagedC 1 Firing CONNECTION_ERROR_OCCURRED event for handle: null
13567 WSRdbManagedConnectionImpl@3778a30b
13568 [5/18/07 10:29:24:538 MST] 00000084 ConnectionEve > connectionErrorOccurred Entry
13569 [5/18/07 10:29:24:538 MST] 00000084 WSRdbXaResour 1 Handle CLOSED or INACTIVE. Not sending CONNECTION_ERROR_OCCURRED. (caller, mc)
13570 com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@43e4a31d
13571 WSRdbManagedConnectionImpl@3778a30b
13572 [5/18/07 10:29:24:538 MST] 00000084 WSRdbXaResour < start Exit
13573 Exception
13574 [5/18/07 10:29:24:538 MST] 00000084 XATransaction 3 processXAException: detecting bad XAException error code. Marking MCWrapper stale.
13575 [5/18/07 10:29:24:538 MST] 00000084 MCWrapper 3 TransactionError occurred on
                                          MCWrapper:MCWrapper id 5086630b Managed connection WSRdbManagedConnectionImpl@3778a30b
                                          State:STATE_TRAN_WRAPPER_INUSE Thread Id: 541ea332 Thread Name: WebContainer : 1 Handle count 1
13576
13577 [5/18/07 10:29:24:538 MST] 00000084 XATransaction 3 processXAException: Non-zero return code from XAResource. Return code is:
13578 XAER_RMFAIL
13579 [5/18/07 10:29:24:553 MST] 00000084 WSRdbManagedC > introspectSelf Entry
13580 WSRdbManagedConnectionImpl@3778a30b
13581 [5/18/07 10:29:24:553 MST] 00000084 InternalOracl 3 getHoldability
13582 oracle.jdbc.driver.LogicalConnection@5c86a30b
13583 [5/18/07 10:29:24:569 MST] 00000084 WSRdbManagedC < introspectSelf Exit
13584 [5/18/07 10:29:24:600 MST] 00000084 XATransaction E J2CA0027E: An exception occurred while invoking start on an XA Resource Adapter 
                                          from dataSource jdbc/customizationusr, within transaction ID {XidImpl: formatId(57415344), 
                                          gtrid_length(36), bqual_length(54),
                                          data(00000112a03c4ce200000001000004482a7e9b420f88294d3c6aed9c1d2fa1c08dd309bf00000112a03c4ce20000000
                                          1000004482a7e9b420f88294d3c6aed9c1d2fa1c08dd309bf000000010000000000000000000000000001)}:
                                          oracle.jdbc.xa.OracleXAException
13585 at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java(Compiled Code))
13586 at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:244)
13587 at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1322)
13588 at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1289)
13589 at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:144)
13590 at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1201)

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