October 8, 2009 at 8:40 am
1) Exception Information ===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: Mail configuration information could not be read from the database.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account
GetAccount(Int3
2) HelpLink: NULL Source: DatabaseMailEngine
StackTrace Information ===================
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation
(Object o) 2) Exception Information ===================
Exception Type: System.IndexOutOfRangeException
Message: timeout Data: System.Collections.ListDictionaryInternal
TargetSite: Int32 GetOrdinal(System.String) HelpLink: NULL Source: System.Data
StackTrace Information ===================
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.
GetAccount(Int32 accountID)
October 8, 2009 at 9:14 am
jude-32296 (10/8/2009)
1) Exception Information ===================Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: Mail configuration information could not be read from the database.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account
GetAccount(Int3
2) HelpLink: NULL Source: DatabaseMailEngine
StackTrace Information ===================
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation
(Object o) 2) Exception Information ===================
Exception Type: System.IndexOutOfRangeException
Message: timeout Data: System.Collections.ListDictionaryInternal
TargetSite: Int32 GetOrdinal(System.String) HelpLink: NULL Source: System.Data
StackTrace Information ===================
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.
GetAccount(Int32 accountID)
Thanks for posting the error, what was the task that run that caused this error. can you send a test mail. i take it that database mail is enabled, what is in the database mail log. and i take it that you set up the mail profile and the security as well.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 8, 2009 at 9:54 am
Everything is enabled, it was a test email & it says "mail queued", but doesn't send & I find the error that I posted.
This is a dev instance, the base instance works. Interestingly, I have a dev instance on another server & it works. I tried to set this up exactly as the base instance, using a different account name, but every other parameter the same to no avail.
October 8, 2009 at 9:55 am
Thank you for replying by the way...
You mentioned security setup, and perhaps this could be my issue on the instance. Can you tell me exactly what to verify on the instance?
thx
jude
October 8, 2009 at 9:58 am
try this first, is this a cluster environment if so this can be little more tricky then normal?
October 8, 2009 at 10:08 am
try restarting sql server agent.....if that does not work get rid of the profile and account restart AGENT and then re add everything. I have had the same problem in the past. worked everywhere except on one box,everything was the same, looked it over and over and double checked still did not work.
finally blew it away then recreated and it worked, other have had the same issue after doing some reading.
sometimes its easier to trouble shoot if use the script after you get it set up as well, that s after you have your profile and account set up
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Your_Profile_goes hear',
@recipients = 'danw@Adventure-Works.com',
@body = 'The stored procedure finished successfully.',
@subject = 'Automated Success Message' ;
October 8, 2009 at 1:52 pm
Thanx again.
I tried everything you suggested & when I use script it goes to "mail queued", but looking in the log the exception error message I posted earlier is still the problem.
October 8, 2009 at 2:31 pm
my only other suggestion is google
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)
you will see many issues related, some are close some are not.....I finnaly gave up on one my servers, but all the rest worked without a hitch....during my reading there were suggestion that you have sp3.
Good luck...
October 8, 2009 at 3:36 pm
I had a similar problem with SQL2005 Standard DBMail on a Windows 2008 cluster after applying SP3.
You might need to manually rerun the script "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\install\sysdbupg.sql".
Adjust the path as necessary.
Hope that helps, but it may be a solution specific to a problem with DBMail for SQL2005 on a Windows 2008 cluster.
Dale
October 8, 2009 at 8:32 pm
The other option you may have to check is, make sure that port 25 is enabled...sometimes the antivirus may disable this port...
October 9, 2009 at 7:28 am
Thanx.....port 25 is enabled, still throws the same error. Can I stop/start the instance without affecting the base instance? Does that even make sense to do? I stopped/started the agent several times to no avail, have followed every suggestion I can find & am still puzzled by why the base instance works & the 2nd instance does not.
October 9, 2009 at 7:52 am
Take a look at this other thread and see if the steps outlined in the referenced blog apply to your troubles here.
http://www.sqlservercentral.com/Forums/Topic763709-146-1.aspx
http://paradisj.blogspot.com/2008/08/sql-server-2005-database-mail-in.html
Dale
October 9, 2009 at 12:04 pm
Ok, so the exception error is no longer present, but now it says mail configuration information cannot be read from the database..timeout
October 9, 2009 at 12:09 pm
That's the same error I was able to resolve by manually running that update script. Check that other thread again.
Thanks,
Dale
October 9, 2009 at 12:48 pm
One quick question on running that update script, this problem is on an instance & the base instance is working fine. Will running this script have any impact on the base instance ? It's safe for all my instances on that box?
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply