Notification Not Working With Error 'Node 2000017155 does not exist in the cache' in Application Server Log

(Doc ID 1340951.1)

Last updated on NOVEMBER 20, 2016

Applies to:

Oracle Agile Product Portfolio Management - Version 9.3.1.1 and later
Oracle Agile PLM Framework - Version 9.3.1.1 and later
Information in this document applies to any platform.

Symptoms

Notification is not working as expected with below problems:
- New Notifications are not sent out at all.
- When checking Notifications that was sent before the upgrade from Web Client > Notifications inbox, can see that Subject field is showing blank.
- When checking Notification Template from Java Client > Admin tab > System Settings > Notification, 
can see that the attributes for Notification Template such as Object Type, Priority field shows blank, Enabled is changed to 'No', Notification Typee is changed to 'Email' for the most of the notification templates.

Facts
---------
- Averify errors are fixed
- Notification settings in Java Client > Admin tab > Server Settings > Database is configured properly
- After enabling SQL trace log, can see below error in Application Server log:
<2011-07-05 13:14:06,423> <SqlLogger:DEBUG> executeQuery (Elapsed Time = 46 ms): "SELECT TEMPLATE_ID, ATT_TYPE, ATT_ID FROM NOTIFY_ATTRIBUTE"
11/07/05 13:14:07 com.agile.admin.client.value.AdminException: Node 2000017155 does not exist in the cache. It may have been deleted already.
11/07/05 13:14:07 at com.agile.admin.server.ADictionary.getNodeByID(ADictionary.java:221)
11/07/05 13:14:07 at com.agile.admin.server.ADInitLoad.loadNotifyTemplateAttributes(ADInitLoad.java:1633)
11/07/05 13:14:07 at com.agile.admin.server.ADInitLoad.startAdmin(ADInitLoad.java:463)
11/07/05 13:14:07 at com.agile.ui.pcm.InitServlet.init(InitServlet.java:61)

For instructions on how to enable SQL trace log on Agile PLM, please see <Note:568239.1> - How to Enable and Disable SQL Trace on PLM 9.x

Changes

Upgraded to Agile PLM 9.3.1.1 or above

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms