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

Database Mail Error Expand / Collapse
Author
Message
Posted Friday, August 08, 2008 12:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 14, 2011 5:41 AM
Points: 2, Visits: 39
WHEN I SEND MAIL THROUGH DATABASE MAIL THEN THREE ERRORS I GOT IN [msdb].[dbo].[sysmail_log] BUT MAIL IS RECEIVED BY THE USER.


ERROR-1
---------

Invalid XML message format received on the ExternalMailQueue.

conversation_handle: 1751E177-8C64-DD11-991D-001A644FD5EE.

message_type_name: {//www.microsoft.com/databasemail/messages}SendMailStatus.
message body: <responses:SendMail xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://schemas.microsoft.com/databasemail/responses ResponseTypes.xsd" xmlns:responses="http://schemas.microsoft.com/databasemail/responses"> .

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

ERROR-2
---------

1) Exception Information ===================
Exception Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection
Class: 16
LineNumber: 1
Number: 6602
Procedure: sp_xml_preparedocument
Server: ETEC-SQL
State: 2
Source: .Net SqlClient Data Provider ErrorCode: -2146232060
Message: The error description is 'Switch from current encoding to specified encoding not supported.'. The XML parse error 0xc00ce56f occurred on line number 1, near the XML text " ".
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.SqlInternalConnection.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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.PostResponse(Response r, Guid convHandle) at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.PostResponseIfNeeded(MailInfo mi, Response r) at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)


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

ERROR-3
---------

Invalid XML message format received on the ExternalMailQueue.
conversation_handle: 1451E177-8C64-DD11-991D-001A644FD5EE.
message_type_name: {//www.microsoft.com/databasemail/messages}SendMailStatus.
message body: ?????????•??????????????????????????????????????????????•????????????????????????????????????????????=????????????????????????????????????†???????††?????????•??????????†?????????•?????????????•???????????????†????????????????????†????????????•???????????? .

Post #548884
Posted Thursday, September 18, 2008 2:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 23, 2010 10:46 AM
Points: 327, Visits: 35
I'm getting this too - on a sql agent notification. Did you ever find out what was wrong?

Cheers,

Matt
Post #571560
Posted Thursday, January 27, 2011 11:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 15, 2012 1:15 PM
Points: 3, Visits: 27
I am getting this error as well. I get it when running msdb.dbo.sp_send_dbmail. It doesn't seem to matter if I switch the @body_format from 'HTML' to 'TEXT' either.

Did you get this resolved?
I did find a stored proc that was out of date compared to our other production servers. But (redgate)SQL Compare now shows them all the same.
Post #1054775
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse