PI72136: SERVER STARTUP FAILS WITH CWRLS0009E ERROR DUE TO FAILURE IN THE TRANSACTION MANAGER'S RECOVERY LOG SERVICE.

Fixes are available

APAR status

Closed as program error.

Error description

CWRLS0009E occurs due to failure Exception calling
setTransactionIsolation on a JDBC connection.

A typical callstack is shown below:

CWRLS0009E: Details of recovery log failure:
java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the
only valid transaction levels
 at
oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(Ph
ysicalConnection.java:5376)
 at
oracle.jdbc.OracleConnectionWrapper.setTransactionIsolation(Orac
leConnectionWrapper.java:185)
 at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.setTransacti
onIsolation(WSRdbManagedConnectionImpl.java:5650)
 at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setTransactionIsolati
on(WSJdbcConnection.java:3707)
 at
com.ibm.ws.recoverylog.custom.jdbc.impl.SQLMultiScopeRecoveryLog
.prepareConnectionForBatch(SQLMultiScopeRecoveryLog.java:3652)
 at
com.ibm.ws.recoverylog.custom.jdbc.impl.SQLMultiScopeRecoveryLog
.internalForceSections(SQLMultiScopeRecoveryLog.java:2107)
 at
com.ibm.ws.recoverylog.custom.jdbc.impl.SQLMultiScopeRecoveryLog
.forceSections(SQLMultiScopeRecoveryLog.java:2053)
 at
com.ibm.ws.recoverylog.custom.jdbc.impl.SQLRecoverableUnitImpl.f
orceSections(SQLRecoverableUnitImpl.java:599)
 at
com.ibm.ws.recoverylog.custom.jdbc.impl.SQLRecoverableUnitImpl.f
orceSections(SQLRecoverableUnitImpl.java:537)
 at
com.ibm.tx.jta.impl.RecoveryManager.updateTranLogServiceData(Rec
overyManager.java:1205)
 at
com.ibm.tx.jta.impl.RecoveryManager.run(RecoveryManager.java:216
6)
 at java.lang.Thread.run(Thread.java:809)

Local fix

Problem summary

****************************************************************
* USERS AFFECTED:  WebSphere Application Server users that     *
*                  have configured the transaction service to  *
*                  store its logs in an Oracle database.       *
****************************************************************
* PROBLEM DESCRIPTION: CWRLS0009E occurs due to failure        *
*                      Exception calling                       *
*                      setTransactionIsolation on a JDBC       *
*                      connection.                             *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
APAR PI65127 introduced a change that was targeted
at DB2 but, in error, affected all supported database
platforms.

Problem conclusion

The recovery log component was modified so that the correct
initilization is performed depending on database type.

The fix for this APAR is currently targeted for inclusion in
WebSphere Application Server fix packs 8.0.0.13, 8.5.5.11 and
9.0.0.3 and WebSphere Application Server Liberty fix pack
17.0.0.1.  Please refer to the Recommended Updates page for
delivery information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

Temporary fix

Comments

APAR Information

APAR number
PI72136
Reported component name
WEBSPHERE APP S
Reported component ID
5724J0800
Reported release
800
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-10
Closed date
2016-12-12
Last modified date
2016-12-13

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

Fix information

Fixed component name
WEBSPHERE APP S
Fixed component ID
5724J0800

Applicable component levels

R800 PSY
UP
R850 PSY
UP
R900 PSY
UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
04 May 2022

Tips

PI72136: SERVER STARTUP FAILS WITH CWRLS0009E ERROR DUE TO FAILURE IN THE TRANSACTION MANAGER'S RECOVERY LOG SERVICE.

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R800 PSY

R850 PSY

R900 PSY

Document Information

Share your feedback

Need support?