IT36409: STERLING CONNECT:DIRECT RUNTASK FAILING WITH ROLLBACK TRANSACTION ERROR

APAR status

• Closed as program error.

Error description

• Issue is seen with "Rollback Transaction Error" on CD RunTask
  and some on MailboxAdd service.
  
  Bad connection and connection
  closed seen from the logs while trying to insert/update some
  correlation data:
  Example of the error
  [2020-09-27
  08:09:47.457] ERRORDTL
  [1601190587457]java.sql.SQLRecoverableException: Closed
  Connection
   at oracle.jdbc.driver.PhysicalConnection.getAutoComm
  it(PhysicalConnection.java:4337)
   ....
   com.sterlingcommerce.woo
  dstock.workflow.crl.CorrelationDBAccess.saveSQL(CorrelationDBAcc
  ess.java:333)
  

Local fix

• B2BISFG-54347
  

Problem summary

• Platforms Affected:
  
  All
  
  
  Problem Description:
  
  Sterling connect:direct runtask failing with rollback
  transaction error:
  
  
  
  "Rollback Transaction Error" on most of
  the CD RunTask and some on MailboxAdd service.Logs show bad
  connection and connection closed seen while trying to
  insert/update some correlation data.
  
  
    Users Affected: All
  

Problem conclusion

•     Resolution Summary:
  A code fix is provided.
  Added better code handling to log the error better.
  
  
  
  Delivered in:
  5020605_4
  

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

  STR B2B INTEGRA

• Fixed component ID

  5725D0600

Applicable component levels