Run Command failing on scheduler

Hi,

I've built a really simple ETL, it has 1 command, RUN a bat file with a python script inside. If I run the file on the command it runs fine, if I run on Alteryx it runs fine, in Scheduler it fails with:

Start: Designer x64: Started running at 2017-02-07 15:24:21
Error: Tool #14: The external program "C:\Users\xxxx\Desktop\ETL-Alteryx\bigquery\donor_last_touch\donor_last_touch.bat" returned an error code: 1
End: Designer x64: Finished running in 3.9 seconds

Any ideas?

Thanks

Joao

Error Message

Scheduler

Run Command

Accepted answers

dev_raut

Hello guys,

We were facing the same issue as you mentioned. We were not able to refresh the excel file through scheduled workflow using VBScript.

I Googled it a lot and finally came across one post which helped us resolve the issue. Hope it helps you guys too

"******** Link

Faye:

I had the same issue and fought with it for a few months. Finally resorted to calling Microsoft for some assistance. The fix isn’t something I would have ever found, so hopefully this helps others too. The script would run fine when I launched it in Powershell (and command line) but when it launched as a scheduled task it would run but not with expected results. Microsoft informs me that my issue is with running Excel in “non-interactive mode”, you require two directories to be created.

You have to create a folder (or two on a 64bit-windows):
(32Bit, always) C:\Windows\System32\config\systemprofile\Desktop

(64Bit) C:\Windows\SysWOW64\config\systemprofile\Desktop

The MS Excel when you are trying to run in non-interactive mode will look for this, if it is not present it will not open in the non-interactive mode.

once these were created the scheduled task runs flawlessly.*******"

All comments

KaneG

Hi @joao,

This is most likely related to the user that is running the script. The scheduler uses a windows user, not your user account and so may not have access to the details inside the batch file. You can set up the 'Run As' user in System Settings on the machine with the scheduler.

Your other option is to add ' > C:\outputlog.log' to the end of the batch command to write the output of the cmd window to a log file and see what the failure is.

Kane

joao

I right click on the .bat file and can't find the Run As option. I tried the log it is empty. The ETL runs fine if I run it by hand. What should I do?

Thanks

Joao

joao

Ok solution 3: Run the scheduling service as the same user. End of problems!

Thanks

Joao Correia

stapuff

Glad this was posted. Created the 2 folders as suggested and works flawlessly.

Puff

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335