December 24, 2010 at 10:45 pm
when i am sending DBmail System showing the following error
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)
I have deleted and recreated the account and the profile.
still showing same error Msg.Plz help ..
December 26, 2010 at 9:46 am
Was it working earlier? If yes, you can try stopping DBMail and starting it again.
exec sysmail_stop_sp
go
exec sysmail_start_sp
go
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 26, 2010 at 10:59 pm
it is working earlier
I have done the same still same error is occurring..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply