Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

run command not working all the time

JokeFun
8 - Asteroid

I have a macro as attached that runs the command to check the file lock status. It works sometime. But it fails frequently. 

The error message is: The external program "c:\windows\system32\cmd.exe" returned an error code: 1

 

I have tried to run the BAT file manually created from this workflow and it worked each time. So I don't know what is causing the error.

 

I added below code in the Arguments and then see in the log.txt file this message: Access is denied.

> %temp%\log.txt 2>&1

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@JokeFun 
Your run command configuration is somehow different with I usually do.
So I have modified and it seems works alright for a few times.
I output the bat file first to user temp folder, which should have no concern for permission issues.
then read back to execute it.

20211228-JokeFun-A.PNG20211228-JokeFun-B.PNG

JokeFun
8 - Asteroid

Hi @Qiu , Thanks! I tried yours and it worked. Actually I have tried the similar setting as well but not working (always). So just now I closed all my workflows and have the macro re-opened. This time it worked again. But then I go to the Application where this macro is used and run it in the designer, oops, it failed again.

Qiu
21 - Polaris
21 - Polaris

@JokeFun 
Sorry to hear that.
I can not see where will be the issue unless I have the whole picture.
Wish you good luck, 😁

Labels
Top Solution Authors