We have no session variables running within the directory.
I have a very basic Application tag to eliminate the possibility
of something being carried over.
<CFAPPLICATION NAME="webTAScheduler" SETCLIENTCOOKIES="No">
<CFSET REQUEST.DSN = "webTAdev">
Then in the schedule task I have something like the following:
<CFSET thisDate = #DateFormat(Now(), "MM/DD/YYYY")#>
<!--- Get Notification Information --->
<CFQUERY NAME="qGetNotification" DATASOURCE="#REQUEST.DSN#">
SELECT N.SUBJECT,
N.EMAIL_MESSAGE,
N.NOTIFICATION_ID,
S.SCHEDULE_ID,
S.PAY_PERIOD,
S.LEAVE_YEAR
FROM NOTIFICATION_TYPE N,
SCHEDULE S
WHERE N.TEMPLATE_NAME = 'notEmp_First_Notification.cfm'
AND N.NOTIFICATION_ID = S.NOTIFICATION_ID
AND S.SCHEDULE_DATE = to_date('#thisDate#',
'mm/dd/yyyy')
</CFQUERY>
<!--- Get All Data required --->
<CFQUERY NAME="qGetData" DATASOURCE="#REQUEST.DSN#">
SELECT E.Wk_Email_Addr,
E.Emp_ID,
E.SSN,
E.First_Name,
E.Last_Name,
E.Middle_Name,
E.Org_Acronym,
S.Firstname as SUP_FIRST_NAME,
S.Lastname as SUP_LAST_NAME,
S.Middlename as SUP_MIDDLE_NAME,
S.Wk_EMail_Addr as SUP_EMAIL
FROM V_Nonvalidated E,
V_Supervisors S
WHERE E.Sup_ID = S.Emp_ID
AND LEAVE_YEAR = '#qGetNotification.Leave_Year#'
AND PAY_PERIOD = '#qGetNotification.Pay_Period#'
</CFQUERY>
<CFIF FINDNOCASE("[PAY PERIOD]",qGetNotification.EMAIL_MESSAGE,1) GT
0>
<CFSET NEW_MESSAGE =
#ReplaceNoCase(qGetNotification.EMAIL_MESSAGE,"[PAY
PERIOD]",qGetNotification.Pay_Period,"ALL")#>
<CFELSE>
<CFSET NEW_MESSAGE = #qGetNotification.EMAIL_MESSAGE#>
</CFIF>
<CFIF qGetData.recordcount GT 0>
<CFLOOP QUERY="qGetData">
<CFSET full_Name = "#qGetData.First_Name#
#qGetData.Last_Name#">
<CFIF FINDNOCASE("[EMP NAME]",NEW_MESSAGE,1) GT 0>
<CFSET EMP_MESSAGE = #ReplaceNoCase(NEW_MESSAGE,"[EMP
NAME]",full_name,"ALL")#>
<CFELSE>
<CFSET EMP_MESSAGE = #NEW_MESSAGE#>
</CFIF>
<CFMAIL TO="#tempEmailUser#" FROM="[EMAIL PROTECTED]"
SUBJECT="WEBTA: #qGetNotification.Subject#" CC="#tempEmailSup#"
server="mail.gao.gov" TIMEOUT="60">
#EMP_MESSAGE#
</CFMAIL>
</CFLOOP>
</CFIF>
Again basic code in my opinion:::::
>>> [EMAIL PROTECTED] 06/02/03 09:57AM >>>
Run into this all the time. The scheduled task was unable to complete
its
processing, and I have found it usually has something to do with the
code.
CF5 has poor error handling features on Linux, and problems with a
scheduled
task are often catastrophic.
What I see happening often is that a developer uses session variables
in
their scheduled task code. When they browse to the page, things seem to
work
fine, but the task craps out immediately without warning.
Unfortunately, these errors are never easy to track down. We use
fusebox
here, and often the problem starts far upstream from where the code we
are
trying to run lives. Always check the executive log, the error log,
the
application log, etc. because the errors can pop up all over the
place.
What you might want to do is:
1) Create a test harness. Have it fire off an email and run a simple
query
using simple but bulletproof code.
2) Build the harness out to include the code you are looking to run.
Keep a
close eye on the logs to see what is going wrong.
M
-----Original Message-----
From: Randell B Adkins [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 8:05 AM
To: CF-Talk
Subject: Signal 11 & CF Services?
Any idea what can cause an error:
Signal (11) - Aborting
This is in the server log and it occurs when we run a scheduled task
that
contains a QUERY and then a CFMAIL tag.
I can run this fine on our DEV box but our test and production boxes
will
abort with the Signal 11 error and restart the CF Services.
I can run CFQUERY events on the box without a problem as well as
CFMAIL
tags. However when combined together as a Scheduled Task, it bombs
out..
Anyone experience this or have any suggestions?
Platform:
CF5 Professional, Linux and Apache....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
