PH31288: J2CA0045E -TOLERATING THE CONNECTION ERROR OCCURRED EVENT DURING THE MATCHMANAGEDCONNENTION.

PH31288: J2CA0045E: Connection not available while invoking method

APAR status

• Closed as program error.

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:                                              *
  ****************************************************************
  While using resource eis/JCAMail, if connection 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      E
  J2CA0045E: 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.JCAEmailConnectionF
  actory.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
  

Temporary fix

Comments

APAR Information

• 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

  WEBS APP SERV N

• Fixed component ID

  5724H8800

Applicable component levels

• R850 PSY

     UP

• R900 PSY

     UP