Cancel workflow on error still triggers downstream macro

Question

Hello

I have a macro where i have Success and Failure Outputs. When a job fails, the Success output gets 0 records. I then pass that to a message where i want it to fail on 0 records . If not 0 then it should trigger the next macro. I have cancel workflow on error set. But what happens is it triggers the downstream macro and then throws the error. How do i overcome this?

Output LogWorkflow
Message Tool

Joel_Akaje-Macauley · Answer

I have found that if you change the mesage type from error to error- and stop passing records through this tool it works. It seems to be a bug that when only producing the error the workflow does not stop.

Joel_Akaje-Macauley · Answer

I have found that if you change the mesage type from error to error- and stop passing records through this tool it works. It seems to be a bug that when only producing the error the workflow does not stop.

SeanAdams · Answer

Hey @fnoahbiro

If I understand you correctly you have a series of macros in order, and you only want  to run macro 2 if macro 1 succeeded?

I think that the way round this is instead of using standard macros, use Batch Macros - so if it fails, it doesn't pass on control to the next one.

If you can mock up a simple version of the problem, we can iterate quickly on this together!