I've been having frequent problems with a mailing schedule that I've set up in ColdFusion Administrator. It is quite database intensive, has a fair bit of string manipulation, and involves generating around 3 - 5K emails daily.
Nowadays, more and more frequently, I find the execution hangs in between (I am logging some output to check the status), and then finally times out at the request timeout point specified by me in CF Administrator. It also pushes up CPU utilisation to 100%, leaving me no option but to restart CF Application Server. When I restarted CF Application Server, I got this message in my server.log file : "Error","TID=1060","08/28/02","09:42:04","CFSCHEDULE","unknown exception condition<P> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag<p>The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (167:4) to (167:79) in the template file EYOSCHEDULER.CFM.</p><P><P>Date/Time: 08/28/02 05:00:31<BR>Browser: CFSCHEDULE<BR>Query String: RequestTimeout=5000<P>" So it seems that there was an unknown error in the mailing schedule template, which executed at 5 am today, but the error was not logged till 9:42 am, which is the time that I restarted CF Application Server. Does anyone know why this is happening ? Vishal. ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
