Skip to main content
Planview Customer Success Center

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" /">"