IBM Support

Schedule_PurgeService fails with Error occured in online purging process.

Troubleshooting


Problem

Schedule_PurgeService fails with Error occured in online purging process.

Symptom

Gentran Integration Suite, all versions.

MySQL database

Scheduled Purge service fails with error "Error occured in online purging process"

This problem could occur after a BP has looped and created large numbers of rows in the database tables.
 

Error Message

error in wf log:-
ERROR 000110011401 WORKFLOW.WORKFLOW.ERR_SQLException191 WorkFlowContext  .persist() caught SQLException while attempting to persist data
SQL Error Code: 1206
SQL State: HY000
java.sql.SQLException: The total number of locks exceeds the lock table size
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
 at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129)
 at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)
 at com.sterlingcommerce.woodstock.workflow.WorkFlowContext.doArchive(WorkFlowContext.java:5073)
 at com.sterlingcommerce.woodstock.workflow.WorkFlowContext.persist(WorkFlowContext.java:4305)
 at com.sterlingcommerce.woodstock.workflow.WorkFlowContext.persist(WorkFlowContext.java:3729)
 at com.sterlingcommerce.woodstock.workflow.engine.WEHelper.dispatch(WEHelper.java:1262)
 at com.sterlingcommerce.woodstock.workflow.engine.WEHelper.dispatch(WEHelper.java:1104)
 at com.sterlingcommerce.woodstock.workflow.engine.WorkFlowEngineRMIImpl.dispatch(WorkFlowEngineRMIImpl.java:964)
 at com.sterlingcommerce.woodstock.workflow.Dispatcher.run(Dispatcher.java:72)
 at java.lang.Thread.run(Thread.java:810)

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

NFX9025

Document Information

Modified date:
16 June 2018

UID

swg21555131

Page Feedback