PQ72718: WTRN0063E RECEIVED WHEN BOTH 1PC AND 2PC RESOURCES IN GLOBAL TRANACTION BUT THE 2PC RESOURCE ONLY PERFORMING SELECT.

 A fix is available

5.0.2: WebSphere Application Server Version 5.0 Fix Pack 2 (Version 5.0.2)



APAR status
Closed as program error.

Error description
In two phase resource - after performing update
to a one phase resource (2-phase only performing select) is
failing with:

  TransactionIm E WTRN0063E: An illegal attempt to enlist a one
  phase capable resources has occurred.
The same code worked in 3.5 is failing in 5.0
Local fix Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server 5.0 users of    *
*                 Tx with mixed 1PC and 2PC resources.         *
****************************************************************
* PROBLEM DESCRIPTION: Enable use of 1PC Resource with 2PC     *
*                      Resources if 2PC are read only          *
****************************************************************
* RECOMMENDATION:                                              *
*                                                              *
****************************************************************
It is valid to enlist a one Phase Commit resource into a global
transaction with other 2 Phase Commit (XA) resources and to have
the 1PC resource successfully commit as long as all of the 2PC
resources are used as read only resources.

This Interim Fix corrects the situation where the enlistment of
the 1PC resource is rejected if 2PC resources are already in the
transaction.

A 1PC resource can now be enlisted with 2PC resources, if
however any 2PC resource is not used for read only the WTRN0063
message is given at transaction prepare time and the transaction
rolled back.

If update capability is required to both the 1PC and 2PC
resources then Last Participant Support of the WebSphere
Enterprise product should be used.
Problem conclusion
Moved 1PC/2PC check from enlistment to prepare and relaxed in
the case when 2PC resources are read-only.
Temporary fix
Interim Fix PQ72718 available.
Comments
APAR information
APAR number PQ72718
Reported component name WAS BASE 5.0
Reported component ID 5630A3600
Reported release 00S
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2003-04-01
Closed date 2003-05-15
Last modified date 2003-05-15

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
RESVEC TXIMPL        

Publications Referenced

Fix information

Applicable component levels
R003 PSY    UP
R00A PSY    UP
R00H PSY    UP
R00I PSY    UP
R00S PSY    UP
R00W PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 00S
Software edition:
Reference #: PQ72718
IBM Group: Software Group
Modified date: May 15, 2003