Workflow Notifications Not Received Failing With Unhandled Exception in the Oracle Applications Framework layer (Doc ID 2262404.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Workflow - Version 12.1.2 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

The workflow mailer is up and running, but notifications are not received and some notifications are failed status.

ERROR
[Apr 5, 2017 10:56:20 AM CST]:1491411380379:-1:-1:gblg-chi-pap01.gblg.itciss.com:10.160.21.13:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1825766670:86853:1490612824414:19:ERROR:[fnd.wf.mailer.URLMIMETagListener]:oracle.apps.fnd.wf.mailer.URLMIMETagListener.tagFound(HTMLTagEvent) Unhandled exception in the Oracle Applications Framework layer -> {Error occured while processing the request}
[Apr 5, 2017 10:56:20 AM CST]:1491411380395:-1:-1:gblg-chi-pap01.gblg.itciss.com:10.160.21.13:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1825766670:86853:1490612824414:19:UNEXPECTED:[SVC-GSM-WFMLRSVC-782612-10006 : oracle.apps.fnd.wf.mailer.NotificationFormatter.handleResEndTag]:Problem handling the RESOURCE content java.io.IOException: Problem encountered when getting message content. For full details ensure component log level is STATEMENT and FND:Diagnostics profile option is enabled.
[Apr 5, 2017 10:56:20 AM CST]:1491411380395:-1:-1:gblg-chi-pap01.gblg.itciss.com:10.160.21.13:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1825766670:86853:1490612824414:19:UNEXPECTED:[SVC-GSM-WFMLRSVC-782612-10006 : oracle.apps.fnd.wf.mailer.NotificationFormatter.getFormattedMessages()]:Problem parsing XML -> org.xml.sax.SAXException: Problem handling the RESOURCE content -> java.io.IOException: Problem encountered when getting message content. For full details ensure component log level is STATEMENT and FND:Diagnostics profile option is enabled.
[Apr 5, 2017 10:56:20 AM CST]:1491411380396:-1:-1:gblg-chi-pap01.gblg.itciss.com:10.160.21.13:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1825766670:86853:1490612824414:19:ERROR:[SVC-GSM-WFMLRSVC-782612-10006 : oracle.apps.fnd.wf.mailer.SMTPMessageHandler.prepareMessages(String)]:FormatterException -> oracle.apps.fnd.wf.mailer.FormatterException: Problem parsing XML-> org.xml.sax.SAXException: Problem handling the RESOURCE content -> java.io.IOException: Problem encountered when getting message content. For full details ensure component log level is STATEMENT and FND:Diagnostics profile option is enabled.
  at oracle.apps.fnd.wf.mailer.NotificationFormatter.handleResEndTag(NotificationFormatter.java:3501)
  at oracle.apps.fnd.wf.mailer.NotificationFormatter.endElement(NotificationFormatter.java:578)
  at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:210)
  at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1345)
  at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:362)
  at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:308)
  at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:337)
  at oracle.apps.fnd.wf.mailer.NotificationFormatter.getFormattedMessages(NotificationFormatter.java:354)
  at oracle.apps.fnd.wf.mailer.SMTPMessageHandler.prepareMessages(SMTPMessageHandler.java:77)
  at oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.read(SMTPOutboundProcessor.java:793)
  at oracle.apps.fnd.cp.gsc.SvcComponentProcessor.process(SvcComponentProcessor.java:604)
  at oracle.apps.fnd.cp.gsc.Processor.run(Processor.java:283)
  at java.lang.Thread.run(Thread.java:745)
 Caused by: org.xml.sax.SAXException: Problem handling the RESOURCE content -> java.io.IOException: Problem encountered when getting message content. For full details ensure component log level is STATEMENT and FND:Diagnostics profile option is enabled.
[GC 93086K->57923K(128196K), 0.0036670 secs]
[GC 93310K->58234K(128196K), 0.0026650 secs]


FURTHER TESTING REVEALS
[Apr 7, 2017 10:02:34 AM CST]:1491580954166:-1:-1:gblg-chi-pap01.gblg.itciss.com:10.160.21.13:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1825766670:2805:1491575253102:5:STATEMENT:[fnd.wf.mailer.URLMIMEContent]:oracle.apps.fnd.wf.mailer.URLMIMEContent.MimeBodyPart[] getMIMEContents() A problem occured when obtaining content from {http://gblg-chi-pap02.gblg.itciss.com:8000/OA_HTML/OA.jsp?page=/oracle/apps/fnd/wf/worklist/webui/NotifMailerPG&WFRegion=NtfDetail&NtfId=2831220&dbc=PGBLGI&OARF=email&language_code=US} because of {Unhandled exception in the Oracle Applications Framework layer -> {Error occured while processing the request}} with details {

WHAT WORKS
The Mailer is up and running but not sending Notifications containing Framework Region Contents

BUSINESS IMPACT
Not stated

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