XARecoveryDat W WTRN0005W messages after making datasource configuration changes
 Technote (troubleshooting)
 
Problem(Abstract)
When IBM® WebSphere® Application Server restarts, it processes in-doubt transactions from the tranlog and partnerlog files it keeps. An in-doubt transaction is an XA transaction whose database updates have not been either rolled back or committed. When the Application Server restarts, it attempts to complete these transactions.

If you make a datasource configuration change to change the userid or password and then stop and restart the Application Server, it is possible for the following errors to be logged if you do not stop the Application Server using a proper stop command:

[2005-04-12 15:00:35:828 CEST] 4c14e6b4 XARecoveryDat W WTRN0005W: The XAResource for a transaction participant could not be recreated and transaction recovery may not be able to complete properly. The resource was J2CXAResourceInfo :
cfName =ABC

The exception stack trace follows:

com.ibm.ws.Transaction.XAResourceNotAvailableException: Error creating XAResource: java.lang.Exception: Failed security check. Client is not permitted to create connection factory jdbc/ABCD.
at com.ibm.ejs.j2c.J2CXAResourceFactory.getXAResource(J2CXAResourceFactory.java:134)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:660)
at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1377)
at com.ibm.ws.Transaction.JTA.ResyncThread.run(RecoveryManager.java:1448)
 
Cause
If the operating system was taken down after changing the database connection ID and password, then it is possible that there are in-doubt transactions (unresolved transactions) in the tranlog and partnerlog files. When the Application Server attempts to recover the in-doubt transactions upon being restarted, it uses the original ID and password that it stored in the tranlog and partnerlog. The exceptions above result.
 
Resolving the problem
Change the password and connectorID back to the previous values and recover the in-doubt transactions by restarting the Application Server. Or stop the Application Server, remove the <WAS_ROOT>\tranlog and partner log files, and then restart the Application Server.
 
 
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 > DB Connections/Connection Pooling
Operating system(s): AIX
Software version: 5.1.1
Software edition:
Reference #: 1204133
IBM Group: Software Group
Modified date: Apr 20, 2005