Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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