Friday, January 2, 2009

Configuring R12 Workflow Mailer’s SMTP server to send mails to all domains through telnet

1. Unable to send to the mails for any domain except the client’s domain

2. When looked into the log file FNDCPGSC***.txt ($APPLCSF/$APPLLOG), found out the following error,

Oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.send(Message)]:Problem encountered when sending to {[["ADDRESS.DOMAIN.COM.AMERICAN" ]]} -> javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 Unable to relay
oracle.apps.fnd.wf.mailer.SMTPMessageHandler.sendMessages(String)]:SendFailedException -> [["ADDRESS@DOMAIN.COM.AMERICAN" ]] javax.mail.SendFailedException: Invalid Addresses; nested exception is: class Javax.mail.SendFailedException: 550 5.7.1 Unable to relay

3. Confirmed the same by checking the wf_notifcations table and the mails sent to the id’s outside the clients domain failed with status “FAILED” (Testes Purchase Orders to Suppliers, Workflow Test Mail, Forgot Your Password Functionality)

4. Tried to login the user through telnet and got the same error and confirmed that this is something to do with SMTP server
[applprod@perp log]$ telnet webmail.domain.in 25
Trying 192.168.1.7...
Connected to webmail.domain.in (192.168.1.7).
Escape character is '^]'.
220 EXCHMAILSERVER1.domain.in Microsoft ESMTP MAIL Service ready at Fri, 2 Jan 2009 15:36:26 +0530
HELO
250 EXCHMAILSERVER1.domain.in Hello [192.168.1.40]
MAIL FROM: wfmailer@domain.in
250 2.1.0 Sender OK
RCPT TO: address@domain.com
550 5.7.1 Unable to relay

5. The issue has been given in the notes # 374804.1, 304582.1 and 753845.1, requested the mail administrator to set the SMTP mail server to allow relaying, that is sending mail to an outside domain from that server (192.168.1.40)

6. Restarted the “Workflow Notification Mailer” through Oracle Applications Manager

7. Once done checked the notifications from purchase orders to supplier and Forgot Your Password link with other domain’s mail-id started working fine

1 comment:

diana_ser said...

nice tool. However, I have heard about another sql data recovery software, check it out and find out why it is more efficient