Sunday, February 19, 2012

Debugging custom Sql delivery provider

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:
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.
EventParameters:
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.

thanks

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

No comments:

Post a Comment