EnterWorks - ETT 150 - How to Avoid Database Deadlocks on Multiple EPX Scheduler BIC Starting Point Activities

Some EPX workflows launch work items automatically by the Scheduler BIC activity at one-minute intervals, including Scheduled Export Process, Scheduled Import Process, Scheduled Promote Process, and Change Notification Process.  If an environment has additional workflows with one-minute interval starting points, there is a possibility that database deadlocks may occur when these starting points process at the same time.

When the Scheduler BIC is configured, the starting time is defined at the minute granularity in Design Console.  This means all one-minute interval activities are going to trigger at the minute mark every minute.  Since the activity does not support configuring the seconds for the start time, these events cannot be staggered through Design Console.  The actual times that are stored are in milliseconds so using SQL, the start times can be staggered, which will greatly reduce the likelihood of deadlocks when processing these activities.

This session shows how to use the SQL stored procedure.

Prerequisites - ETT 018