PQ48307: CLOSE XA CONNECTION THAT HAS AN ERROR

A fix is available
3.5.4-3.5.7, 4.0.2-4.0.7: Component cumulative Connection Manager fix

APAR

APAR status
Closed as program error.

Error description
The component will be jdbc.cm. When an XA connection
is marked bad, we will throw that connection away and open
  another one.
Suddenly all accesses to DB2
database start failing with "XAResource.....FAILED State"
There is no evidence of a previous failure starting this
condition.  In this case the last successful
application request was 4 seconds before the failures.
Resource Analyzer shows that there is only one connection
in the datasource.  The datasource is configured as a JTA
datasource because we need two phase commit.

When WebSphere tracing is started on the App Server
WebSphere background processes start displaying the same
error: IllegalResourceStateException.
Local fix
Problem summary
There was a problem with not closing JTA connections when there
was an error enlisting them in a transaction.  Unfortunately,
this left the bad connection in the connection pool.  Then, the
next application that tries to get a connection gets the bad
connection.
The cause of the error on enlist is not know, but it is assumed
it was something outside of the realm of connection pooling.
Problem conclusion
In the JTAConnectO.java class, a check is now made for an error
of type org.omg.CORBA.SystemException .  When this happens, the
code makes sure to destroy() the connection as it is probably
invalid.  This ensures the connection does not get returned to
the pool for something else to reuse.
Temporary fix
Comments
APAR information
APAR numberPQ48307
Reported component nameWAS ADVANCED AI
Reported component ID5648C8400
Reported release350
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Submitted date2001-04-30
Closed date2001-06-07
Last modified date2001-06-07

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:APAR is sysrouted FROM one or more of the following:


Modules/Macros
JDBC
APAR is sysrouted TO one or more of the following:Modules/Macros

Fix information
Fixed component nameWAS ADVANCED AI
Fixed component ID5648C8400

Applicable component levels
R350 PSYUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ48307
IBM Group: Software Group
Modified date: 2001-06-07