How to start the Workflow Mailer
Service Using Oracle Application Manager (OAM)
1.
Login to OAM
2.
Navigate to Workflow
3.
Click on Service Components you will find a new page with item name “Workflow
Notification Mailer” and Container
“Workflow Mailer Service”
4.
Under column container click on Workflow Agent Listener Service
5.
From drop down list at the end of the line , choose start then click on Go
button
6.
Once service container are activated , all service components with startup mode
automatic will be up and running
![](file:///C:/Users/171092tj/AppData/Local/Temp/msohtmlclip1/01/clip_image002.jpg)
![](file:///C:/Users/171092tj/AppData/Local/Temp/msohtmlclip1/01/clip_image004.jpg)
![](file:///C:/Users/171092tj/AppData/Local/Temp/msohtmlclip1/01/clip_image006.jpg)
![](file:///C:/Users/171092tj/AppData/Local/Temp/msohtmlclip1/01/clip_image008.jpg)
Mailer
Fails to Send Email Notifications after cloning.
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
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
![](file:///C:/Users/171092tj/AppData/Local/Temp/msohtmlclip1/01/clip_image010.jpg)
![](file:///C:/Users/171092tj/AppData/Local/Temp/msohtmlclip1/01/clip_image012.jpg)
3. Start the mailer
4. Retest the issue by submitting the same workflow again.
No comments:
Post a Comment