(PPM) Support Tip: Notification not being sent - troubleshooting
First, try to narrow down if ALL the application notification are not working, or just the notifications for a particular module (i.e Demand Management, Time Management, and Resource Management)
Does re-starting the PPM server or the SMTP server makes a difference?
Add the following lines for notification service debug to the logging.conf, this file is located in PPM_HOME/conf/ folder:
com.kintana.core.logging.PRODUCT_FUNCTION_LOGGING_LEVEL = com.kintana.services, DEBUG
com.kintana.core.logging.PRODUCT_FUNCTION_LOGGING_LEVEL = com.kintana.core.notifications, DEBUG
com.kintana.core.logging.SYSTEM_THRESHOLD = DEBUG
Check the content of the following tables:
1) select * from jms_messages;
Look for any error related to notifications
2) select * from qrtz_triggers;
3) select * from QRTZ_TRIGGERS WHERE TRIGGER_STATE='BLOCKED'
The above queries are to check if the notification related services are in a BLOCKED status.
4) select * from knta_notif_txn_parents where notification_sent_flag='N'
The knta_notif_txn_parents is the driving table for the notification service, verify the column NOTIFICATION_SENT_FLAG, if the value is Y, it means that a notification was successfully created and sent to the SMTP server, but when the flag shows as N, it means that it was not sent to the SMTP server and that there is a problem at application level.
A high volume of records in knta_notif_txn_parents, it’s a symptom that something is wrong with the service.
5) The RM notification service will only send out notifications if the column of “last_update_time” is not null, in the ppm_message_item table.
SELECT * FROM ppm_notification_details nd, ppm_message_item mi WHERE ND.NOTIF_DETAILS_ID = MI.NOTIF_DETAILS_ID AND MI.LAST_SENT_TIME IS NULL;
select * from ppm_message_item where LAST_SENT_TIME IS NULL Order by last_update_date desc