Tuesday, April 7, 2009

Notifications are not Received and Log file Shows Connection Refused Error

The cause for this error ios that the url for the web server was changed so that the events in the queue still have the old url:

Example:

{https://:8001/OA_HTML/OA.jsp?page=/oracle/apps/fnd/wf/worklist/webui/...

The web server name in the log file is not the same as the web server name in the WF_MAIL_WEB_AGENT profile option.

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.


To implement the solution, please execute the following steps:

1. Stop the Workflow mailer

2. Recreate 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.

5. Migrate the solution as appropriate to other environments.



1 comment:

Unknown said...

thanks. I know another software to recover sql server database, maybe you will be interested