Skip to main content
Solved

Run multiple workbenches in sequence based on success and failure of preceding workbenches on FME Desktop

  • May 15, 2023
  • 1 reply
  • 162 views

Forum|alt.badge.img

I want to run multiple workbenches in a sequential order based on the success and failure of previous workbenches. I only have access to FME Desktop (No server) so I used 'WorkspaceRunner'. I created 3 workbenches (all three with basic tasks to open an excel workbook and Add/Subtract/Multiply values in column A with values in column B then add the results into a new sheet of the same workbook). Only issue is the flow runs through until the end and gives me 'Translation was SUCCESSFUL' even though one of the them fails to run, I tried using 'Tester' with different values but nothing useful. Thanks in advance for any suggestions.

Best answer by virtualcitymatt

You need to make sure that the "Wait for Job to Complete" is set to "Yes". If a job fails a feature will come out of the "Failed" port. If "Wait for Job to Complete" is set to no then FME will submit the jobs in parallel...great for batch conversions but not great for chained jobs like want.

 

If you want the parent workspace to fail when a child workspace fails you can add a Terminator transformer connected to the failed port. The Terminator transformer will force the workspace to Fail and you can add a custom ERROR message.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

virtualcitymatt
Celebrity
Forum|alt.badge.img+47
  • Celebrity
  • 2000 replies
  • Best Answer
  • May 15, 2023

You need to make sure that the "Wait for Job to Complete" is set to "Yes". If a job fails a feature will come out of the "Failed" port. If "Wait for Job to Complete" is set to no then FME will submit the jobs in parallel...great for batch conversions but not great for chained jobs like want.

 

If you want the parent workspace to fail when a child workspace fails you can add a Terminator transformer connected to the failed port. The Terminator transformer will force the workspace to Fail and you can add a custom ERROR message.