This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email email@example.com for assistance.
The command line examples to execute 1 workflow after another works when I test it for running 2 workflows but it errors out at the end.
Error: Designer x64: The Designer x64 reported: Error running Event #1: The external program "C:\Program Files\Alteryx\bin\AlteryxEngineCmd.exe" returned an error code: 1: The system could not find the environment option that was entered. (203)
I ran the below command manually in command prompt on the server and I get the same error as of the gallery/designer.
Command: AlteryxEngineCmd.exe "C:\files\1.yxmd"
I am assuming the AlteryxEngineCmd.exe is trying to access system environment variables and they might be different than what it is expecting or such environment variable does not exist. What could it be?. Can someone please shed some light on this? This question is asked in numerous topics and NO ONE answered this.
Thanks for the reply. I wanted to post my finding but missed to reply here. I added the Alteryx root path to Path System Variables on the server before I posted this question here.
The problem I think are the warnings in the 2nd workflow. Because, if I run the 1st or 2nd workflow individually through the command line, it works fine. But when I call the 2nd workflow problems arise. The warning error code created by the command line is sent back to 1st workflow which is still open in designer or gallery waiting for 2nd one to complete does not know how to read that error code from the command line of 2nd workflow. And hence it fails and throws that error.
Basically, the warnings from 2nd workflow is considered as an error and hence the 1st workflow fails at end even though the 2nd workflow executed completely and has warnings.
There is no way I found on the community to ignore/bypass such warnings. Hence this method won't work for me.
Values returned when a Workflows run via command line : 0 - Success 1 - Warnings Exist 2 - Errors Exist
- When you run Main workflow, Workflow X runs, but it produces warnings messages (value returned is 1). - Most programs interpret a return code of anything other than "0" as an error which is why you're having trouble with it. Because it was interpreted as an Error, Workflow Y also runs. - And Main workflow generates an error: Designer x64 The Designer x64 reported: Error running Event #2: The external program "C:\Program Files\Alteryx\bin\AlteryxEngineCmd.exe" returned an error code: 2: The system could not find the environment option that was entered. (203)
1. Fix whatever warnings are in the workflow for the program to return a "0" status.
2. Change the order of execution of the events. Move Up "After Run With Errors: Run Workflow Y using AlteryxEngineCmd.exe" to the Top and then "After Run Without Errors: Run Workflow X using AlteryxEngineCmd.exe"
3. There is a way to return a different status code via a batch script. The batch file would have to be called directly:
This will force the batch script to return 0 if there's an error level of 1, still return an error if there is an error in the workflow, or exit with a 0 otherwise (if no warnings or errors). This is honestly probably not the best way to handle it, but this is an easy method people have setup when people have wanted to run additional workflows in events, as warnings would return "1" and cause an "error" in Designer since Designer sees any event that returns anything other than a "0" an error.
My recommendation is to try workaround 2. Please test it and let me know if it works.