Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

A delivery failure was reported using SMTP Delivery channel

  
   Database Help (Home) -> Notification Services RSS
Next:  Event View does not return Events while NSEvent T..  
Author Message
TechJunkie

External


Since: Aug 14, 2007
Posts: 7



(Msg. 1) Posted: Tue Aug 14, 2007 9:26 pm
Post subject: A delivery failure was reported using SMTP Delivery channel
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)
Hello Group.
I am trying to use Notification system to Deliver SMTP Emails.
The SMTP server is local and configured to use anonymous
Authentication.

The Distributor is running on the same box as the SMTP and all other
Notification services.
The Windows Service is running under Local System Account.

I am receiving this error over and over again,
I went through a lot of blogs and can't figure it out.
Please help me.

I am including a snippet of the ADF and ICF files
Thanks in advance

ICF Snippet

<DeliveryChannels>
<DeliveryChannel>
<DeliveryChannelName>SMTPServerAlertsDelivery</
DeliveryChannelName>
<ProtocolName>SMTP</ProtocolName>
<Arguments>
<Argument>
<Name>SmtpServer</Name>
<Value> ab-bcd-wer.Domain.COM</Value>
</Argument>
<Argument>
<Name>BodyEncoding</Name>
<Value>utf-16</Value>
</Argument>
</Arguments>
</DeliveryChannel>
</DeliveryChannels>

ADF Snippet

<NotificationClass>
<NotificationClassName>ABCD_AlertsNotifier</
NotificationClassName>
<Schema>
<Fields>
<Field>
<FieldName>ABCD_size</FieldName>
<FieldType>int</FieldType>
</Field>
<Field>
<FieldName>request_ABCD_size</FieldName>
<FieldType>int</FieldType>
</Field>
<Field>
<FieldName>ABCD_uid</FieldName>
<FieldType>numeric(18,0)</FieldType>
</Field>
</Fields>
</Schema>


<ContentFormatter>
<ClassName>XsltFormatter</ClassName>
<Arguments>
<Argument>
<Name>XsltBaseDirectoryPath</Name>
<Value>C:\alerts_db\Alerts\ABCDExternal_Alerts</Value>
</Argument>
<Argument>
<Name>XsltFileName</Name>
<Value>ABCDTransform.xslt</Value>
</Argument>

</Arguments>

</ContentFormatter>
<!--
<ClassName>ABCDDiscrepancyFormatter.cs</ClassName>
<AssemblyName>D:\DatabaseSQLServer2005\90\NotificationServices
\Alerts\AlertsContenFormatter\ABCDFormatter\bin\Debug
\ABCDFormatter.dll</AssemblyName>
<Arguments>
<Argument>
<Name>ABCDConnectionString</Name>
<Value>
Data Source=abcd;Initial
Catalog=abcd;user=abc;password=abc
</Value>
</Argument>

</Arguments>
-->

<Protocols>
<Protocol>
<ProtocolName>SMTP</ProtocolName>
<Fields>
<Field>
<FieldName>Subject</FieldName>
<SqlExpression>'For ABCD is Actual Team Size is:
' </SqlExpression>
</Field>
<Field>
<FieldName>BodyFormat</FieldName>
<SqlExpression>'html'</SqlExpression>
</Field>
<Field>
<FieldName>From</FieldName>
<SqlExpression>'abcd@domain.com'</SqlExpression>
</Field>
<Field>
<FieldName>Priority</FieldName>
<SqlExpression>'Normal'</SqlExpression>
</Field>
<Field>
<FieldName>To</FieldName>
<SqlExpression>DeviceName</SqlExpression>
</Field>
</Fields>

</Protocol>

<!-- <Protocol>
<ProtocolName>File</ProtocolName>
<Fields>
<Field>
<FieldName>ABCD_size</FieldName>
<FieldReference>ABCD_size</FieldReference>
</Field>
<Field>
<FieldName>request_ABCD_size</FieldName>
<FieldReference>request_ABCD_size</FieldReference>
</Field>
<Field>
<FieldName>sch000_uid</FieldName>
<FieldReference>sch000_uid</FieldReference>
</Field>
</Fields>
</Protocol> -->
</Protocols>
</NotificationClass>



