Symptoms

Notification is configured and seems to work correctly for most of the customers, but for some of the customers the notification cannot be found when searching by the notification subscription and the customers e-mail address in Home > System > Logs.

Cause

The customer may have changed his e-mail address.

Resolution

If an e-mail address has ever been changed is only possible to find out from the database:

select "BillEmail","UserArc", "DateArc"::abstime from "AccountArc" where "AccountID" = <ID> order by "DateArc"

where <ID> is to be substituted with the id of account. You will get the results

BillEmail - an e-mail address
UserArc - the user who made changes
DateArc - when the change was made

If an account in question is of personal type (not business account), then "PersEmail" instead of "BillEmail" to be checked:

select "PersEmail","UserArc", "DateArc"::abstime from "AccountArc" where "AccountID" = <ID> order by "DateArc"

After getting the previous e-mail address, recheck the notification in Home > System > Logs.

Internal content