Processing orchestration jobs sequentially

You can use the Process Orchestration Jobs Sequentially option when an orchestration contains activities that can conflict with each other when multiple instances of the orchestration are running. An instance of an orchestration is also known as an orchestration job.

About this task

For example, an orchestration could contain a Pick activity that contains branches for the Get Inserted Rows, Get Updated Rows, and Get Deleted Rows activities. The following steps show an example run time scenario for this orchestration with the Process Orchestration Jobs Sequentially check box not selected:
  1. An insertion into the database occurs, triggering the first instance of the orchestration to be created.
  2. The first instance of the orchestration starts processing the insert branch of the Pick activity.
  3. Before Get Inserted Rows activity completes in the first orchestration instance, a deletion in the database occurs triggering a second instance of the orchestration to be created.
  4. The second instance of the orchestration starts processing the delete branch of the Pick activity.

This is undesirable behavior because first instance of the orchestration (that is processing the Get Inserted Rows activity) should complete before the second instance of the orchestration starts to process the Get Inserted Rows activity to avoid a potential primary key exception in the database. These database actions should occur sequentially. To force the instances of the orchestration to run sequentially, select the Process Orchestration Jobs Sequentially check box for the orchestration. With this option set, the instances of the orchestration are run one at a time and conflicts, like primary key exceptions, are avoided.

Complete the following steps to set all jobs to run in a single instance check box.

Note: Selecting this option decreases the performance of the project.

Procedure

  1. Select the Project tab and expand the Orchestrations folder.
  2. To open an orchestration, double-click an orchestration in the Orchestrations folder. The orchestration is displayed.
  3. If the orchestration options are not displayed the bottom part of the orchestration tab, select Orchestration > Properties from the toolbar menu.
  4. Select the Process Orchestration Jobs Sequentially check box. This option is automatically selected if the orchestration contains shared variables.



Feedback | Notices


Timestamp icon Last updated: Wednesday, 15 June 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/orch_Processing_Orchestration_Jobs_Sequentially.html