Event Type: Error
Event Source: NotificationServices
Event Category: None
Event ID: 6043
Date: 8/14/2007
Time: 3:13:18 PM
User: N/A
Computer: ab-bcd-wer
Description:
A delivery failure was reported.
EventParameters:
Distributor ID: 1
Distributor Name: ab-bcd-wer
Delivery Channel Name: SMTPServerAlertsDelivery
Notification ID: 2
Notification Class Name: ABCDAlertsNotifier
Notification Status Info:
Notification Text:
Notification Sent Time: 08/14/2007 19:13:18

InstanceName: Alerts
ApplicationName: FTLCh
Component: Distributor
ComponentDetails: DistributorName: ab-bcd-wer
Thread: 45


For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

 >> Stay informed about: A delivery failure was reported using SMTP Delivery channel 
Back to top
Login to vote
Joe Webb1

External


Since: Apr 28, 2004
Posts: 118



(Msg. 2) Posted: Wed Aug 15, 2007 4:17 am
Post subject: Re: A delivery failure was reported using SMTP Delivery channel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Tue, 14 Aug 2007 21:26:29 +0000, TechJunkie wrote:

> Hello Group.
> I am trying to use Notification system to Deliver SMTP Emails.
> The SMTP server is local and configured to use anonymous
> Authentication.
>
> The Distributor is running on the same box as the SMTP and all other
> Notification services.
> The Windows Service is running under Local System Account.
>
> I am receiving this error over and over again,
> I went through a lot of blogs and can't figure it out.
> Please help me.
>
> I am including a snippet of the ADF and ICF files
> Thanks in advance
>
> ICF Snippet
>
> <DeliveryChannels>
> <DeliveryChannel>
> <DeliveryChannelName>SMTPServerAlertsDelivery</
> DeliveryChannelName>
> <ProtocolName>SMTP</ProtocolName>
> <Arguments>
> <Argument>
> <Name>SmtpServer</Name>
> <Value> ab-bcd-wer.Domain.COM</Value>
> </Argument>
> <Argument>
> <Name>BodyEncoding</Name>
> <Value>utf-16</Value>
> </Argument>
> </Arguments>
> </DeliveryChannel>
> </DeliveryChannels>
>
> ADF Snippet
>
> <NotificationClass>
> <NotificationClassName>ABCD_AlertsNotifier</
> NotificationClassName>
> <Schema>
> <Fields>
> <Field>
> <FieldName>ABCD_size</FieldName>
> <FieldType>int</FieldType>
> </Field>
> <Field>
> <FieldName>request_ABCD_size</FieldName>
> <FieldType>int</FieldType>
> </Field>
> <Field>
> <FieldName>ABCD_uid</FieldName>
> <FieldType>numeric(18,0)</FieldType>
> </Field>
> </Fields>
> </Schema>
>
>
> <ContentFormatter>
> <ClassName>XsltFormatter</ClassName>
> <Arguments>
> <Argument>
> <Name>XsltBaseDirectoryPath</Name>
> <Value>C:\alerts_db\Alerts\ABCDExternal_Alerts</Value>
> </Argument>
> <Argument>
> <Name>XsltFileName</Name>
> <Value>ABCDTransform.xslt</Value>
> </Argument>
>
> </Arguments>
>
> </ContentFormatter>
> <!--
> <ClassName>ABCDDiscrepancyFormatter.cs</ClassName>
> <AssemblyName>D:\DatabaseSQLServer2005\90\NotificationServices
> \Alerts\AlertsContenFormatter\ABCDFormatter\bin\Debug
> \ABCDFormatter.dll</AssemblyName>
> <Arguments>
> <Argument>
> <Name>ABCDConnectionString</Name>
> <Value>
> Data Source=abcd;Initial
> Catalog=abcd;user=abc;password=abc
> </Value>
> </Argument>
>
> </Arguments>
> -->
>
> <Protocols>
> <Protocol>
> <ProtocolName>SMTP</ProtocolName>
> <Fields>
> <Field>
> <FieldName>Subject</FieldName>
> <SqlExpression>'For ABCD is Actual Team Size is:
> ' </SqlExpression>
> </Field>
> <Field>
> <FieldName>BodyFormat</FieldName>
> <SqlExpression>'html'</SqlExpression>
> </Field>
> <Field>
> <FieldName>From</FieldName>
> <SqlExpression>'abcd@domain.com'</SqlExpression>
> </Field>
> <Field>
> <FieldName>Priority</FieldName>
> <SqlExpression>'Normal'</SqlExpression>
> </Field>
> <Field>
> <FieldName>To</FieldName>
> <SqlExpression>DeviceName</SqlExpression>
> </Field>
> </Fields>
>
> </Protocol>
>
> <!-- <Protocol>
> <ProtocolName>File</ProtocolName>
> <Fields>
> <Field>
> <FieldName>ABCD_size</FieldName>
> <FieldReference>ABCD_size</FieldReference>
> </Field>
> <Field>
> <FieldName>request_ABCD_size</FieldName>
> <FieldReference>request_ABCD_size</FieldReference>
> </Field>
> <Field>
> <FieldName>sch000_uid</FieldName>
> <FieldReference>sch000_uid</FieldReference>
> </Field>
> </Fields>
> </Protocol> -->
> </Protocols>
> </NotificationClass>
>
>
>
> Event Type: Error
> Event Source: NotificationServices
> Event Category: None
> Event ID: 6043
> Date: 8/14/2007
> Time: 3:13:18 PM
> User: N/A
> Computer: ab-bcd-wer
> Description:
> A delivery failure was reported.
> EventParameters:
> Distributor ID: 1
> Distributor Name: ab-bcd-wer
> Delivery Channel Name: SMTPServerAlertsDelivery
> Notification ID: 2
> Notification Class Name: ABCDAlertsNotifier
> Notification Status Info:
> Notification Text:
> Notification Sent Time: 08/14/2007 19:13:18
>
> InstanceName: Alerts
> ApplicationName: FTLCh
> Component: Distributor
> ComponentDetails: DistributorName: ab-bcd-wer
> Thread: 45
>
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.


