Slow Down CFMail or Query?

[3dColor]

I got an error this morning from a schedule task that sends out emails each morning.

CF Error: The request has exceeded the allowable time limit Tag: CFQUERY  <br>The error occurred on line 75.

This morning I had a lot more added to the emails this morning than I usually have.

Line 75 is the middle line here:

<CFCASE VALUE="1">
	<CFSET cfml.propType = #type1#>
</CFCASE>

I am try to figure out if this issue is with my mail server (which is on the same dedicated box) or with slowing down CF Mail.

What are some ways to isolate the issue to figure out what is causing this?

 

[GUJUm0deL]

Did you check the mail logs to see what CF encountered? Is this the first time this issue came about? Try restarting the mail server and wait to see if there is a pattern developing.

Just outta curiosity, how is #type1# being pupulated? is it being returned for a query call? Or, somehow else?

_____________________________
Just Imagine.

http://www.imajinarts.com

 

[3dColor]

Ok, I checked the mail delivery log and this is what I found:

06:00:14 [49512] Exception: Cannot process request because the process has exited.
at System.Diagnostics.Process.GetProcessHandle(Int32 access, Boolean throwIfExited)
at System.Diagnostics.Process.Kill()
at SmarterTools.SmarterMail.RelayServer.SpoolExecutable.Run()
06:00:14 [49529] Exception: Cannot process request because the process has exited.
at System.Diagnostics.Process.GetProcessHandle(Int32 access, Boolean throwIfExited)
at System.Diagnostics.Process.Kill()
at SmarterTools.SmarterMail.RelayServer.SpoolExecutable.Run()

My guess is that the mail process stopped because of CFQuery was timing out.

I restarted the mail server, we will see what happens in the morning.

#type1# is declared in the application.cfm.

 

[GUJUm0deL]

Have you ran the query in query analyzer (if using MS SQL Server) to see how long it takes for the query to process? Try doing a <cftry><cfcatch> around the query call itself to see what happens.

_____________________________
Just Imagine.

http://www.imajinarts.com