Runner Macro reports failure, but seems to have run successfully?

warrencowan

Hi all,

I'm running a chain of 5 conditional runner macros in a workflow, however number 4 reports failure, thus does not trigger the 5th runner.

However the workflows run fine outside of the runner, and even though the runner reports failure, the data outputs in the reported failed 4th workflow are being updated, indicating that the 4th workflow must have run successfully.

I've tried to inspect and compare the settings of the successful and failed workflows in the runner to see what could be so different but I'm not seeing anything jump out at me in the settings / meta data etc.

Any fixes or troubleshooting advice much appreciated.

many thnx in advance

dubya

some vague extra detail jic:

each workflow in the runner chain outputs to a combination of Alteryx and SQL DB's.

each is dependent on an output in the previous in some way.

no macros in the reported failed workflow.

all workflows have the limit conversion errors as checked, max 10 per loc. (the default, i think)

on previewing the failure tab, the failed row reports '1' in the error column.

Log column is truncated in the preview so no available clues there, and I don't know how to further interrogate that.

warrencowan

OK, so for what it's worth I managed to solve this one myself, so am just posting my feedback in case anyone else runs into the same.

Turns out there was a sampling tool left in the workflow, that was leftover from previous testing. I left it in just in case I needed to reconnect it for another round of testing.

Whilst it had no impact on the completion of the workflow, the fact that there was an unconnected block created an error message in the log all the same.

Deleting the block from the workflow allowed the workflow to run free of any reported error, and then ran and reported successfully in the runner. Seems this reported error was enough to cause the conditional runner macro to report a failure of the workflow, even though it had run through to its intended completion.

Lesson learned!

Ensure that workflows are error free, even if they're not critical.

Delete or deactivate loose unconnected tools.

and thanks to @MarqueeCrew all the same, for providing such awesome functionality in the first place. It's certainly not their fault that it isn't noob proof.