Applications utilizing 1-phase commit data source throw errors when security is enabled
 Technote (troubleshooting)
 
Problem(Abstract)
If you are using WebSphere® Application Server V5.0.1, V5.0.2, or V5.0.2.1 and your application uses a 1-phase commit (1PC) data source, you might see the following error message when you enable security:

WTRN0062E: An illegal attempt to use multiple resources that have only one-phase capability has occurred within a global transaction.
 
Cause
When security is enabled, the connection to the datasource is not shared. For each query, a new 1PC resource is enlisted in the global transaction. This is illegal for 1PC resource and is the cause of the error.
[12/23/03 18:33:08:162 EST]   15ce7d LocalTransact > enlist
[12/23/03 18:33:08:162 EST]   15ce7d LocalTransact d enlisting LocalTranWrapper :58ba0e63 with coordinator :com.ibm.ejs.jts.jts.CoordinatorImpl@1210175097#tid=2
[12/23/03 18:33:08:162 EST]   15ce7d JTSXA         > enlistOnePhase: args:
                                 com.ibm.ejs.jts.jts.CoordinatorImpl@1210175097#tid=2
                                 com.ibm.ejs.j2c.LocalTransactionWrapper@58ba0e63
[12/23/03 18:33:08:163 EST]   15ce7d CoordinatorIm > get_jta_transaction()
[12/23/03 18:33:08:163 EST]   15ce7d CoordinatorIm < get_jta_transaction()
                                 com.ibm.ejs.jts.jta.TransactionImpl@2
[12/23/03 18:33:08:163 EST]   15ce7d TransactionIm > enlistResource: args:
                                 com.ibm.ejs.j2c.LocalTransactionWrapper@58ba0e63
                                 -1
[12/23/03 18:33:08:163 EST]   15ce7d CoordinatorIm > get_status
[12/23/03 18:33:08:163 EST]   15ce7d CoordinatorIm < get_status
                                 0
[12/23/03 18:33:08:163 EST]   15ce7d TransactionIm d getStatus: Status.StatusActive
[12/23/03 18:33:08:163 EST] 15ce7d TransactionIm e Illegal attempt to enlist more than one 1PC resource.
[12/23/03 18:33:08:163 EST] 15ce7d TransactionIm E WTRN0062E: An illegal attempt to use multiple resources that have only one-phase capability has occurred within a global transaction.
[12/23/03 18:33:08:196 EST] 15ce7d TransactionIm e resourceEnlistmentValid() - ENLISTMENT_INVALID
[12/23/03 18:33:08:196 EST] 15ce7d TransactionIm e Invalid resource enlistment. Throwing IllegalStateException.
[12/23/03 18:33:08:197 EST] 15ce7d TransactionIm < enlistResource
With security disabled, the connections are flagged as identical and equal; therefore, the resource connection handle is shared, eliminating the need to enlist another resource.
 
Resolving the problem
The problem is fixed with APAR PQ75055 which is included in WebSphere Application Server 5.0.2 Cumulative Fix 2. Upgrading to WebSphere Application Server 5.0.2 Cumulative Fix 2 or higher fixes the problem.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java Transaction Service (JTS)
Operating system(s): Windows
Software version: 5.0.2.1
Software edition:
Reference #: 1157731
IBM Group: Software Group
Modified date: Jan 14, 2004