Erman Arslan's Oracle Forum - Re: Workflow mailer OAF-based notifications and SSL terminated load balancer environment

Erman Arslan's Oracle Forum › EBS 12.1/12.0/11i

Re: Workflow mailer OAF-based notifications and SSL terminated load balancer environment

Posted by ArtKuznetsov on Oct 30, 2020; 3:27pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Workflow-mailer-OAF-based-notifications-and-SSL-terminated-load-balancer-environment-tp8889p8947.html

Hi Erman! Here is the error:

[Oct 25, 2020 5:40:03 PM MSK]:1603636803795:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:prulmasofia01.hq.ru.corp.leroymerlin.com:10.99.16.1:-1:-1:UNEXPECTED:[SVC-GSM-WFMLRSVC-206160-10006 : oracle.apps.fnd.wf.mailer.NotificationFormatter.handleResEndTag]:Problem handling the RESOURCE content javax.net.ssl.SSLException: SSL handshake failed: SSLSessionNotFoundErr
[Oct 25, 2020 5:40:03 PM MSK]:1603636803797:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:prulmasofia01.hq.ru.corp.leroymerlin.com:10.99.16.1:-1:-1:UNEXPECTED:[SVC-GSM-WFMLRSVC-206160-10006 : oracle.apps.fnd.wf.mailer.NotificationFormatter.getFormattedMessages()]:Problem parsing XML -> org.xml.sax.SAXException: Problem handling the RESOURCE content -> javax.net.ssl.SSLException: SSL handshake failed: SSLSessionNotFoundErr
[Oct 25, 2020 5:40:03 PM MSK]:1603636803797:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:prulmasofia01.hq.ru.corp.leroymerlin.com:10.99.16.1:-1:-1:ERROR:[SVC-GSM-WFMLRSVC-206160-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 -> javax.net.ssl.SSLException: SSL handshake failed: SSLSessionNotFoundErr
	at oracle.apps.fnd.wf.mailer.NotificationFormatter.handleResEndTag(NotificationFormatter.java:3492)
	at oracle.apps.fnd.wf.mailer.NotificationFormatter.endElement(NotificationFormatter.java:578)
	at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:196)
	at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1212)
	at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:301)
	at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:268)
	at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:253)
	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: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:682)
 Caused by: org.xml.sax.SAXException: Problem handling the RESOURCE content -> javax.net.ssl.SSLException: SSL handshake failed: SSLSessionNotFoundErr

I have already set WF_MAIL_WEB_AGENT to the first physical server HTTP URL. Some mails are sent successfully, but some don't. In addition, view logs (WF mailer, concurrent managers etc) from OAF interface doesn't work. I'm confused with that. I have already tried and configured cacerts in JDK (added intercal CAs) and pointer workflow mailer SSL_TRUST to that certificate store, but with no luck.