Absent Member.. Oscar_Pereira Absent Member..
Absent Member..
211 views

(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

 

 

Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.