Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Database Mail Error Expand / Collapse
Author
Message
Posted Thursday, October 8, 2009 8:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:57 AM
Points: 204, Visits: 704
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)



Post #800068
Posted Thursday, October 8, 2009 9:14 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:08 AM
Points: 2,726, Visits: 1,109
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.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #800095
Posted Thursday, October 8, 2009 9:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:57 AM
Points: 204, Visits: 704
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.



Post #800144
Posted Thursday, October 8, 2009 9:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:57 AM
Points: 204, Visits: 704
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



Post #800146
Posted Thursday, October 8, 2009 9:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 12, 2010 8:40 AM
Points: 190, Visits: 472
try this first, is this a cluster environment if so this can be little more tricky then normal?

http://social.msdn.microsoft.com/Forums/en/sqlnotificationservices/thread/0f2fe589-65fb-4462-812e-a7fddcfcc017



Post #800152
Posted Thursday, October 8, 2009 10:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 12, 2010 8:40 AM
Points: 190, Visits: 472
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' ;



Post #800156
Posted Thursday, October 8, 2009 1:52 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:57 AM
Points: 204, Visits: 704
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.



Post #800320
Posted Thursday, October 8, 2009 2:31 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 12, 2010 8:40 AM
Points: 190, Visits: 472
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...



Post #800361
Posted Thursday, October 8, 2009 3:36 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 7:13 AM
Points: 13, Visits: 185
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
Post #800404
Posted Thursday, October 8, 2009 8:32 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:54 AM
Points: 870, Visits: 2,114
The other option you may have to check is, make sure that port 25 is enabled...sometimes the antivirus may disable this port...
Post #800471
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse