PI15273: STALECONNECTIONEXCEPTION IN THE WEBSPHERE BATCH ENDPOINTS AND NOT RECOVERING FROM DATABASE DISCONNECT.

APAR status

• Closed as program error.

Error description

• Customer is using WebSphere Batch in WebSphere V8.5.5.1 and the
  Job Scheduler is not recovering from database disconnect.
  The logs indicate StaleConnectionExceptions as below.
  
  22/03/14 02:38:26:046 EDT] 00001f04 MCWrapper     E   J2CA0021E:
  An exception occurred while trying to get a Connection from the
  Managed
  Connection resource jdbc/DACMSWASCGXA :
  com.ibm.ws.exception.WsException: DSRA0080E: An exception was
  received by the Data Store Adapter. See original exception
  message: Read timed out. with SQL State : 08S01 SQL Code : 0
      at
  com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.setLin
  kedException(DataStoreAdapterException.java:535)
      at
  com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2
  288)
      at
  com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUt
  il.java:1584)
  
  ...
  ...
  Caused by: com.ibm.websphere.ce.cm.StaleConnectionException:
  Read timed out DSRA0010E: SQL State = 08S01, Error Code = 0
      at
  sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
  Method)
      at
  sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeCons
  tructorAccessorImpl.java:68)
      at
  sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Delega
  tingConstructorAccessorImpl.java:45)
      at
  java.lang.reflect.Constructor.newInstance(Constructor.java:529)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server                                      *
  *                  Java Batch                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Database update failures are not        *
  *                      retried resulting in failed             *
  *                      operations.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Database update failures are not retried.
  

Problem conclusion

• When the endpoint server encounters a StaleConnectionException,
  it will now attempt to obtain another connection and retry the
  operation. All other types of SQLException will be propagated
  to the caller to handle.
  
  The fix for this APAR is currently targeted for inclusion in
  fix pack 8.5.5.2.  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 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