EBS Workflow Mailer Failing To Send Email Notifications With java.net.ConnectException: Connection refused After Environment Configuration Change
Last updated on JANUARY 12, 2018
Applies to:Oracle Workflow - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Workflow Mailer is failing to send email notifications with:
A two server configuration for High Availability. One server is active, the other is idle. They are clustered using VCS.
The system failed over to the idle server over the weekend. Using a BIG IP configuration to mask the two physical server names, and everything runs as expected, with this exception.
The environment is NOT SSL enabled. Nor it is using load balancing.
The file system and database are on a single server. The RDBMS, App Tier, Concurrent managers all run on one server. All things are running fine, except, that the WF Mailer does not send email.
The key error messages in java mailer log files are:
a) 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.ConnectException: Connection refused
b) EXCEPTION:[jtf.cache.appsimpl.AppsCacheFrameworkConfig]:oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
c) java.lang.RuntimeException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: The Network Adapter could not establish the connection
d) java.net.UnknownHostException: erp.test.com
e) ERROR:[jtf.cache.CacheManager]:Failed to load CacheComponent configuration
There is no change in java mailer configuration. Nor any change to email inbound or outbound servers.
The application uses virtual name in the URL.
The physical servers, LCOV55 and LCOV54 are both discovered in FND_NODE, but the target node shows the correct physical server name when running this query:
select target_node from fnd_concurrent_queues where concurrent_queue_name like 'WFMLRSVC%';
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