|
|
|
|
Notification Email Setup
Hi Everyone,
I was wondering if you could help me with an idiot proof
guide on how to configure NS to use SMTP.
I have performed the following steps:
1. Created a subscriber with a device of SMTP called
EmailChannel.
2. Included a SMTP Delivery Channel in the appConfig.xml file:
EmailChannel
SMTP
SmtpServer
HIZZSW01
BodyEnc
Thu, 13 Jan 2005 09:26:27 -0800
"John Mc"
|
Re: Notification Email Setup
Hi Colin,
Thanks for that, unfortunatley it all checks out ok. The
subscriber and device names are bother present and correct.
I'm convinced I've missed something out along the way.
I've looked in the Managment -> SQL Server Logs -> Current,
but theres nothing in there.
I have just found that in the NSProtocol table, that SMTP
has a null value for both the ClassName and AssemblyName
columns, is this correct?
This email notification is a extension of my original
notification s
Fri, 14 Jan 2005 02:05:13 -0800
"John Mc"
|
Re: Notification Email Setup
When the status code is 'undone', it is often because of one of the
following issues:
- The distributor is not enabled ('nscontrol status -n ' for
component status)
- If the fields in the notification are unknown,
it can cause a silent failure in notification delivery, because no
distributor element will pick up the notification. Compare the
NSSubscriberDeviceView in the instance database with the notification
produced in the application database to verify this hypothesis.
Finally, check for any error messages in the event log which could indicate
problems running the distributor.
If you are still unable to find the source of the problem, we can try some
other tacks!
- Colin Meek [MSFT]
-
Thu, 13 Jan 2005 09:47:23 -0800
"Colin Meek [MSFT]"
|
Re: Notification Email Setup
BTW, I forgot to say that we're using a Virtual SMTP
service to forward on the emails to our exchange server.
And that a subscriber will have two devices, one will go
out via email, the other uses the existing route that works.
Thanks,
John
>-----Original Message-----
>Hi Colin,
>
>Thanks for that, unfortunatley it all checks out ok. The
>subscriber and device names are bother present and correct.
> I'm convinced I've missed something ou
Fri, 14 Jan 2005 03:57:45 -0800
"John Mc"
|
Re: Notification Email Setup
After more poking around, I think the Deliver Status shown
by my "NSBobNotificationsSMTPNotifications" view is
actually "Delivery never attempted: first try pending", not
"undone".
Do I have to enable SMTP somehow? As I thought I only had
to give it a servername...
>-----Original Message-----
>BTW, I forgot to say that we're using a Virtual SMTP
>service to forward on the emails to our exchange server.
Fri, 14 Jan 2005 07:15:26 -0800
"John Mc"
|
Re: Notification Email Setup
Hi John -
The ClassName and AssemblyName fields in the NSProtocols table of the
NSMain database are used for custom protocols and the fact
that they are NULL for the File and SMTP protocols shouldn't be causing
you a problem.
Do you have the SMTP Service running on the box? If so, you can try
omitting the SmtpServer argument in the instance config file for the
EmailChannel. It should default to localhost and send the notification
that way. (You can also simply replace the existing value for the
SmtpServer with localhost) If it works, then you know it's a problem
with connecting to the email server. If not, then you'll know it's
somewhere in NS.
You can also try specifying an IP address in the SmtpServer argument
rather than a hostname - that'll help determine if it's a name
resolution issue.
HTH...
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
John Mc wrote:
> After more poking around, I think the Deliver Status shown
> by my "NSBobNotificationsSMTPNotifications" view is
> actually "Delivery never attempted: first try pending", not
> "undone".
>
> Do I have to enable SMTP somehow? As I thought I only had
> to give it a servername...
>
>
>>-----Original Message-----
>>BTW, I forgot to say that we're using a Virtual SMTP
>>service to forward on the emails to our exchange server.
>>
>>And that a subscriber will have two devices, one will go
>>out via email, the other uses the existing route that works.
>>
>>Thanks,
>>John
>>
>>
>>>-----Original Message-----
>>>Hi Colin,
>>>
>>>Thanks for that, unfortunatley it all checks out ok. The
>>>subscriber and device names are bother present and correct.
>>>I'm convinced I've missed something out along the way.
>>>
>>>I've looked in the Managment -> SQL Server Logs -> Current,
>>>but theres nothing in there.
>>>
>>>I have just found that in the NSProtocol table, that SMTP
>>>has a null value for both the ClassName and AssemblyName
>>>columns, is this correct?
>>>
>>>This email notification is a extension of my original
>>>notification system that delivers messages fine. So I can
>>>prove the distributors are up and running by triggering an
>>>event. The first notification is generated quite happily,
>>>the second gets the "undone" status :(
>>>
>>>A Device entry looks like this for email:
>>>
>>>SubcriberId : Bob
>>>Enabled : 1
>>>Created : 13/01/2005 17:03:29
>>>Updated : 13/01/2005 17:03:29
>>>DeviceName : SMTP
>>>DeviceTypeName : SMTP
>>>DeviceAddress : Bob@here.com
>>>DeliveryChannelName : EmailChannel
>>>
>>>So whats next to try? :)
>>>Thanks,
>>>J
>>>
>>>
>>>
>>>>-----Original Message-----
>>>>When the status code is 'undone', it is often because of
>>>
>>>one of the
>>>
>>>>following issues:
>>>>
>>>>- The distributor is not enabled ('nscontrol status -n
>>>
>>>' for
>>>
>>>>component status)
>>>>- If the fields in the
>>>
>>>notification are unknown,
>>>
>>>>it can cause a silent failure in notification delivery,
>>>
>>>because no
>>>
>>>>distributor element will pick up the notification.
>>
>>Compare the
>>
>>>>NSSubscriberDeviceView in the instance database with the
>>>
>>>notification
>>>
>>>>produced in the application database to verify this
>>>
>>>hypothesis.
>>>
>>>>Finally, check for any error messages in the event log
>>>
>>>which could indicate
>>>
>>>>problems running the distributor.
>>>>
>>>>If you are still unable to find the source of the problem,
>>>
>>>we can try some
>>>
>>>>other tacks!
>>>>
>>>>- Colin Meek [MSFT]
>>>>
>>>>--
>>>>This posting is provided "AS IS" with no warranties, and
>>>
>>>confers no rights.
>>>
>>>>Use of included script samples are subject to the terms
>>>
>>>specified at
>>>
>>>>http://www.microsoft.com/info/cpyright.htm.
>>>>
>>>>Please do not send e-mail directly to this alias. This
>>>
>>>alias is for
>>>
>>>>newsgroup purposes only.
>>>>--
>>>>
>>>>"John Mc" wrote in
>>>
>>>message
>>>
>>>>news:087c01c4f995$0383a920$a301280a@phx.gbl...
>>>>
>>>>>Hi Everyone,
>>>>>
>>>>>I was wondering if you could help me with an idiot proof
>>>>>guide on how to configure NS to use SMTP.
>>>>>
>>>>>I have performed the following steps:
>>>>>
>>>>>1. Created a subscriber with a device of SMTP called
>>>>>EmailChannel.
>>>>>
>>>>>2. Included a SMTP Delivery Channel in the appConfig.xml
>>>
>>>file:
>>>
>>>>>
>>>>> EmailChannel
>>>>> SMTP
>>>>>
>>>>>
>>>>> SmtpServer
>>>>> HIZZSW01
>>>>>
>>>>>
>>>>> BodyEncoding
>>>>> utf-16
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>3. Included a SMTP protocol in the Notification class in
>>>>>the addADF.xml:
>>>>>
>>>>> SMTP
>>>>>
>>>>>
>>>>> Subject
>>>>> 'The ' + ProjectName +
>>>>>' has been ' + Action
>>>>>
>>>>>
>>>>> From
>>>>>
>>>>>'notifications@home.com'
>>>>>
>>>>>
>>>>> To
>>>>> DeviceAddress
>>>>>
>>>>>
>>>>> Priority
>>>>> 'Normal'
>>>>>
>>>>>
>>>>> BodyFormat
>>>>> 'html'
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>So everytime the notification is generated, it's finishing
>>>>>with an "undone" status. What am I doing wrong? How do I
>>>>>get into the debug of the NS? What have I missed out?
>>>>>
>>>>>Thanks,
>>>>>John
>>>>
>>>>
>>>>.
>>>>
>>>
>>>.
>>>
>>
>>.
>>
Fri, 14 Jan 2005 10:55:27 -0600
Joe Webb
|
Re: Notification Email Setup
John --
Log entries for NS appear in the event log (accessed using eventvwr), not in
the SQL Server log.
Could you take a look at the NSDistributorWorkItems table also? If should
contain an entry for every notification batch created.
I am unsure about the impact of running a virtual SMTP server. Joe's advise
is good: see if you can succeed in e-mailing notifications from the local
server.
-Colin
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms spe
Fri, 14 Jan 2005 09:03:21 -0800
"Colin Meek [MSFT]"
|
|