WF-Mailer Fails to Send Email Notifications after cloning
来源:互联网 发布:c语言流程图生成器 编辑:程序博客网 时间:2024/04/26 21:21
转自:http://mtalmasri.blogspot.tw/2012/08/mailer-fails-to-send-email.html
After cloning, mails were not floating through workflow mailer although all agent listener and notification mailer was up and running.
Issue:-
After some time we checked latest mailer log FNDCPGSCXXXXX.txt at $APPLCSF/$APPLLOG.
Below error was their in logs:-
'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'
Investigation:-
what i got to know after bit of investigation is at the time we brought down source instance for cold back up, some of the workflows were in queue and they might be using source instance webserver address. After clone Since the mailer still had some events with the old url in the queue, the mailer fails with connection refused error and goes down after 10 attempts.
Solution:-
Solution is to purge the wf_notification_out outbound message queue and repopulates from the WF_NOTIFICATION table.
PFB complete solution:-
1. Stop the Workflow mailer.
2. Purge the wf_notification_out queue and recreate it out of the wf_notifications table by executing:
cd $FND_TOP/patch/115/sql
sqlplus APPS/ @wfntfqup.sql APPS APPLSYS
3. Start the mailer
4. Retest the issue by submitting the same workflow again.
- WF-Mailer Fails to Send Email Notifications after cloning
- WF-How to purge e-mail notifications from the Workflow queue - after clone
- how to send email
- Custom checkout cart – How to send email after successful checkout
- android: how to send email
- How to send Email asynchronously
- how to send email by jmail?
- using System.Web.Mail to send email
- Use Java Mail API to Send Email
- How to send email via Django?
- How to send email using sqlserver
- Oracle EBS-Responding to Workflow Notifications Via Email Only
- Client Print Fails to Load After Microsoft Update 956391
- WF-Oracle workflow notification mailer status - sql
- WF-Troubleshooting Workflow Notification Mailer Issues
- zencart Notice: FAILED to send Email to all recipients. tool->send email
- send email
- send email
- GitHub入门教程(二)- 使用前的配置
- sizeof的详尽计算结构体字节数方法
- ios 图片处理
- 服务器jsp推送
- [后缀数组+二分+rmq] hdu 5008 Boring String Problem
- WF-Mailer Fails to Send Email Notifications after cloning
- 获取window服务路径
- 【工具】MQ常用命令
- 关于spring中HibernateTransactionManager和DataSourceTransactionManager
- [GEiv]第五章:个体集群 虚假的分配与释放
- 使用gcd_ wait来 处理gcd
- Netty的几个要点
- 花生壳内网穿透、nat123映射p2p穿透,都是如何穿透的
- MySQL函数