Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL 2005 Database mail problems - Please help

152 views
Skip to first unread message

Javier

unread,
Feb 19, 2008, 1:31:58 PM2/19/08
to
Hi,

I have a big problem with a production server, specifically with database
mail.

Last week it was working perfect but then it suddenly stops working.

The first error message is:

Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start
Database Mail.

After I start dbmail with sysmail_start_sp it goes down in 10 seconds. When
I check the dbmail log, I found these messages (Message: The read on the
database failed. Reason: The error description is 'Whitespace is not allowed
at this location.'.)

I deleted and recreated the account and the profile, but still the same
problem

Any idea?

-- Javier

Warning message

Date 2/19/2008 6:10:05 PM

Log Database Mail (Database Mail Log)

Log ID 452

Process ID 2376

Last Modified 2/19/2008 6:10:05 PM

Last Modified By DOMAIN\sql2005service

Message

1) Exception Information

===================

Exception Type:
Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException

Message: The read on the database failed. Reason: The error description is
'Whitespace is not allowed at this location.'.

Data: System.Collections.ListDictionaryInternal

TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.QueueItem
GetQueueItemFromCommand(System.Data.SqlClient.SqlCommand)

HelpLink: NULL

Source: DatabaseMailEngine

StackTrace Information

===================

at
Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.QueueDataReader.GetQueueItemFromCommand(SqlCommand
c)

at
Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.QueueDataReader.GetQueueData(Int32
receiveTimeoutSec)

at
Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.GetDataFromQueue(DataAccessAdapter
da, Int32 lifetimeMinimumSec)

2) Exception Information

===================

Exception Type: System.Data.SqlClient.SqlException

Errors: System.Data.SqlClient.SqlErrorCollection

Class: 16

LineNumber: 1

Number: 6602

Procedure: sp_xml_preparedocument

Server: LIVSQL01

State: 2

Source: .Net SqlClient Data Provider

ErrorCode: -2146232060

Message: The error description is 'Whitespace is not allowed at this
location.'.

Data: System.Collections.ListDictionaryInternal

TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)

HelpLink: NULL

StackTrace Information

===================

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)

at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader()

at
Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.ExecuteReader(SqlCommand
command)

Error message

Date 2/19/2008 6:10:17 PM

Log Database Mail (Database Mail Log)

Log ID 457

Process ID 2376

Last Modified 2/19/2008 6:10:17 PM

Last Modified By DOMAIN\sql2005service

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)


Tibor Karaszi

unread,
Feb 20, 2008, 10:43:17 AM2/20/08
to
My guess is that you have hit a bug in SQL Server. I would first Google for the problem, second
apply most recent hotfix and/or CU. If that doesn't handle it, I would open a case with MS Support.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Javier" <ma...@hotmail.com> wrote in message news:%23eUkvWy...@TK2MSFTNGP06.phx.gbl...

0 new messages