Start Free Trial

Alteryx Designer Desktop Discussions

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

Adding time breaks in batch macros

45179902
8 - Asteroid

I have a question regarding batch macro. I wrote a .bat file that looks something like this:

COPY [file path of a document] [new file path of the document]

The .bat script will copy hundreds of files from a folder to another.

The problem is that there's no time break so sometimes the next process initiates before the previous process is completed.

How do I add a time break in the batch macro? What length of the break do you recommend? (most appropriate)

 

Error messages:

Error: e-alert-move-file (43): Record #36: Tool #19: Error creating the file " C:\Users\45179902\Desktop\45179902\rotation-1-credit-services\project-4-ci-e-alert-project\simulation\move-file.bat ": The process cannot access the file because it is being used by another process. (32)
Error: e-alert-move-file (43): Record #36: Tool #19: Failed to run external program "C:\Users\45179902\Desktop\45179902\rotation-1-credit-services\project-4-ci-e-alert-project\simulation\move-file.bat": The system cannot find the file specified. (2)
End: Designer x64: Finished running e-alert-submission.yxmd in 4:24 minutes with 2 errors

 

This error happens to random files.

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris
45179902
8 - Asteroid

@Qiu Thank you for the reference, but that didn't help. Our company policy prohibits downloading customised files from the internet. I see the accepted solution is an add-on.

 

Whilst I am able to copy files around, this error happens occasionally. Below are the error messages:

 

Error: e-alert-move-file (43): Record #36: Tool #19: Error creating the file " C:\Users\45179902\Desktop\45179902\rotation-1-credit-services\project-4-ci-e-alert-project\simulation\move-file.bat ": The process cannot access the file because it is being used by another process. (32)
Error: e-alert-move-file (43): Record #36: Tool #19: Failed to run external program "C:\Users\45179902\Desktop\45179902\rotation-1-credit-services\project-4-ci-e-alert-project\simulation\move-file.bat": The system cannot find the file specified. (2)
End: Designer x64: Finished running e-alert-submission.yxmd in 4:24 minutes with 2 errors

Qiu
21 - Polaris
21 - Polaris

@45179902 
I have prepared one sample fflow from scratch.
Can you check this one?

0105-GeorgeL.PNG

Labels
Top Solution Authors