Project and Portfolio Management Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Following notification messages

Valued Contributor

Following notification messages

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?

 

Regards

 

Alfredo

3 REPLIES
Trusted Contributor

Re: Following notification messages

If a send was attempted but failed you can check the bg log:

<PPM Install Dir>/server/background_services_node/log/serverLog

 

From the frontend an admin can do a Notification History report.

Trusted Contributor

Re: Following notification messages

can you check in the notification "dont send if obsolete is checked"?

Highlighted
Honored Contributor

Re: Following notification messages

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
('abc.c@abc.com')))

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)