Groups | Blog | Home
all groups > sql server notification services > august 2007 >

sql server notification services : A delivery failure was reported using SMTP Delivery channel


TechJunkie
8/14/2007 9:26:29 PM
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.
Joe Webb
8/15/2007 4:17:18 AM
[quoted text, click to view]


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
TechJunkie
8/16/2007 3:32:21 PM

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

AddThis Social Bookmark Button