January 7, 2009 at 8:31 am
Have anyone seen this in the DB Mail Log before?
Any ideas?
Thanks in advance.
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)
January 7, 2009 at 9:49 am
Check to see if you have an anti-virus or other product that is blocking port 25 on your machine.
January 7, 2009 at 9:55 am
I was able to send test email with no problem.
This is mainly from application.
Not sure what is 'Transaction is no more valid.'
January 7, 2009 at 10:00 am
Did you restart SQL server agent service after enabling the Database Mail?
January 7, 2009 at 10:04 am
Do you have any entries in the msdb.dbo.sysmail_event_log ?
January 7, 2009 at 10:26 am
The same msg is in the sysmail_event_log and I didnt restart SQL Server Agent.
Thanks.
January 7, 2009 at 10:36 am
Then restart the Sql Server agent. It is required to see the mail changes you made. It won't email to operators until after you restart the service.
January 7, 2009 at 10:38 am
Could you post the code that you are using to attempt sending the email?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply