Search This Blog

Sunday, May 9, 2021

Issue - An unexpected RuntimeException or other Throwable occurred -> java.lang.RuntimeException: Connection refused

 

Issue - An unexpected RuntimeException or other Throwable occurred -> java.lang.RuntimeException: Connection refused


Error messages on workflow log file - 


[May 9, 2021 5:17:51 AM MST]:1620562671861:-1:-1:prod1:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1515289823:94543:1620562656860:13:ERROR:[SVC-GSM-WFMLRSVC-1504463 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:java.lang.RuntimeException: Connection refused

at oracle.apps.fnd.wf.mailer.MailerUtils.isSocketConnectableNew(MailerUtils.java:300)

at oracle.apps.fnd.wf.mailer.SMTPUtils.isValidOutbound(SMTPUtils.java:508)

at oracle.apps.fnd.wf.mailer.Mailer.validateParameterValues(Mailer.java:1301)

at oracle.apps.fnd.cp.gsc.SvcComponent.performValidateParameterValues(SvcComponent.java:233)

at oracle.apps.fnd.cp.gsc.SvcComponent.start(SvcComponent.java:314)

at oracle.apps.fnd.cp.gsc.SvcComponentContainer.handleComponentEvent(SvcComponentContainer.java:2212)

at oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(SvcComponentContainer.java:301)

at oracle.apps.fnd.wf.bes.DispatchThread.run(DispatchThread.java:57)


[May 9, 2021 5:17:51 AM MST]:1620562671861:-1:-1:prod1:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1515289823:94543:1620562656860:13:UNEXPECTED:[SVC-GSM-WFMLRSVC-1504463 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:An unexpected RuntimeException or other Throwable occurred -> java.lang.RuntimeException: Connection refused

[May 9, 2021 5:17:51 AM MST]:1620562671862:-1:-1:prod1:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1515289823:94543:1620562656860:13:PROCEDURE:[fnd.wf.apps.WorkflowContext]:oracle.apps.fnd.wf.apps.WorkflowContext.getJDBCConnection(): BEGIN/END

[May 9, 2021 5:17:51 AM MST]:1620562671862:-1:-1:prod1:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1515289823:94543:1620562656860:13:PROCEDURE:[fnd.wf.apps.WorkflowContext]:oracle.apps.fnd.wf.apps.WorkflowContext.getJDBCConnection(null,0x17d6203,false,false,false): : BEGIN

[May 9, 2021 5:17:51 AM MST]:1620562671862:-1:-1:prod1:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1515289823:94543:1620562656860:13:PROCEDURE:[fnd.wf.apps.WorkflowContext]:oracle.apps.fnd.wf.apps.WorkflowContext.getJDBCConnection: END: returning oracle.jdbc.driver.T4CConnection@1e4e6c6

[May 9, 2021 5:17:51 AM MST]:1620562671862:-1:-1:prod1:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1515289823:94543:1620562656860:13:EXCEPTION:[SVC-GSM-WFMLRSVC-1504463 : oracle.apps.fnd.cp.gsc.SvcComponentStateMachine.updateComponentStatus(Logger, Connection, int, String, String)]:BEGIN (Logger{mLog=[$Header: AppsLog.java 120.4.12010000.11 2019/10/10 06:06:06 ssambidi ship $ @4297498 {oracle.apps.fnd.profiles.ExtendedProfileStore@1209745}],mUniqueId=SVC-GSM-WFMLRSVC-1504463,mLevel=4}, oracle.jdbc.driver.T4CConnection@1e4e6c6, 10006, STOPPED_ERROR, Could not handle the control event -> java.lang.RuntimeException: Connection refused)

[May 9, 2021 5:17:51 AM MST]:1620562671866:-1:-1:prod1:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1515289823:94543:1620562656860:13:PROCEDURE:[fnd.wf.apps.WorkflowContext]:oracle.apps.fnd.wf.apps.WorkflowContext.getJDBCConnection(): BEGIN/END

[May 9, 2021 5:17:51 AM MST]:1620562671866:-1:-1:prod1:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1515289823:94543:1620562656860:13:PROCEDURE:[fnd.wf.apps.WorkflowContext]:oracle.apps.fnd.wf.apps.WorkflowContext.getJDBCConnection(null,0x17d6203,false,false,false): : BEGIN

[May 9, 2021 5:17:51 AM MST]:1620562671867:-1:-1:prod1:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1515289823:94543:1620562656860:13:PROCEDURE:[fnd.wf.apps.WorkflowContext]:oracle.apps.fnd.wf.apps.WorkflowContext.getJDBCConnection: END: returning oracle.jdbc.driver.T4CConnection@1e4e6c6



Solution - 


1. Go into Oracle Application Manager as the SYSADMIN user.

2. In the upper right corner of the screen next to "Navigate to", please select "Workflow Manager" from the drop down and select "Go".

3. Then in the lower left corner of the screen under Related Links, select "Service Components".

4. Select "Workflow Notification Mailer" and click on "Edit".

5. Enter the correct Outbound(SMTP) Server name and Apply the changes.

6. Bounce the mailer and retest. 


Reference - Workflow Notification Mailer Not Starting After Running AutoConfig With Errors: Unable to make a network connection OR java.lang.RuntimeException: Connection refused (Doc ID 1565672.1)

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...