Workflow SMTP server

classic Classic list List threaded Threaded
5 messages Options
Sri
Reply | Threaded
Open this post in threaded view
|

Workflow SMTP server

Sri
Dear erman,

Need your favour in fixing the below issue

We use gmail as our workflow smtp server.The same SMTP is used for prod and DEV.In prod workflow is running and we dont have any issues,But in DEV we are unable to start the mailer with below errors.we are unable to ping the SMTP server from DEV where as we are able to ping it from PROD.

93:1516780457888:44:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseLocalJDBCConnection: END
[24 Jan, 2018 1:24:28 PM IST]:1516780468059:-1:-1:erpdevapps.ttd.com:172.16.112.11:-1:-1:-1:-1:ANONYMOUS(0):659321336:Thread[BES Dispatch Thread,5,main]:172.16.112.11:43593:1516780457888:44:PROCEDURE:[fnd.profiles.Profiles]:getProfileOptionValue:  name=ORG_ID; levelID=10003; levelValue=-1; levelValueApplID=-1
[24 Jan, 2018 1:24:28 PM IST]:1516780468059:-1:-1:erpdevapps.ttd.com:172.16.112.11:-1:-1:-1:-1:ANONYMOUS(0):659321336:Thread[BES Dispatch Thread,5,main]:172.16.112.11:43593:1516780457888:44:PROCEDURE:[fnd.profiles.Profiles]:getProfileOptionValue:  name=ORG_ID; levelID=10001; levelValue=0; levelValueApplID=0
[24 Jan, 2018 1:24:28 PM IST]:1516780468093:-1:-1:erpdevapps.ttd.com:172.16.112.11:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:172.16.112.11:43593:1516780457888:44:ERROR:[SVC-GSM-WFMLRSVC-21505 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:Error in handling component event, oracle.apps.fnd.cp.gsc.SvcComponent.start, for component 10006
[24 Jan, 2018 1:24:28 PM IST]:1516780468094:-1:-1:erpdevapps.ttd.com:172.16.112.11:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:172.16.112.11:43593:1516780457888:44:ERROR:[SVC-GSM-WFMLRSVC-21505 : oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(BusinessEvent)]:java.lang.RuntimeException: smtp-relay.gmail.com
        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:2223)
        at oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(SvcComponentContainer.java:301)
        at oracle.apps.fnd.wf.bes.DispatchThread.run(Unknown Source)


From DEV

[appldev@erpdevapps log]$ ping smtp-relay.gmail.com
ping: smtp-relay.gmail.com: Name or service not known
[appldev@erpdevapps log]$
Sri
Reply | Threaded
Open this post in threaded view
|

Re: Workflow SMTP server

Sri
Dear erman,

Issue is fixed by adding smtp server ip in /etc/hosts file in DEV instance.But in PROD,we dont have this smtp server entry in /etc/hosts file.Not sure how it is working in prod without this entry and how it is not working in DEV

can you please provide your ideas

Thank you
Reply | Threaded
Open this post in threaded view
|

Re: Workflow SMTP server

ErmanArslansOracleBlog
Administrator
Aha..

Maybe in PROD, you have a DNS configured.. So PROD could resolve the name using DNS..
When you have a proper DNS, you don't need to write down the ip and host information of all the servers to your /etc/hosts file..
Sri
Reply | Threaded
Open this post in threaded view
|

Re: Workflow SMTP server

Sri
Thanks erman for the updates.

In prod also,we have all the application and database nodes IP's listed in /etc/hosts except smtp servers IP.How can we check if it is using  DNS
Reply | Threaded
Open this post in threaded view
|

Re: Workflow SMTP server

ErmanArslansOracleBlog
Administrator
you can check /etc/resolv.conf file.
also you can query the dns using nslookup <ip_address>