Enterworks - ETT 160 - How to Ensure EPX Work Items Launched in Batches are Staggered

Enterworks - ETT 160 - How to Ensure EPX Work Items Launched in Batches are Staggered

Workflow, Patterns

rate limit

Code not recognized.

About this course

In some EnterWorks implementations, there is a need to have EPX Workflow launch a set of work items to perform processing on multiple repository records based on some criteria, such as being updated from an import, or state changes based on mass edits by users.  The SQL Create Work Item BIC activity can be used to launch these work items.  While this activity allows the batch size and delay between batches to be specified, it still results in multiple work items being launched at the same time and those work items proceed through the target workflow in concurrent fashion.  This can lead to issues with some activities that are not thread-safe (and issue being addressed in version 11.1).  The batch size can be reduced to 1 and the interval set to 1 minute, but this would result in a very low throughput rate of only 60 work items per hour.

By staggering the work items by a second or two, the concurrency issues can be avoided.  This session provides the details on a method accomplishing this.

 Prerequisites - ETT 070

About this course

In some EnterWorks implementations, there is a need to have EPX Workflow launch a set of work items to perform processing on multiple repository records based on some criteria, such as being updated from an import, or state changes based on mass edits by users.  The SQL Create Work Item BIC activity can be used to launch these work items.  While this activity allows the batch size and delay between batches to be specified, it still results in multiple work items being launched at the same time and those work items proceed through the target workflow in concurrent fashion.  This can lead to issues with some activities that are not thread-safe (and issue being addressed in version 11.1).  The batch size can be reduced to 1 and the interval set to 1 minute, but this would result in a very low throughput rate of only 60 work items per hour.

By staggering the work items by a second or two, the concurrency issues can be avoided.  This session provides the details on a method accomplishing this.

 Prerequisites - ETT 070