JR64862: EVENT MANAGER DOES NOT RECOVER AUTOMATICALLY FROM A DATABASE CONNECTION FAILURE

APAR status

• Closed as program error.

Error description

• You may see this error in SystemOut.log file.
  
  [3/23/22 2:49:44:719 UTC] 00000125 WSJdbcPrepare W  DSRA8600W:
  Error closing
  oracle.jdbc.driver.OraclePreparedStatementWrapper@15c7f4ca
  java.sql.SQLRecoverableException: Closed Connection
  [3/23/22 2:49:44:750 UTC] 00000125 ConnectionEve A  J2CA0056I:
  The Connection Manager received a fatal connection error from
  the Resource Adapter for resource jdbc/TeamWorksDB. The
  exception is: java.sql.SQLRecoverableException: IO Error: A
  connection attempt failed because the connected party did not
  properly respond after a period of time, or established
  connection failed because connected host has failed to
  respond.:java.io.IOException: A connection attempt failed
  because the connected party did not properly respond after a
  period of time, or established connection failed because
  connected host has failed to respond.
  
  PRODUCTS AFFECTED
  IBM Business Automation Workflow
  

Local fix

Problem summary

• For some scenarios, the Event Manager does not handle
  transaction retry when the database connection fails.
  

Problem conclusion

• A fix is available or will be available that fixes the
  transaction retry issue in Event Manager.
  

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

  BUS AUTO WORKFL

• Fixed component ID

  5737H4100

Applicable component levels