Hi, all.

We have a client who wants to use FX to allow his management people to check their budget balances & other reports using FX but for some reason the FX data gets stale even though it is supposed to refresh nightly.

The main Adagio GL data is stored on a Linux based file server. Task Scheduler runs on a Windows 7 system with the file shares from the Linux server mapped to drive letters. Task Scheduler runs a batch file that runs FX.exe repeatedly for a bunch of data sets with the command line options for user, password, database path, etc. and each FX target path has an AFWININI.dat file with the appropriate options for each retrieval. The batch file makes sure that the file shares are indeed mapped to the drive letter before starting the FX jobs. If the batch file is just run by double clicking it the sequence of retrieves goes off without any errors, it just churns one at a time through Admin, Education, Social, etc. The batch file contains lines like echo "Admin start" >> fxretr.txt and echo "Admin end" >> fxretr.txt so I can see how it progressed and it appears to get through all the data sets.

The Task Scheduler window shows that the batch file ran from midnight to 12:35 and had an exit status of 0x0 but the FX data is many days out of sync with the GL. eg: on Friday Jan 6th the FX numbers and the GL numbers matched exactly. By Jan 10th the FX numbers were still the same as they were on the 6th and the GL was different because two days of new work had been done to it.

The client also has a trial version of Adagio Console set to enforce a maintenance window from 11:30pm to 4am every night so that if some employee leaves GL open they will get kicked off so the FX retrieve can run.

Does Adagio Console need to be running on one of the Windows clients to actually enforce that maintenance window?

Is there anything else I should know about getting a Task Scheduler job to keep the FX data current?

Thanks for any tips.