Debugging custom Sql delivery provider RRS feed

  • Question

  • We can not get the sql server custom delivery protocol working. Code found on MSDN.  We have a custom MQ working and this subsciription works sent to file only. But whenever we use the sqlprotocol we get this error.


    Event Type: Error
    Event Source: NotificationServices
    Event ID: 4048
    Description: Some notifications cannot be delivered because they reference non-existent subscribers, unknown subscriber device names, or unsupported protocols for the notification class. Use the NSDiagnosticFailedNotifications stored procedure for details about undeliverable notifications.
     InstanceName: EasyNS
    ApplicationName: DocEvents
    Component: Generator
    Thread: 10

    The NSDiagnosticFailedNotifications NSDiagnosticFailedNotifications outputs


    AppName,  Notifclass, delchanlname, notifbatchid, notid, subid, subdevadd,

    DocEvents, NewDoc, NULL, 1, 2, RushDiamondSQL, RushDiamondNotifierAgent, NULL, NULL, NULL


    the del channel name is null? Any other debugging tips? we have pathers book.

    the protocol assembly definition only has the path/file dll name.



    Wednesday, April 18, 2007 5:29 PM

All replies

  • I got it figured out. my subscription was calling the wrong notif class which did not have this protocol.


    Wednesday, April 18, 2007 7:23 PM