Fail External Tasks if Step Fails

Hi @kerry_bespoke ,

as far as I am aware your selected steps should run sequentially as you have Merge Steps turned off. I am not sure why you would use Classification over Execution Time, I assume you are running a legacy project from before Execution Time management. My expectation would be that a failure would lead to subsequent steps not being fired. Perhaps the Execution Management selection you have is influencing that?

You could enforce your expected behaviour by embedding the external steps in a separate package that you call in your initial package from Run Package, thereby only triggering the external step package on full and successful completion of the initial set of steps.

Hi Kerry

If you want it to run each step as its own thing I would make a execution package for each of the perspectives and one for the external executions, then I would set each execution package to run with 5 threads and managed execution set to execution time.

Then I would change the main one to include these other execution pacakges set it to not use managed execution and only run in one thread.

Then if one package fails it will stop completely. This is also more failsafe than using a run on success option as you can easier resume the failed load or run an individual perspective without running all the other parts.

Hey @kerry_bespoke did you get a chance to test this?

Hi @kerry_bespoke ,

I believe that the “outside” package settings get applied to the "inside” packages. So you probably need to set up the retries in the outer package. This is why I suggested my solution the way I did, it allows for more differentiation in the package settings.

Hi @kerry_bespoke 

You should use another managed execution setting. It should be set to disabled to run them in the order you applied the packages in.

The other package I am not sure I understand, why all these perspectives and why not run them with merge threads.

I assume it is essentially all tables, you could just create a big overarching perspective that have all the tables in it instead of 10-15 small ones.

In the last one you should also turn of managed execution.

Hi @vrowse ,

with the default setup and failure handling it will indeed only run the package specified in Run Package if the contents of the current package is fully successful. If you have many Exclude Steps or large amounts of Dynamic Perspectives it can become a bit heavy on your VM, you may want to consider Exmon in more complex scenarios.