pentahopentaho-spoon

Pentaho to kill all running transformations if any one them fails


I have a wrapper job which runs 4 transformations in parallel. I want to kill all the four transformations if any one of the running transformation fails.

If it would have been a wrapper transformation there is a possibility of error handling through setting a condition ExecutionNrErrors > 0.

If I add an abort job step on all these transformations it will make the other transformations killed but with a green tick instead of a red tick.

How do we achieve this in Pentaho Jobs?

Sample


Solution

  • I guess you are looking for a solution like that:

    enter image description here

    It won't work, but even if no transformation fails. The rule in Pentaho Data Integrator is to start a transformation as soon as possible. So the Success or Failure step will start as soon as one of the transformation finishes.

    You are warned of this facts, when you specify the transformations to run parallel.

    If you want the transformations parallel, you have to define a lock mechanism yourself. You can also replace your main job by a transformation, in which every thing is parallel, and you have Blocking step to wait for all teh transformation to finish.