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 EYOSCHEDULER.CFM, 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. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
