Just spend 2 whole days in despair trying to work out the weirdest problems with midnight workflows.
Basically we are using Powermart too for creating interface files. The new set of files ran okay for a week. I had unscheduled the old set of workflows.
Last weekend we had to kill the power to our building, so we had to manually reboot the servers. After a lot of sweating and cursing I just found out that the old set of workflows came back from the dead, causing all sort of misery (deadlocks, wrong extractions etc), cause both sets of files ran almost simultaneously.
The old set was still marked unscheduled, but ran anyway!!!!
Ties Blom
Information analyst
tbl@shimano-eu.com
Basically we are using Powermart too for creating interface files. The new set of files ran okay for a week. I had unscheduled the old set of workflows.
Last weekend we had to kill the power to our building, so we had to manually reboot the servers. After a lot of sweating and cursing I just found out that the old set of workflows came back from the dead, causing all sort of misery (deadlocks, wrong extractions etc), cause both sets of files ran almost simultaneously.
The old set was still marked unscheduled, but ran anyway!!!!
Ties Blom
Information analyst
tbl@shimano-eu.com