I have numerous automated processes, and a couple fairly regularly will error out with the following message: “The process cannot access the file ‘filename.csv’ because it is being used by another process.”
The tas file opens the oracle DB, runs one script to export the data to this file and if rowcount>0 it sends an email.
These files are not used by anyone/anything else and at 3 am, I know there is no one in file.
Any idea how I can get around this?
What version of TDA are you using? Exporting should not be having a file contention.
To debug I would look for any of the following items:
A script/scripts that export multiple times to the same file name. Try changing the export file name to something unique by appending Suffix of date time. Suffixes are available on all exports and files.
Does the file connection seem to occur right after a failed script? Perhaps a file is left open on a script failure. Try adding a delete file to the top of the scripts to free up the lock. (I’m not sure this will work but worth a try)
If on older version of TDA please upgrade to 2.6.1.