We use TfDA rel 2.5.1 from a Server. In almost all cases, this has been working reliably. However, there is one monthly TfDA automation task with four discrete steps that just does not work. Each step is a separate scheduled task. They are executed in series, with plenty of time between each task for the previous one to finish. These four tasks execute as expected when testing on my PC. However, on the Server, they stop working at Step 2 with the following error msg:
The process cannot access the file ‘XXXX’ because it is being used by another process.
Here’s a description of what happens in each step of this monthly task - just to reiterate, each step is scheduled separately; it runs fine from my PC; it bombs out at Step 2 with above msg:
- Previous month’s file is copied-and-renamed for archival purposes.
- Previous month’s file is deleted.
- Extract is done for the current month.
- Current month file is e-mailed out to recipients as an attachment.
It must have something to do with the (attempted) use of the File Activities (Copy File, Delete File) because the other scheduled TfDA jobs do not use these. Any insights would be very much appreciated. Many thanks in advance.