4 Replies Latest reply: May 10, 2011 8:43 AM by 744052 RSS

    Notification Mailer Issue

    744052
      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