Posted by
Mohammed Hamed on
Apr 01, 2021; 2:30pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/POXML-error-in-oracle-r12-tp9556p9562.html
Showing this in the error log.
Just tried getting the log by running the sql mentioned in your blog.
https://ermanarslan.blogspot.com/2014/08/ebs-122-notification-mailer.html[SVC-GSM-WFMLRSVC-168700-10010 : oracle.apps.fnd.cp.gsc.Logger.start(WorkflowContext, int)]:Logger has been successfully started -> Logger{mLog=[$Header: AppsLog.java 120.4.12010000.8 2016/
08/12 17:31:28 rsantis ship $ @5263318 {oracle.apps.fnd.profiles.ExtendedProfileStore@a96fe4}],mUniqueId=SVC-GSM-WFMLRSVC-168700-10010,mLevel=1}
[Mar 31, 2021 10:20:49 AM PDT]:1617211249812:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1570283275:32729:1617211237409:19:ERROR:[SVC
-GSM-WFMLRSVC-168700 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:Error in handling component event, oracle.apps.fnd.cp.gsc.SvcComponent.start, for compone
nt 10010
[Mar 31, 2021 10:20:49 AM PDT]:1617211249813:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1570283275:32729:1617211237409:19:ERROR:[SVC
-GSM-WFMLRSVC-168700 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:java.lang.RuntimeException: Connection refused (Connection refused)
at oracle.apps.fnd.wf.mailer.MailerUtils.isSocketConnectableNew(MailerUtils.java:298)
at oracle.apps.fnd.wf.mailer.SMTPUtils.isValidOutbound(SMTPUtils.java:521)
at oracle.apps.fnd.wf.mailer.Mailer.validateParameterValues(Mailer.java:1303)
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:2223)
at oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(SvcComponentContainer.java:301)
at oracle.apps.fnd.wf.bes.DispatchThread.run(DispatchThread.java:57)
[Mar 31, 2021 10:20:49 AM PDT]:1617211249813:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1570283275:32729:1617211237409:19:UNEXPECTED
:[SVC-GSM-WFMLRSVC-168700 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:An unexpected RuntimeException or other Throwable occurred -> java.lang.RuntimeExcep
tion: Connection refused (Connection refused)
[Mar 31, 2021 10:20:49 AM PDT]:1617211249814:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1570283275:32729:1617211237409:19:EXCEPTION:
[SVC-GSM-WFMLRSVC-168700 : oracle.apps.fnd.cp.gsc.SvcComponentStateMachine.updateComponentStatus(Logger, Connection, int, String, String)]:BEGIN (Logger{mLog=[$Header: AppsLog.java 120.4.12
010000.8 2016/08/12 17:31:28 rsantis ship $ @4532387 {oracle.apps.fnd.profiles.ExtendedProfileStore@6f1ad0}],mUniqueId=SVC-GSM-WFMLRSVC-168700,mLevel=4}, oracle.jdbc.driver.T4CConnection@18
f67fc, 10010, STOPPED_ERROR, Could not handle the control event -> java.lang.RuntimeException: Connection refused (Connection refused))
[Mar 31, 2021 10:21:27 AM PDT]:1617211287494:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[ComponentMonitor,5,main]:1570283275:32729:1617210987180:2:EXCEPTION:[SVC
-GSM-WFMLRSVC-168700 : oracle.apps.fnd.cp.gsc.SvcComponentMonitor.startAutomaticComponents()]:Starting automatic component 10010
[Mar 31, 2021 10:21:37 AM PDT]:1617211297442:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1570283275:32729:1617211297442:20:EXCEPTION:
[SVC-GSM-WFMLRSVC-168700 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:(BusinessEvent{name=oracle.apps.fnd.cp.gsc.SvcComponent.start, key=SVC:31-MAR-2021, p
riority=50, correlationId=null, sendDate=Wed Mar 31 10:21:27 PDT 2021, receiveDate=null, From Agent: , To Agent: , Last Subscription= , Error Message=null, Error Stack=null, CONTAINER_TY
PE=GSM, CONTAINER_PROCESS_ID=168700, COMPONENT_ID=10010, BES_PAYLOAD_OBJECT=false, BES_FROM_AGENT=WF_CONTROL@DV2.SAUSD.US})
[Mar 31, 2021 10:21:47 AM PDT]:1617211307449:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1570283275:32729:1617211297442:20:EXCEPTION:
[SVC-GSM-WFMLRSVC-168700 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.handleComponentEvent(int, String, String)]:Successfully retrieved component details from the database
[Mar 31, 2021 10:21:47 AM PDT]:1617211307466:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:1570283275:32729:1617211297442:20:EXCEPTION:
[SVC-GSM-WFMLRSVC-168700-10010 : oracle.apps.fnd.cp.gsc.Logger.start(WorkflowContext, int)]:Logger has been successfully started -> Logger{mLog=[$Header: AppsLog.java 120.4.12010000.8 2016/
08/12 17:31:28 rsantis ship $ @30343338 {oracle.apps.fnd.profiles.ExtendedProfileStore@134b16b}],mUniqueId=SVC-GSM-WFMLRSVC-168700-10010,mLevel=1}