This discussion is archived
4 Replies Latest reply: May 10, 2011 6:43 AM by 744052 RSS

Notification Mailer Issue

744052 Newbie
Currently Being Moderated
Hi,

I am working on Oracle EBS 12.1.1 on AIX 6.1. The notification mailer is not working and below is the log file contents

Caused by: oracle.apps.fnd.wf.mailer.NotificationFormatter$FormatterSAXException: Problem obtaining the HTML content -> oracle.apps.fnd.wf.common.HTTPClientException: Unable to invoke method HTTPClient.HTTPConnection.Get caused by: java.net.UnknownHostException: testircpav1.inc.com
[May 10, 2011 11:57:58 AM GMT+03:00]:1305017878071:-1:-1:fincl1.albilad.com:10.1.2.4:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:10.1.2.4:62856:1305017742754:35:ERROR:[SVC-GSM-WFMLRSVC-8667360-10006 : oracle.apps.fnd.wf.mailer.SMTPMessageHandler.prepareMessages(String)]:Problem getting HTML content -> oracle.apps.fnd.wf.mailer.FormatterException: Problem getting the HTML content -> oracle.apps.fnd.wf.mailer.NotificationFormatter$FormatterSAXException: Problem obtaining the HTML content -> oracle.apps.fnd.wf.common.HTTPClientException: Unable to invoke method HTTPClient.HTTPConnection.Get caused by: java.net.UnknownHostException: testircpav1.inc.com
     at oracle.apps.fnd.wf.mailer.NotificationFormatter.handleResEndTag(NotificationFormatter.java:3461)
     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:1318)
     at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:336)
     at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
     at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:319)
     at oracle.apps.fnd.wf.mailer.NotificationFormatter.getFormattedMessages(NotificationFormatter.java:354)
     at oracle.apps.fnd.wf.mailer.SMTPMessageHandler.prepareMessages(SMTPMessageHandler.java:96)
     at oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.read(SMTPOutboundProcessor.java:732)
     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:735)
Caused by: oracle.apps.fnd.wf.mailer.NotificationFormatter$FormatterSAXException: Problem obtaining the HTML content -> oracle.apps.fnd.wf.common.HTTPClientException: Unable to invoke method HTTPClient.HTTPConnection.Get caused by: java.net.UnknownHostException: testircpav1.inc.com

testircpav1.inc.com is a web server node which has been recently added to the apps server. I ran the query below

select fpo.profile_option_name Profile,
fpov.profile_option_value Value,
decode(fpov.level_id, 10001,'Site',
+10002,'Application',+
+10003,'Responsibility',+
+10004,'User',+
+10005,'Server',+
+10006,'Organization')"LEVEL",+
fa.application_short_name App,
fr.responsibility_name Responsibility,
fu.user_name "USER"
from fnd_profile_option_values fpov,
fnd_profile_options fpo,
fnd_application fa,
fnd_responsibility_vl fr,
fnd_user fu,
fnd_logins fl
where fpo.profile_option_id=fpov.profile_option_id
and fa.application_id()=fpov.level_value+
and fr.application_id()=fpov.level_value_application_id+
and fr.responsibility_id()=fpov.level_value+
and fu.user_id()=fpov.level_value+
and fl.login_id() = fpov.LAST_UPDATE_LOGIN+
and fpo.profile_option_name in
+('APPS_FRAMEWORK_AGENT', 'WF_MAIL_WEB_AGENT', 'APPS_WEB_AGENT',+
+'APPS_SERVLET_AGENT', 'ICX_FORMS_LAUNCHER')+
order by 1,3;

It shows both the values testircpav1.inc.com and testircpav.inc.com (the apps server). I have changed the Profile Option: WF: Mailer Web Agent to testircpav.inc.com

Please any comments, hints and suggestions.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points