to happen only once, instead of every 5 minutes... the scheduled
task ran without a problem. The query ran, email was generated and spooled,
sent out, received, without any problem or CPU spiking.
Now I've got the task set back to every 5 minutes...we'll see what
happens...
Rick
-----Original Message-----
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 11:04 AM
To: CF-Talk
Subject: RE: Trouble running scheduled task
Yes, that was the first thing I checked.
I ran into, and overcame, that problem a couple of years ago.
Once the service is stopped, then restarted the 1k email goes out,
is delivered and contains the appropriate message.
Rick
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 10:21 AM
To: CF-Talk
Subject: RE: Trouble running scheduled task
Hey, is the mail to be sent got anything in it?
<sic>
ColdFusion 4.5.1 SP2 (specifically) was the only version of ColdFusion
to
get hung on
zero-byte mail written to the spool. The file handle of the mail would
get
written
and ColdFusion would encounter some other runtime error that caused the
leaked file
handle to be completed. The secondary effect of this is that CF would
get
stuck
sending out or moving the bad mail file and race the cpu. 1 cpu would
spike
to
99-100%, and 2 cpu would spike at exactly 50% each.... flat line.
_____
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 20 January 2004 15:24
To: CF-Talk
Subject: Trouble running scheduled task
Good morning, all...
Win 2000 Pro, CF 4.5
I've ventured out of the box and decided to try and run my first-ever
scheduled task.
Here's the code I'm running:
<CFQUERY Name="Get_DSP_Addresses" Datasource="dsp">
Select CustomerID
from emailcustomers
</CFQUERY>
<CFMAIL To="[EMAIL PROTECTED]"
From="[EMAIL PROTECTED]"
Subject="DSP Email Newsletter Recipients">
Dorchester Shooting Preserve has #Get_DSP_Addresses.RecordCount# email
newsletter recipients.
</CFMAIL>
The query runs fine, and the email is generated and sent to the
spool folder, but once that happens the CPU runs up to 100%
and the system sits there, email in the spool, until I stop CF in
services,
then restart...then the mail is sent, received, and contains appropriate
info.
It acts like the same problem as a "0k email", but these are not empty.
Now, I don't have any other HTML code or anything on the template...just
what
you see above.
What could be the problem?
Thanks for your help!
Rick
Rick Faircloth,
Hinesville, Georgia
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
