BUG: Stored Procedures Do Not Accurately Report Failed Notifications (811903)

WORKAROUND

To work around this problem, query the NSNotificationClassNameNotifications table of the application database to obtain the list of failed notifications. The following sample query is a Transact-SQL query that returns all failed notifications that the vacuuming process does not remove.

Note In the following sample query:

• Replace Application_database_name with the name of the application database.
• Replace NotificationClassName with the notification class name.

Use <Application_database_name>

GO

SELECT 	
	NotificationId, 
	NotificationBatchId
FROM
	NS<NotificationClassName>Notifications 
WHERE 
	DeliveryStatusCode=4 

GO

Example:

Use FlightInstanceFlight

GO
 
SELECT 	
	NotificationId, 
	NotificationBatchId
FROM
	NSFlightNotificationsNotifications
WHERE 
	DeliveryStatusCode=4 
	
GO

You can then use the NotificationBatchId value with the NSNotificationBatchDetails stored procedure to obtain more information about the failed notifications. To troubleshoot failed notifications, view the error information in the Application log in Event Viewer.