Python tool seems stuck at 50%

[aatalai]

We have created a macro to import data from TM1 into our alteryx workflow (based on this post)

When we have ran in other workflows it runs fine, howerver, in one specfic workflow it is stuck at 50% (see screenshot)

More interestingly the rest of the workflow says all other tools are at 100% and we were expecting only 45 rows of data. It has now complete after over 11 mins; still is 45 rows of data and 1.3KB.

Can anyone help to see why it is the case? For reference when we run it in a workflow by itself with the same parameters  it only takes 9.1 seconds.

[danilang · Accepted solution]

Hi @aatalai 

Since the macro runs fine on it's own, there's an interaction between it and some other tool(s) in the workflow.  This could be caused by the tool execution sequence.  If you added the macro after the other tools in the workflow, it will run last even if you have it at the top of your workflow.  This is because Alteryx will use ToolID to prioritize tool execution if there are multiple inputs in a workflow.  ToolID is one of the only parameters you can't change so you're stuck with the order that you inserted the tools. 

If you have a Designer version that includes Control Containers (2023.1 and up) you can put the the macro in one container and the rest of your tools in a second one and connect the output of the first container to input of the second to control the order of execution.  If you don't have Control Containers, try copying the tools to a new workflow starting with the macro and then all the other tools.  This forces the macro to have a lower ToolID and should run first.

If this doesn't work, try adding  some print statements to your python code in the macro and make sure that you configure your main workflow to Show All Macro Messages in the Runtime options

Dan

[apathetichell]

Turn off amp - see if you see a new error message. troubleshoot new error message.