| Author |
Topic |
|
dirtydavey
Yak Posting Veteran
80 Posts |
 Posted - 2008-06-06 : 11:43:39
|
| Hi All,I am going made here. I set up database mail on a 2005 box. It was working fine, untill I needed to reboot it. Now it does not.If I run a test with 2000 it works fine. However 2005 does not.I go to the test mail bit and it says its sent, but it never turns up. So I ran:-SELECT * FROM msdb.dbo.sysmail_event_logAnd I get the fowwloing error:-259 error 2008-06-06 16:38:24.493 Could not retrieve item from the queue. 5708 NULL NULL 2008-06-06 16:38:24.493 UK_domain\USERAny ideas at all would be gratfull aprisiated!!!ThanksDaveDave Dunckley says there is a law for the rich and a law for the poor and a law for Dirty Davey. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2008-06-06 : 12:07:14
|
| Hi,Thanks for that! Yeah I have seen them pages and followed it, but still does not work.For me no mail ever comes!Dave Dunckley says there is a law for the rich and a law for the poor and a law for Dirty Davey. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-06 : 13:43:56
|
| Did you restart SQL agent service? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-07 : 00:01:28
|
| Is mail server running? |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2008-06-09 : 05:41:20
|
| Hi guys,Yeah the mail server is running fine. I can mail from an sql 2000 instance on the box no problem.Also yeah I have tryed restarting the agent. Not sure what else to do?!Any ideas?DaveDave Dunckley says there is a law for the rich and a law for the poor and a law for Dirty Davey. |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2008-06-09 : 05:56:12
|
| Ok fixed it!Its quiter strange! I removed all settings. And then added it back with the slef sma esettings. Strange!Dave Dunckley says there is a law for the rich and a law for the poor and a law for Dirty Davey. |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2008-06-12 : 09:56:57
|
| Ok this is strange! It worked for two days, in witch time I never even used the server, and now:- 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)What is doing this? I can remove it and start again, but I bet it will happen again.Dave Dunckley says there is a law for the rich and a law for the poor and a law for Dirty Davey. |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2008-06-12 : 10:50:54
|
| Ok got it!The job was to send me the disk space in an email of all my servers. But the test box it was running on, kida run out. WoopS!Mail stops working when disk space runs out!Dave Dunckley says there is a law for the rich and a law for the poor and a law for Dirty Davey. |
|
|
|
|
database mail