ISSUE:
------

all of a sudden no worflow emails are coming out of the system

all new rows in wf_notifications.mail_status IS SET TO NULL ... (should be set to MAIL)



SOLUTION:
---------

navigate to:
System Administrator -> Workflow : Administrator Workflow -> Administration

and make sure that:
Workflow System Administrator: SYSADMIN
or
Workflow System Administrator: *
and
Notification Style: HTML mail with attachments

WHAT CHANGED:

A programmer updated Workflow Configuration changing "Workflow System Administrator" to SYSADMIN
and it defaulted to "Do not send me mail" in Notification Style field.

NOTE:

if you can't change this page set the Workflow System Administrator temporary to your USERNAME:

select * from WF_RESOURCES
where text like 'SYSADMIN';

update WF_RESOURCES
set text = 'YOUR_USERNAME'
where name = 'WF_ADMIN_ROLE'
and type = 'WFTKN';

commit;



RESEARCH:
----------

To resent notification:

update wf_notifications
set status ='OPEN', mail_status ='MAIL', end_date = NULL
where notification_id=168476;

Plus with WorkFlow 2.6, you have to :

wf_xml.enqueueNotification(168476);

commit;

and confirm that queue WF_SMTP_O_1_QUEUE is started