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.

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