JR62401: YOU EXPERIENCE A PERFORMANCE ISSUE WHEN USING A REST API FOR BACKTRACKING

workflow.20002.delta.repository

APAR status

• Closed as program error.

Error description

• There are numerous additions to the LSW_TASK_CTX_HISTORY table
  in IBM Business Automation Workflow V19.0.0.2 table as compared
  with IBM Business Process Manager 8.5.5.
  
  You might see lots of the following in the trace files:
  
  [5/25/20 10:16:31:546 EDT] 000003a1 ExecutionCont 2
  com.lombardisoftware.component.common.workflow.ExecutionContextH
  elper updateTaskHistoryTable Writing EC history to table for:
  taskId = 46201621 seq = 1
  [5/25/20 10:16:31:546 EDT] 000003a1 clientinfoplu >
  prepareStatement Entry
  
  com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@81fc9add
                                   INSERT INTO
  LSW_TASK_CTX_HISTORY (TASK_ID,SEQ,EXECUTION_CONTEXT, CREATED_ON)
  VALUES(?,?,?,?)
                                   TYPE FORWARD ONLY (1003)
                                   CONCUR READ ONLY (1007)
  
  PRODUCTS AFFECTED
  IBM Business Automation Workflow
  

Local fix

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix is available or will be available that ensures the task
  history is not written to the database table for each step when
  backtracking is enabled.
  

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