DataDirect based Report Template execution by Scheduler can saturate C: drive
Everytime an Excel report using a DataDirect function is executed, two files are left in C:\windows\temp. The file names are ~Dxxxxxxxxxxxxxxxxx.TMP and CVRxxxx.tmp.cvr. These files have a cummulative size of 5MB. Depending on how quickly these reports are executed by the Scheduler, it is possible to completely fill the C volume. With a saturated C volume, the PC may begin to fail unexpectedly.
In SV5.1 RevD, support for Excel 2013 was introduced. This combination of software produces the temp files that are not removed upon report completion.
There are several possible solutions to this problem:
1. Upgrade Office to an earlier version that is still supported in SV5.1. Office 2010 for example.
2. Upgrade the system to SV6.0 where the problem doesn't exist.
3. If neither 1 or 2 is possible, a bat file that deletes the tmp files can be create and periodically run by a Scheduler Report Action. This will keep the files from using a dangerous amount of disk space.
Example bat file contents:
Example Report Action to execute bat file: