Hi,
I am getting extra notifications which I am really not sure how and why its hapening.
I did try debugging, and everything seems perfect till ContentFormatter. I am getting exact number of messages for a
particular event and they are getting formatted perfectly by the custom content formatter.
But when I check the NS<ClassInstanceName>NotificationDistribution in the Notification DB, I have multiple records.
I did check the underlying query for this View and the issue is with NSDistributionLog. In some of these extra records I
can see the NotificationText that was never generated by the content formatter for this particular event.
We are supporting only one DeviceType 'Email' as of now.
Any suggestions/ideas why this is happening?
Hi Poonam -Are you using any custom components?
Joe|||
Hi Joe,
Yes I have a custom content formatter in place and thanks for helping me on this.
But I have figured out the problem and posting it here for reference. Here is what was happening:
Notification Service Instance creates a Work Item for each Batch of notification. But the View
NS<ClassInstanceName>NotificationDistribution doesn't consider BatchIDs. Rather it considers only the NotificationIDs.
Notifications IDs can be repeated with in a Batch.
So this view returns the records (for all the batch ids) where there is a match in the NotificationID irrespective of the if this
Notification is part of the batch or not.
So here is the output:
You get correct no. of emails formatted from content formatter
Correct no and content is delivered to the Delivery Channel
But
When we see the NS<ClassInstanceName>NotificationDistribution, there are extra records with
Different NotificationText that was actually never related to this Event.
Below is the correct query with the reference to Batch ID of the notifications actually generated:
SELECT *
FROM [...].[NS<ClassInstanceName>Notifications] N WITH (READUNCOMMITTED)
JOIN [...].[NSDistributorWorkItems] DW WITH (NOLOCK)
ON N.NotificationBatchID = DW.BatchID
JOIN [...].[NSSubscriberDevices] SD WITH (READUNCOMMITTED)
ON SD.SubscriberId = N.SubscriberId
AND SD.DeviceName = N.DeviceName
JOIN [...].[NSDistributionLog] DL WITH (READUNCOMMITTED)
ON DL.NotificationId = N.NotificationId
AND DW.DistributorWorkItemID = DL.DistributorWorkItemID
JOIN [...].[NSDistributors] D WITH (READUNCOMMITTED)
ON D.DistributorId = DL.DistributorId
JOIN [...].[NSNotificationDeliveryStatusCodes] DSC WITH (READUNCOMMITTED)
ON DSC.NotificationDeliveryStatusCode = DL.DeliveryStatusCode
WHERE
DL.NotificationClassId = 1
[...] - are corresponding Schema Names.
