nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Re-run workflow if error

jchulani13

Hi All,

I'm struggling to find a way to achieve this.

I need to re-run a workflow if it errors out (error is caused by time out on 3rd party data source) until it runs successfully. Ideally this solution would work when running on Alteryx Gallery as well.

I tried using the below solution as I saw this on the forums but it does not seem to work. Anyone know of a way to achieve this? Thanks!

Gallery

Error Message

Accepted answers

All comments

mceleavey

Hi @jchulani13 ,

there are different approaches to this if you are running it on a server compared to running it via the designer.

In your example, you are running it on the designer and so the method you've shown is correct. The only way to do that is to get Alteryx to trigger an event upon completion which will run in the event of an error. This will then trigger an external command via the command prompt to set the workflow to run again. This will loop continuously until the workflow runs without errors.

You say this doesn't seem to work...can you be more specific?

jchulani13

Thank you for the response @mceleavey , this is the error I get even with the correct file path.

Designer x64 The Designer x64 reported: Error running Event #1: Failed to run external program "AlteryxEngineCmd.exe C:\Users\myusername\Desktop\Tableau Projects\R12 Log Automation\Rerun Test.yxmd": The system cannot find the file specified. (2)

How would this be done on the server? Am I right in thinking it would be an iterative macro of some sort?

echuong1

I do want to make it clear that the Alteryx Engine Command is available with one of our automations products (ex: Scheduler, Server). Using this approach would work on Server because of that. It will not work on Designer unless you also have Scheduler.

That being said, you could develop the workflow and run it on Server. If you wanted to test the workflow, you can have your admin log into the actual Server machine.

https://help.alteryx.com/current/designer/run-workflows-command-line

raychase

You could also leverage the Alteryx Server API for this. It would be pretty easy to use either a .ps1 or .bat script to send an API call to run the desired application as a post-run event upon failure.

This way, you're not reliant on storing the .yxmd outside of the MongoDB of the Alteryx Server. No worries of versioning control.

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15912

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703