Try replacing the fully qualified server name with localhost. Also, there
used to be a bug in the .net framework that required the service account
to run as admin when relaying email through the local machine. Try
elevating the service account's permissions.

HTH...

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

 >> Stay informed about: A delivery failure was reported using SMTP Delivery channel 
Back to top
Login to vote
TechJunkie

External


Since: Aug 14, 2007
Posts: 7



(Msg. 3) Posted: Thu Aug 16, 2007 3:32 pm
Post subject: Re: A delivery failure was reported using SMTP Delivery channel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks Joe,
I followed all the steps you specified,
but still receiving the same error.
Is there anyway to debug this issue step by step via some debugger.
Dear Joe and group.
What are the actual stored procs, dll's etc that sql server uses to
deliver notifications via SMTP.
Is there any way to step through the execution of SQL Server CLR
module.
I guess Some of the functionality in New SQL Server are dll's on CLR
Please help me .
Thanks,
Kiran
 >> Stay informed about: A delivery failure was reported using SMTP Delivery channel 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
passing changed parameters to SP in Customed delivery prot.. - Hi, I have created a customed delivery protocol for sending notifications to the DB using a stored procedure. I used the code shown in : http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.notificatio..

Variable in SMTP Protocol - I would like to include a variable in the Subject field of an email sent from Notification Services. Is there a way to do this? What is the limitation of the <SQLExpression></SQLExpression> tag in the Protocol? Is this where I would grab m...

Failure commiting Event Batches - i'm using a non-hosted event provider to provide event batches to a NS Application. it works well, but sometimes it throws an exception with the message "failed to commit the events batch". i am using the EventCollector obeject in a windows se...

Is the trace flag (8720) needed? - I'm converting SQL7 to SQL2K. The database scripts have an statement: DBCC TRACEON (8720) It's from third party vendor for previous database build or update. I'd like to know if the trace flag 8720 still is needed for SQL 2K or not. If not, I'm going to....

High-level requirement for a pub-sub app - Thank you, Shyam, for your answer to my question regarding the distributor and delivery protocol objects. Your explanation was very helpful to me. Now I have another question for you and the group. I've been given a rough sketch of a possible futur...
   Database Help (Home) -> Notification Services All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]