I created a notification in a decision step of a workflow, and replicated in a request twice the step in order to see the notification. HP Open/Report/create Report/Administrative/Notification Reports shows me the notifications as sent but I haven't receive any mail yet.
Is there any log or other way I can check to see where is failng?
First check the service node log, and check whether the notifcation service is running fine or not. We have observed that some time if the repeatation time is less then due to over lap some notifications are missied.
Best we to check is the notifcation history report. Or you can query the DB using this SQL
select a.FROM_EMAIL_ADDRESS, (select EMAIL_ADDRESS from KNTA_NOTIF_TXN_RECIPIENTS where NOTIF_TXN_DETAIL_ID = (select NOTIF_TXN_DETAIL_ID from KNTA_NOTIF_TXN_DETAILS where NOTIF_TXN_PARENT_ID = a.NOTIF_TXN_PARENT_ID ) ) SENT_TO_EMAIL_ADDRESS, a.CREATION_DATE SENT_ON, a.SUBJECT EMAIL_SUBJECT, (select DESCRIPTION from knta_notifications_nls where notification_id = a.notification_id) NOTIFICATION, (select VISIBLE_EVENT_VALUE from knta_notifications_nls where notification_id = a.notification_id) NOTIFICATION_EVENT from KNTA_NOTIF_TXN_PARENTS a where a.NOTIF_TXN_PARENT_ID in (select NOTIF_TXN_PARENT_ID from KNTA_NOTIF_TXN_DETAILS where NOTIF_TXN_DETAIL_ID in (select NOTIF_TXN_DETAIL_ID from KNTA_NOTIF_TXN_RECIPIENTS where EMAIL_ADDRESS in ('email@example.com')))
Cheers.. Utkarsh Mishra
-- Remember to give Kudos to answers! (click the KUDOS star)