Workflow Mailer not Sending Notifications java.net.ConnectException: Connection refused (errno:239)

After the Mailer is configured, one is unable to send email notifications with framework regions they fail and the following error message can be seen in the log files:

Caused by: oracle.apps.fnd.wf.mailer.NotificationFormatter$FormatterSAX
Exception: Problem obtaining the HTML content -> oracle.apps.fnd.wf.common.HTTPC
lientException: Unable to invoke method HTTPClient.HTTPConnection.Get caused by:
java.net.ConnectException: Connection refused (errno:239)


The value of the "WF: Workflow Mailer Framework Web Agent" [WF_MAIL_WEB_AGENT] profile is not correctly set to point to the FQDN of the Web Server.
This needs to be set to http or https://<host>.<domain>:<port>



SOLUTION

1. Stop the Workflow Mailer and Agent Listener service.

2. Change the "WF: Workflow Mailer Framework Web Agent" [WF_MAIL_WEB_AGENT] profile option to point to the physical Web Server host address - http or https://<host>.<domain>:<port>

3. Rebuild mailer queue with:

SQL>@$FND_TOP/patch/115/sql/wfntfqup.sql APPS <APPS schema passwd> APPLSYS

4. Start Workflow Mailer and Agent Listener service.

5. Test with a new notification.