Email notifications are sent multiple times for the same notification
Error/Warning Messages
"Source: .Net SqlClient Data Provider
Description: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
StackTrace: at Changepoint.CommonServices.DataAccess.DBAccess.ExecuteNonQuery(String SqlStatement, ArrayList Parameters, CommandType CommandType, Int32 CommandTimeout)
at Changepoint.EmailNotification.Notification._purgeStagingTable()"
Reason
The Email Notification service was not purging the records in a timely fashion.
Resolution:
CPEmailNotification.exe.config needed to be adjusted
Apply the following changes to the CPEmailNotification.exe.config file
"<"add key="EmailNotificationPurgeAmount" value="10" /">"
"<"add key="EmailNotificationPurgeAmountMultiplier" value="5" /">"