IBM Support

PH31288: J2CA0045E: Connection not available while invoking method

Download


Downloadable File

File link File size File description

Abstract

J2CA0045E: Tolerating the connection errors during matchManagedConnection

Download Description

PH31288 resolves the following problem:

ERROR DESCRIPTION:
J2CA0045E: Connection not available while invoking method
createOrWaitForConnection for resource ...

Tolerating the connection error occurred event during the matchManagedConnention. The connection pool when processing the event is losing one or more managed connection during the error event.

LOCAL FIX:
Tuned the connection pool settings on unused timeout, Reap time and minimum connection.

Example:
Unused timeout 86400 sec. ->60 sec.
Reap time 180 sec. > 30 sec.
Minimum connections 5 -> 0


PROBLEM SUMMARY:

USERS AFFECTED:
All users of IBM WebSphere Application Server using Commerce Container

PROBLEM DESCRIPTION:
J2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource eis/JCAEmail

RECOMMENDATION:
None

While using resource eis/JCAMail, if connections are marked by  the resource adapter as a bad connection in the  matchManagedConnection code and the resource adapter uses connection error event in this method, connection can be
leaked resulting in J2CA0045E:
 
[2/1/21 13:51:45:442 CET] 00001114 FreePool EJ2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource eis/JCAEmail.
[2/1/21 13:51:45:444 CET] 00001114 CommerceSrvr E JMSMessageBean sendImmediate CMN9907E: A resource exception occurred during processing: "{0}".
javax.resource.ResourceException:com.ibm.websphere.ce.j2c.ConnectionWaitTimeoutException:
J2CA1010E: Connection not available; timed out waiting for 180 seconds.
at
com.ibm.commerce.messaging.adapters.jcaemail.JCAEmailConnectionFactory.getConnection(JCAEmailConnectionFactory.java:120)
at
com.ibm.commerce.messaging.objects.JMSMessageBean.sendImmediate(JMSMessageBean.java:236)
at
com.ibm.commerce.messaging.objects.EJSRemoteStatelessJMSMessage_d6d5624d.sendImmediate(EJSRemoteStatelessJMSMessage_d6d5624d.jav
a:71)

PROBLEM CONCLUSION:
The connection management code now handles the connection
error event if it occurs during ra.matchManagedConnection()

The fix for this APAR is targeted for inclusion in fix pack
8.5.5.20 and 9.0.5.8. For more information, see 'Recommended
Updates for WebSphere Application Server':
https://www.ibm.com/support/pages/node/715553

Prerequisites

None

Installation Instructions

Review the readme.txt for detailed installation instructions.

URL SIZE(Bytes)
V85 readme file 5222

Download Package

 
IMPORTANT NOTE:
WebSphere Application Server and Liberty fix access requires S&S Entitlement in 2021, use properly registered IDs to download fixes for WebSphere Application Server below. 
DOWNLOAD RELEASE DATE SIZE(Bytes)

DOWNLOAD Options

What is Fix Central(FC)?

8.5.5.19-WS-WAS-IFPH31288 22 June 2021 399531 FC

On

Technical Support

Contact IBM Support at https://www.ibm.com/software/mysupport/s/ or 1-800-IBM-SERV (US only).

Document Location

Worldwide

[{"Business Unit":{"code":"Cloud & Data Platform","label":"Cloud & Data Platform"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Component":"General","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"8.5.5.19","Edition":"Base","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
22 June 2021

UID

ibm16465943