Toad Data Point - Find and Replace is deleting file

Toad Data Point & Toad Intelligence Central
2

I'm gonna sound like a Support guy, but have you been able to test your automation job using the latest TDP 6.1 release? I would strongly suggest always using the latest version, for obvious reasons.

I have a very similar automation job that I run from time to time. My job also has two steps in the FIND-REPLACE task...

  1. The first replace step
    a. Reads in a FormLetterIN file (this file never changes, is READ ONLY)
    b. Replaces the first variable placeholder in the file with a value from a database table.
    c. Saves the output to a file called FormLetterOUTfinal.

  2. Second replace step
    a. Reads in the FormLetterOUTfinal file as input
    b. Replaces the second variable placeholder in the file with a value from the database
    c. Saves the output to the same FormLetterOUTfinal file.

Incidentally, I've used both TXT and HTML file types for my FormLetterOUTfinal, and I've never had any issues like the one you're seeing. AND, I've been running this automation job here and there since TDP 5.6.

All that said, where are your email body files kept? Network shared drive? Is it possible that other apps or users or processes have access to the files?

How many occurrences of replacement are done in the first replace step? If there are MANY, then I'm wondering if TDP tries to run your second replace step while the file system still has a handle on the file and not finished with all the replaces from the first step? If that's the case, one work-around might be to use two FIND-REPLACE tasks (instead of one task with multiple replace steps.)