OVH Cloud OVH Cloud

database mail XML Problem ? SQL 2005

2 réponses
Avatar
Ch.
Hi,

when i use a procedure msdb.dbo.sp_send_dbmail or i test email by entreprise
manager "test end mail"
or i use alert for receive the message by mail !

i have this merror message in the log ?

i need your help !
i have SQL 2005 with SP1 and patch (hotfix)

Invalid XML message format received on the ExternalMailQueue.
conversation_handle: CA260D86-A33C-DB11-80FD-000000000000.
message_type_name:
{//www.microsoft.com/databasemail/messages}SendMailStatus. message body:
<?xml version="1.0" encoding="utf-8"?>
<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">
<Information>
<Failure Message="The mail could not be sent to the recipients because
of the mail server failure. (Sending Mail using Account 1
(2006-09-05T07:58:19). Exception Message: Could not connect to mail server.
(Hôte inconnu).&#xD;&#xA;)" />
</Information>
<MailItemId Id="208" />
<SentStatus Status="3" />
<SentAccountId Id="0" />
<SentDate Date="2006-09-05T07:58:19" />
<CallingProcess Id="3304" />
</responses:SendMail>

2 réponses

Avatar
Ch.
Désole je me croyais sur le forum us !!
ben la meme chose en francais car j'ai rien trouvé la dessus si vous avez
une idée !!

Bonjour,
que j'utilise la procedure stockée msdb.dbo.sp_send_dbmail ou le test
d'envoi de mail
ou le parametrage d'une alerte pour recevoir un maisl apres ule lancement
d'un service !

dans le log j'ai toujours l'erreur suivante !

je suis avec SQL 2005 SP1 et les hotfix ...



Invalid XML message format received on the ExternalMailQueue.
conversation_handle: CA260D86-A33C-DB11-80FD-000000000000.
message_type_name:
{//www.microsoft.com/databasemail/messages}SendMailStatus. message body:
<?xml version="1.0" encoding="utf-8"?>
<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">
<Information>
<Failure Message="The mail could not be sent to the recipients because
of the mail server failure. (Sending Mail using Account 1
(2006-09-05T07:58:19). Exception Message: Could not connect to mail server.
(Hôte inconnu).&#xD;&#xA;)" />
</Information>
<MailItemId Id="208" />
<SentStatus Status="3" />
<SentAccountId Id="0" />
<SentDate Date="2006-09-05T07:58:19" />
<CallingProcess Id="3304" />
</responses:SendMail>







"Ch." a écrit dans le message de news:
OdyX$
Hi,

when i use a procedure msdb.dbo.sp_send_dbmail or i test email by
entreprise manager "test end mail"
or i use alert for receive the message by mail !

i have this merror message in the log ?

i need your help !
i have SQL 2005 with SP1 and patch (hotfix)

Invalid XML message format received on the ExternalMailQueue.
conversation_handle: CA260D86-A33C-DB11-80FD-000000000000.
message_type_name:
{//www.microsoft.com/databasemail/messages}SendMailStatus. message body:
<?xml version="1.0" encoding="utf-8"?>
<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">
<Information>
<Failure Message="The mail could not be sent to the recipients because
of the mail server failure. (Sending Mail using Account 1
(2006-09-05T07:58:19). Exception Message: Could not connect to mail
server. (Hôte inconnu).&#xD;&#xA;)" />
</Information>
<MailItemId Id="208" />
<SentStatus Status="3" />
<SentAccountId Id="0" />
<SentDate Date="2006-09-05T07:58:19" />
<CallingProcess Id="3304" />
</responses:SendMail>




Avatar
Ch.
j'ai trouvé il faut appliquer les hotfix apres le sp1 et surtout
parametrer l'agent pour pouvoir avoir des mails sur les alertes et sur les
jobs surtout !

@+



"Ch." a écrit dans le message de news:

Désole je me croyais sur le forum us !!
ben la meme chose en francais car j'ai rien trouvé la dessus si vous avez
une idée !!

Bonjour,
que j'utilise la procedure stockée msdb.dbo.sp_send_dbmail ou le test
d'envoi de mail
ou le parametrage d'une alerte pour recevoir un maisl apres ule lancement
d'un service !

dans le log j'ai toujours l'erreur suivante !

je suis avec SQL 2005 SP1 et les hotfix ...



Invalid XML message format received on the ExternalMailQueue.
conversation_handle: CA260D86-A33C-DB11-80FD-000000000000.
message_type_name:
{//www.microsoft.com/databasemail/messages}SendMailStatus. message body:
<?xml version="1.0" encoding="utf-8"?>
<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">
<Information>
<Failure Message="The mail could not be sent to the recipients because
of the mail server failure. (Sending Mail using Account 1
(2006-09-05T07:58:19). Exception Message: Could not connect to mail
server.
(Hôte inconnu).&#xD;&#xA;)" />
</Information>
<MailItemId Id="208" />
<SentStatus Status="3" />
<SentAccountId Id="0" />
<SentDate Date="2006-09-05T07:58:19" />
<CallingProcess Id="3304" />
</responses:SendMail>







"Ch." a écrit dans le message de news:
OdyX$
Hi,

when i use a procedure msdb.dbo.sp_send_dbmail or i test email by
entreprise manager "test end mail"
or i use alert for receive the message by mail !

i have this merror message in the log ?

i need your help !
i have SQL 2005 with SP1 and patch (hotfix)

Invalid XML message format received on the ExternalMailQueue.
conversation_handle: CA260D86-A33C-DB11-80FD-000000000000.
message_type_name:
{//www.microsoft.com/databasemail/messages}SendMailStatus. message body:
<?xml version="1.0" encoding="utf-8"?>
<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">
<Information>
<Failure Message="The mail could not be sent to the recipients because
of the mail server failure. (Sending Mail using Account 1
(2006-09-05T07:58:19). Exception Message: Could not connect to mail
server. (Hôte inconnu).&#xD;&#xA;)" />
</Information>
<MailItemId Id="208" />
<SentStatus Status="3" />
<SentAccountId Id="0" />
<SentDate Date="2006-09-05T07:58:19" />
<CallingProcess Id="3304" />
</responses:SendMail>