SYSADMIN User Gets Thousands of WFERROR Notifications (Doc ID 1299167.1)

Last updated on JUNE 22, 2016

Applies to:

Oracle Workflow - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

In 11i.Rup6 instance, Workflow Deferred Notification Agent Listener and Workflow Deferred Agent Listener services are always stopping System Deactivated Status.  There are thousands of WFERROR notifications sent to the SYSADMIN users with the following text:

Event Error Name: WFE_DISPATCH_GEN_ERR
Event Error Message: 3835: Error '-20002 - ORA-20002: 2018: Unable to generate
the notification XML. Caused by: 2020: Error when getting notification content. ORA-06502: PL/SQL: numeric or value error: character string buffer too small

WF_STANDARD.EventDetails(WFERROR:229863, text/html)
wf_notification.GetAttrDoc2(3910776, EVENT_DETAILS, text/html)
Wf_Notification.GetAttrDoc(3910776, EVENT_DETAILS, text/html)
Wf_Notification.GetText(3910776, text/html)
Wf_Notification.GetBody(3910776, text/html)
WF_NOTIFICATION.GetFullBody(nid => 3910776, disptyp
Event Error Stack:
WF_MAIL.GetLOBMessage3(3910776, WFMAIL, 2020: Error when getting notification content. Caused by: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

WF_STANDARD.EventDetails(WFERROR:229863, text/html)
wf_notification.GetAttrDoc2(3910776, EVENT_DETAILS, text/html)
Wf_Notification.GetAttrDoc(3910776, EVENT_DETAILS, text/html)
Wf_Notification.GetText(3910776, text/html)
Wf_Notification.GetBody(3910776, text/html)
WF_NOTIFICATION.GetFullBody(nid => 3910776, disptype => text/html)
WF_MAIL.GetLOBMessage3(nid => 3910776, r_ntf_pref => MAILHTM2), Step -> Getting text/html body)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 3910776)
WF_XML.Generate(oracle.apps.wf.notification.send, 3910776)
WF_XML.Generate(oracle.apps.wf.notification.send, 3910776)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 3910776, WF_XML.Generate)
Wf_Event.dispatch_internal()


There are thousands of these notifications generated in a day.  Looking at the wf_notifications table see that the mail_status of the notification is FAILED.

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