FTP automation File removed and not downloaded

Toad Data Point & Toad Intelligence Central
1

I am using Toad Data Point to automate SFTP download. I am "Moving" the files so that they get deleted from the ftp site when the files are downloaded. I have found that several times per day files are "Removed" but never "downloaded" I am losing several files per day. I can see this in the log when reviewing the issue:

-- 10/19/2020 2:21:19 PM: MEMO_POST_IMPORT.log: COH_MEMOPOST_10192020_676334_CC.TXT succesfully downloaded

-- 10/19/2020 2:21:20 PM: MEMO_POST_IMPORT.log: COH_MEMOPOST_10192020_676335_ACH.TXT succesfully downloaded

-- 10/19/2020 2:21:21 PM: MEMO_POST_IMPORT.log: COH_MEMOPOST_10192020_676336_CC.TXT succesfully downloaded

-- 10/19/2020 2:21:22 PM: MEMO_POST_IMPORT.log: COH_MEMOPOST_10192020_676334_CC.TXT successfully removed.

-- 10/19/2020 2:21:23 PM: MEMO_POST_IMPORT.log: COH_MEMOPOST_10192020_676335_ACH.TXT successfully removed.

-- 10/19/2020 2:21:24 PM: MEMO_POST_IMPORT.log: COH_MEMOPOST_10192020_676336_CC.TXT successfully removed.

-- 10/19/2020 2:21:24 PM: MEMO_POST_IMPORT.log: COH_MEMOPOST_10192020_676337_CC.TXT successfully removed.

-- 10/19/2020 2:21:25 PM: MEMO_POST_IMPORT.log: Successfully downloaded files using wildcard COH_MEMOPOST_*.TXT

File COH_MEMOPOST_10192020_676337_CC.TXT was REMOVED but never DOWNLOADED. What can be done to ensure that this does not happen?

2

Hi, could you send us the automation script so we can try to replicate it in our env?

3

Where can I send this to you? I was attempting to upload a zipped .tas or just a .tas and neither was allowed.

Thank you for taking time to look at this.

4

Hi, if you change the extension and then zip it should be fine here.
Edit: I tried it and it works - rename the TAS to PDF and then zip it and you can send it.

5

Now I get a message that says "New users cannot upload documents"...Oh well I will find another solution.

6

I'll PM you my email address :wink:

7

Hi Dan,
Thank you for looking into this for me. Do you happen to have an update or a suggestion how to set this up in a way that I am not losing files?

Steve