WF-Troubleshooting Workflow Notification Mailer Issues
来源:互联网 发布:浙江基层卫生网络直报 编辑:程序博客网 时间:2024/05/01 19:40
摘自:http://mtalmasri.blogspot.tw/2012/06/troubleshooting-workflow-notification.html
Find Workflow Notification Mailer is up and Running?
SELECT component_name, component_status
FROM fnd_svc_components
WHERE component_type = 'WF_MAILER';
Workflow log’s: FNDCPGSC*.txt under $APPLCSF/$APPLOG directory
Find the Failed One’s?
Select NOTIFICATION_ID, MESSAGE_TYPE, MESSAGE_NAME, STATUS, MAIL_STATUS, FROM_USER, TO_USER from wf_notifications where MAIL_STATUS='FAILED';
Check pending e-mail notification that was pending for process.
Sql> SELECT COUNT(*), message_name FROM wf_notifications
WHERE STATUS='OPEN'
AND mail_status = 'MAIL'
GROUP BY message_name;
Sql> SELECT * FROM wf_notifications
WHERE STATUS='OPEN'
AND mail_status = 'SENT'
ORDER BY begin_date DESC
Check the Workflow notification has been sent or not?
select mail_status, status from wf_notifications where notification_id=
--If mail_status is MAIL, it means the email delivery is pending for workflow mailer to send the notification
--If mail_status is SENT, its means mailer has sent email
--If mail_status is Null & status is OPEN, its means that no need to send email as notification preference of user is "Don't send email"
--Notification preference of user can be set by user by logging in application + click on preference + the notification preference
1. Verify whether the message is processed in WF_DEFERRED queue
select * from applsys.aq$wf_deferred a where a.user_data.getEventKey()= ''
- notification id
2. If the message is processed successfully message will be enqueued to WF_NOTIFICATION_OUT queue, if it errored out it will be enqueued to WF_ERROR queue
select wf.user_data.event_name Event_Name, wf.user_data.event_key Event_Key,
wf.user_data.error_stack Error_Stack, wf.user_data.error_message Error_Msg
from wf_error wf where wf.user_data.event_key = '
To check what all mails have went and which all failed ?
Select from_user,to_user,notification_id, status, mail_status, begin_date
from WF_NOTIFICATIONS where status = 'OPEN';
Select from_user, to_user, notification_id, status, mail_status,begin_date,USER_KEY,ITEM_KEY,MESSAGE_TYPE,MESSAGE_NAME begin_date
from WF_NOTIFICATIONS where status = 'OPEN';
Users complain that notifications are stuck ?
Use the following query to check to see whatever the users are saying is correct
SQL> select message_type, count(1) from wf_notifications
where status='OPEN' and mail_status='MAIL' group by message_type;
E.g o/p of query -
MESSAGE_Type COUNT(1)
-------- ----------
POAPPRV 11 --- 11 mails of Po Approval not sent ---
INVTROAP 12
REQAPPRV 9
WFERROR 45 --- 45 mails have error
If Mail not received by User ?
select Name,DISPLAY_NAME,EMAIL_ADDRESS,NOTIFICATION_PREFERENCE,STATUS
from wf_users where DISPLAY_NAME=’xxx,yyy’ ;
Status – Active
Notification_preference-> Mailtext
Email Address should not be null
Notification not sent waiting to be mailed ?
SQL> select notification_id, status, mail_status, begin_date from WF_NOTIFICATIONS
where status = ‘OPEN’ and mail_status = ‘MAIL’;
To debug the notification id ?
$FND_TOP/sql
run wfmlrdbg.sql
******************************
Note: 1054215.1 - How to Check if the Workflow Mailer is Running
Note: 415516.1 - How to Check Whether Notification Mailer is Working or Not
Note: 831982.1 - 11i/R12 - A guide for troubleshoting Workflow Notification Emails - Inbound and Outbound
Note: 1012344.7 - Notifications Not Being Sent In Workflow
Note: 560472.1 - Workflow Mailers Not Sending Notifications
Please see (Note: 753845.1 - How to Perform a Meaningful SMTP Telnet Test to Troubleshoot Java Mailer Issues), the same error is reported in this doc.
*****************
- WF-Troubleshooting Workflow Notification Mailer Issues
- WF-Oracle workflow notification mailer status - sql
- Workflow Notification Mailer Setup
- Workflow Notification Mailer Configuration in 11.5.10.2
- Unable to start Workflow Notification Mailer
- WF-mails not being sent from workflow mailer
- WF-在EBS中配置Notification Mailer常见错误
- ORACLE R12 Workflow Mailer设置
- 初识WF(Workflow Foundation)
- Windows Workflow Foundation (WF)
- A Guide For Troubleshooting Workflow Notification Emails - Inbound and Outbound [ID 831982.1]
- Informatica - Workflow issues
- RMAN Troubleshooting Catalog Performance Issues
- Citrix Xenapp 6.5 Troubleshooting Issues
- WF-Mailer Fails to Send Email Notifications after cloning
- * Troubleshooting Performance Issues (文档 ID 1377446.1)
- Troubleshooting Scheduler Autotask Issues (Doc ID 1561498.1)
- Pro WF: Windows Workflow in .NET 3.0
- 从手机网页拨打电话
- 1米长舌状绦虫惊现鱼腹 酷似刀削面吓坏吃鱼者
- linux 下不解压查看tar.gz包中的文件列表
- 关键词细分优化的策略方法
- 如何在Mac上访问Windows的共享文件夹
- WF-Troubleshooting Workflow Notification Mailer Issues
- vs配置OpenCV,弄了半天,还以为是哪里路径没有配好,其实就是64位机器要修改为64编译
- Android.mk语法说明(android ndk开发)
- 信号的采样
- 全国假日办14年后被撤销 国务院旅游联席会议办接棒
- Always override hashCode when you override equals
- rails 导出 excel 格式 xls 和 csv
- Oracle数据库进程架构
- 前端开发平台搭建