there are other tasks that run at the same time too but none that would interact with the same tables. One thing I did notice though that there is only one task that runs at 8:00 PM (which is this one) and there are 4 different tasks that run at 8:00 AM (including this task). Could that be an issue?
On Thu, Nov 12, 2009 at 6:25 PM, Maureen <mamamaur...@gmail.com> wrote: > > Is there any chance the morning run is conflicting with another task, > like a backup, or another import, and just stalling? > > On Thu, Nov 12, 2009 at 4:29 PM, Agha Mehdi <aghaime...@gmail.com> wrote: > > > > Yup. that's what I am doing now. CFTransaction is an option but it won't > do > > me any good if for some reason the processing just stops without any > error. > > It is strange but that's what's happening. I haven't found any errors in > the > > logs. Also, it gets more interesting as the task runs every 12 hours. the > > one that runs in the evening is fine and the one running in the morning > has > > started to not run after deleting records from two tables. I am also > going > > to start writing each row's insert/update success to a log file to see > > exactly what's going on. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4