workflow on scheduler using batch files given errors

[AndrewCrayford]

I have an workflow which run's an number of batch files, but as soon as i put the workflow on a scheduler it displaying the following error message

The external program "xxxxx\JS_Copy.bat" returned an error code: 1

Any advise on how I can run the workflow with out getting this error message and on a scheduler? Do I have to run the batch Marco each time or can it be done only once?

Any advise would be great

[MichalM]

@AndrewCrayford 

The error normally suggests a problem within the batch script. If this runs as expected from the Designer and only throws the error when run on a schedule, I'm wondering whether this could be an access issue.

Is the batch script referencing a file/directory on your local computer? Do you have a run as user configured on your scheduler? If not, do you want to try configuring this as your user?

[AndrewCrayford]

The batch marco was run a couple of weeks back,I ran a test manual the other week and it was working correctly. 

The batch script is on the network which the Alteryx server has access to.

The batch is to only to rename the file and all the information is in the workflow.

I ran it not on scheduler and got the error, but as soon as i re ran the batch marco it works. Does it mean i have to run the batch marco each time I ran the workflow.

[MichalM]

@AndrewCrayford 

Where is the batch script executed from? From within the batch macro? Outside of it? Via Events?

Would you be able to share the workflow and the script? 

[AndrewCrayford]

The batch marco workflow will place a .bat file onto the network and this is outside of the main workflow which is on the scheduler.

There is one scrpipt to copy the file and place it into a folder.

The next one rename the file by putting the date at the end of the file.

The Alteryx server does has access to the network.

I not sure if i able to share the workflow. 

[MichalM]

When referencing the file path, are you using UNC path?

[AndrewCrayford]

When we called the batch file we are using the full file path.

[MichalM]

How about the output? You are referencing a D drive there. Is this directory on the server?

Also, do you use UNC paths when referencing the file you want to rename within the .bat file?

[AndrewCrayford]

😧 drive is the local file for the server.

The output in the workflow has the full file path,

I ran the effect batch marco workflow by it selt and then ran the main workflow which is on the server and it works. 

Do i have to include the batch marco workflow as part of the workflow that is on the Alteryx server? or do you run it once and that it? 

[MichalM]

Just to clarify, you're talking about two workflows here? What is the dependency between them?