DBmail is not sending email. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DBmail is not sending email.

I have set up the DBMail on SQL server 2005 and it was fine until two days earlier. the DBmail throw an exception and all the mail is queued.
here is the error. any advice is appreciated.
***************
Date7/2/2007 10:19:22 AM
LogDatabase Mail (Database Mail Log) Log ID637
Process ID5756
Last Modified7/2/2007 10:19:22 AM
Last Modified ByNT AUTHORITYSYSTEM Message
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: The Transaction not longer valid.
Data: System.Collections.ListDictionaryInternal
TargetSite: Void ValidateConnectionAndTransaction()
HelpLink: NULL
Source: DatabaseMailEngine StackTrace Information
===================
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.ValidateConnectionAndTransaction()
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.RollbackTransaction()
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.GetDataFromQueue(DataAccessAdapter da, Int32 lifetimeMinimumSec)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.ProcessQueueItems(String dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel loggingLevel)
http://support.microsoft.com/kb/928789 fyi and what is the service pack level on SQL? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
SQL server 2005 is RTM version.
Better to test and apply service pack 2 in this case, as they were many fixed compared to RTM.
Also check with a right click on your database mail icon in SSMS and try to send a test email. Check the configuration of the dbmail, also check whether you configured your Outlook client to use SMTP? If you didn’t then outlook is most likely using exchange. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Verify whether SMTP service is running —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
check for your mail account as well. This problem might occur when mail box is full
I feel by all means this may be a service pack problem as RTM version didn’t have few fixes and above exception &stack trace refers to the SMO which is SSMS part of it, fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
thanks for all your support.
I checked all the advice and cheked the SMTP servercis to be running. did not help me at all. Finally I requested to reboot the server and that took care of the issue. may be SMTP though looked like started may be it was hung or something.I am fine now
One good thing to check is to see if you can telnet to the smtp server (and no, you defintiely DON’T need the SMTP service for DBMail – it has nothing to do with it). If you get this problem again you can test your connection to the smtp server, open a command prompt, do telnet, at the prompt do o smtpserver.with.fqdn 25 (where 25 is the port) and check if it connects. Also review the database mail log – right click DBMail in SSMS and select View Database Mail Log This usually give you some more info.
Do you have any Antivirus or any antispyware software on this server, we have had such issues where we found out AV has stoppd the SMTP to load properly and similarly we have resolved by rebooting the server! Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>