E-Mails Not Being Sent

There are no errors, most of the failed e-mails are not showing up in the log files. The queries returning e-mail addresses are working correctly. Most of the errors in the mail log file are there because the CF server couldn't connect to the mail server, should I talk to the sysadmin about this?

The code that generates and sends everything is about 950 lines long. Here is the e-mail part:
<cfmail to="#recipients#" cc="#cc#" from="#get_from.email_address#" bcc="#get_from.email_address#" subject="#dealer_info.pa_code# #trim(dealer_info.dealership_name)# #dateFormat(dateAdd('m',-1,now()),'mmmm')# #program# Report">
<cfmailparam file="#dealer_info.pa_code#_#trim(replace(dealer_info.dealership_name, '.','',"ALL"))#.html">
#attributes.text#
</cfmail>

After this code is executed I delete the attachment. Maybe it doesn't send if the attachment isn't available? Thoughts? If you want to see more code, let me know!

Thanks!

And one of my servers doesn't seem to have a mailsent.log file . . .

I will try that, thank you.

In addition, not all of the missing e-mails end up in the undeliverable mail log, but if I move the ones that DO exist in that folder to the spool folder then they are usually successfully sent. Is there a way to get the CF server to try to send e-mail messages more than once if they fail on the first try?

Thanks!

I am looking through our mail logs (mail.log and mailsent.log) on our servers, and neither of them have any errors sending mail the past few days, even though a lot of e-mails are missing. One of our servers doesn't even have a mailsent.log folder.

Both are set up to log "information" level error messages, which I think means it logs all mail message, and I have a checkmark to log all email messages sent by coldfusion.

Does anyone know where the errored e-mails might be going? How to get mailsent.log file on that one server?

How about tyring to send e-mail messages again if they fail the first time?

Thanks!

So this morning the hoopla really hit the fan.

All those missing e-mail were sent out at 3pm yesterday from one of our servers. The server that didn't have the mailsent.log file. All of a sudden it has the mailsent.log file.

It looks like a whole lot of this:
"Information","TID=1420","09/16/07","15:10:48","DBarnard@admi-usa.com,j-johnston@suddenlin kmail.com"
"Information","TID=1420","09/16/07","15:10:48","cnichols@admi-usa.com,tmiller@admi-usa.com "
"Information","TID=1420","09/16/07","15:10:48","rgilbert@admi-usa.com,tmiller@admi-usa.com "
"Information","TID=1420","09/16/07","15:10:48","cnichols@admi-usa.com,tmiller@admi-usa.com "
"Information","TID=1420","09/16/07","15:10:48","cnichols@admi-usa.com,cnichols@admi-usa.co m"
"Information","TID=1420","09/16/07","15:10:48","reports@admi-usa.com,jcampbell@admi-usa.co m"
"Information","TID=1420","09/17/07","08:08:30","rgilbert@admi-usa.com,kwiley@admi-usa.com"

And then in the mail.log file are some e-mail that didn't get sent, it looks like this:
"Error","TID=1420","09/16/07","15:08:23","Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\AB4.cfmail. SMTP server replied "Message is not RFC compliant" Moved file to C:\CFUSION\MAIL\undelivr\10B1.cfmail."
"Error","TID=1420","09/16/07","15:08:23","Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\ABB.cfmail. SMTP server replied "Message is not RFC compliant" Moved file to C:\CFUSION\MAIL\undelivr\10B2.cfmail."
"Error","TID=1420","09/16/07","15:08:23","Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\AC2.cfmail. SMTP server replied "Message is not RFC compliant" Moved file to C:\CFUSION\MAIL\undelivr\10B3.cfmail."
"Error","TID=1420","09/16/07","15:08:24","Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\BBC.cfmail. SMTP server replied "What? I don't understand that." Moved file to C:\CFUSION\MAIL\undelivr\10B4.cfmail."
"Error","TID=1420","09/16/07","15:08:25","Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\BCA.cfmail. SMTP server replied "Communication failure with mail server." Moved file to C:\CFUSION\MAIL\undelivr\10B5.cfmail."
"Error","TID=1420","09/16/07","15:08:26","Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\C53.cfmail. SMTP server replied "Communication failure with mail server." Moved file to C:\CFUSION\MAIL\undelivr\10B6.cfmail."
"Error","TID=1420","09/16/07","15:08:27","Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\C5E.cfmail. SMTP server replied "Communication failure with mail server." Moved file to C:\CFUSION\MAIL\undelivr\10B7.cfmail."

And it gets better. When I look in the UNDELIVR folder, those messages, that couldn't be sent at 3pm yesterday when all the other ones were sent, have a modified date the same as the date they were originally supposed to be sent out on. All the e-mails that were supposed to be sent out last week and were finally sent out yesterday have this same attribute.

Does anyone know what's going on?!

Thanks!

No, ColdFusion. Doesn't ColdFusion have it's own SMTP client? If not, we're using Microsoft SMTP client.

Looking back at server logs, the CF services restarted yesterday at 3pm.

Hrm . . .

Would it make sense that if the mail server was MIA for a few hours (which happened on September 6th), that the CF SMTP client would shut itself off and not function correctly until the CF services were restarted?

It says it can successfully reach our server. I think I tested this last week and it said it could connect then as well. However, how does that CF server test connectivity? Does it just ping or send a request to the mail server? If so, wouldn't this return successful if the mail server was actually on, but not repair the connection that would allow it to function normally?

Also, there was an error in the mail.log between the day the mail server was MIA and the day the services restarted and all the mail was sent. It said "Error in Unspool." This error message does not show up when Googled as a phrase and when Googled as a string a lot of irrelevant things, including something on Linsday Lohan show up . . . and I couldn't find it by searching the CF forums either.