Wednesday, May 7, 2014

"Unsolicited Mail" Warning When Receiving Out-Of-Office Reply or Unable to Connect to Mail Store due to " javax.mail.internet.ParseException"



Symptoms
Case #1: Out-of-office Autoreply emails are being sent "Warning for Unsolicited Mail" messages, even though a mailer tag has been created to ignore "AutoReply:" messages.
The following email is received by the user who is Out of the Office:

Messages sent to this account are processed automatically by the Oracle Workflow Notification
Mailer. The message you sent did not appear to be in response to a notification. If you are
responding to a notification, please use the response template that was included with your
notification. Take care to include the 'NID' line of the template in your reply. If you are not
responding to a notification, please do not send mail to this account. Important: Some mail
clients, notably early releases of Microsoft Outlook Express, may not copy the 'NID' line properly
in your response. Please verify that the 'NID' line is included in full and contains the prefix
'NID' and all the details between the square brackets when responding.
When the Workflow Mailer encounters the TAG, it treats it as a Unsolicited Message:         EXCEPTION:[SVC-GSM-WFMLRSVC-63613-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.processSingleMessage(Message)]: 
Processing Message SUBJECT[Out of Office AutoReply: Regional Buyer Assignment 
Message for Purchase Requisition 20103] UI 

oracle.apps.fnd.wf.mailer.IMAPResponseHandler.processSingleMessage(Message)]: 
Preparing to parse [Out of Office AutoReply: Regional Buyer Assignment Message 
for Purchase Requisition 20103] 

The Mailer log will reflect the following:        oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleUnsolicited(EmailParser)]: 
Successfully sent -> [Warning For Unsolicited Mail] [[Joe Shmoe  com>]] 
SVC-GSM-WFMLRSVC-63613-10006 : 
oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.moveMessage(Message, String)]: 
Moving message to Discard

Case #2: In another case the Workflow Mailer stops working due to the following error:



:STATEMENT:[SVC-GSM-WFMLRSVC-1616026-10006 : oracle.apps.fnd.wf.mailer.EmailParser.parseEmail()]:<SUBJECT> SUBJECT[Autoreply-Re: FYI: Remittance Advice]
[Jul 27, 2010 8:28:45 PM EDT]:1280276925427:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:auohscgna07:
140.85.254.149:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-1616026-10006 : oracle.apps.fnd.wf.mailer.EmailParser.parseEmail()]:
[Jul 27, 2010 8:28:45 PM EDT]:1280276925427:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:auohscgna07:
140.85.254.149:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-1616026-10006 : oracle.apps.fnd.wf.mailer.EmailParser.parseEmail()]:
[Jul 27, 2010 8:28:45 PM EDT]:1280276925427:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:auohscgna07:
140.85.254.149:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-1616026-10006 : oracle.apps.fnd.wf.mailer.EmailParser.parseEmail()]:
[Jul 27, 2010 8:28:45 PM EDT]:1280276925427:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:auohscgna07:
140.85.254.149:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-1616026-10006 : oracle.apps.fnd.wf.mailer.EmailParser.parseEmail()]:
[Jul 27, 2010 8:28:45 PM EDT]:1280276925427:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:auohscgna07:
140.85.254.149:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-1616026-10006 : oracle.apps.fnd.wf.mailer.EmailParser.parseEmail()]:Processing single -> text/plain; charset=us-ascii;
[Jul 27, 2010 8:28:45 PM EDT]:1280276925428:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:auohscgna07:
140.85.254.149:-1:-1:UNEXPECTED:[SVC-GSM-WFMLRSVC-1616026-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.processSingleMessage(Message)]:Problem reaching content in step {Parsing email} -> javax.mail.internet.ParseException

After that, every 5 minutes I get the following error:
[Jul 27, 2010 3:04:34 PM EDT]:1280257474343:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:auohscgna07:140.85.254.149:-1:-1:UNEXPECTED:[SVC-GSM-WFMLRSVC-1616026-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.open()]:Unable to connect to mail store



Changes
Case #1: SQL> select name, tag_id, action, pattern from wf_mailer_tags

-WF_DEFAULT- 1 UNDELVRD -- Unsent message follows --
-WF_DEFAULT- 2 UNDELVRD Host unknown
-WF_DEFAULT- 3 UNDELVRD The following addresses had delivery problems
-WF_DEFAULT- 4 UNDELVRD Transcript of session follows
-WF_DEFAULT- 5 UNAVAIL Auto-Reply: 
-WF_DEFAULT- 6 UNAVAIL Auto-reply: 
-WF_DEFAULT- 7 UNAVAIL Returned mail:
-WF_DEFAULT- 8 IGNORE SENDMAIL
-WF_DEFAULT- 9 IGNORE POSTMASTER
-WF_DEFAULT- 10 IGNORE Warning For Unsolicited Mail
-WF_DEFAULT- 21 IGNORE Warning: Your previous response to this message was 
invalid
-WF_DEFAULT- 11 IGNORE Warning: Your previous response to this message was 
invalid
wfprod 41 Out Office AutoReply: IGNORE


Case #2: SQL> select name, tag_id, action, pattern from wf_mailer_tags

-WF_DEFAULT- 1 UNDELVRD -- Unsent message follows --
-WF_DEFAULT- 2 UNDELVRD Host unknown
-WF_DEFAULT- 3 UNDELVRD The following addresses had delivery problems
-WF_DEFAULT- 4 UNDELVRD Transcript of session follows
-WF_DEFAULT- 5 UNAVAIL Auto-Reply: 
-WF_DEFAULT- 6 UNAVAIL Auto-reply: 
-WF_DEFAULT- 7 UNAVAIL Returned mail:
-WF_DEFAULT- 8 IGNORE SENDMAIL
-WF_DEFAULT- 9 IGNORE POSTMASTER
-WF_DEFAULT- 10 IGNORE Warning For Unsolicited Mail
-WF_DEFAULT- 21 IGNORE Warning: Your previous response to this message was 
invalid
-WF_DEFAULT- 11 IGNORE Warning: Your previous response to this message was 
-WFMAIL 22IGNORE Remittance Advice


Cause
Case #1 The Workflow Mailer Configuration was done and the Node Name was defined with lowercase lettters opposed to all UPPERCASE.
The Workflow Node Name must be capitalized during configuration.
If not, when creating a new tag, the NAME column for the tag will default to
the same name in the initial configuration. If not capitalized, the tag will
not be recognized, therefore the mailer will send an undoliciated message
and direct the intended message from its INBOX to the DISCARD folder.

Case #2: The Workflow Mailer is attempting to Parse the following Subject: Autoreply-Re: FYI: Remittance Advice
What is currently setup as a MAILER Tag has all the words divided into multiple tags when it should be just 1 tag
Solution
Case #1:
1. In the OAM >Workflow Mailer Configuration, change the Mailer Node Name to UPPERCASE Letters opposed  Lowercase
2. In the Mailer Tags, Delete the Out of Office Reply:
3. Save the Settings.

4. Stop and Restart the Mailer

5. In the Mailer Tags, Redo do the Out of Office Reply:

6. Now the Node Name in the Tag should be in Uppercase

SQL > select * from wf_mailer_tags

7. Test the Out of Office AutoReply: email now.
Case #2 
1. In the OAM >Workflow Mailer Configuration, add a TAG for  Subject: Autoreply-Re: FYI: Remittance Advice

2. In the Mailer Tags, Delete the following tags:

WFMAIL 25 IGNORE Autoreply
WFMAIL 26 IGNORE Re:
WFMAIL 42 IGNORE Remittance Advice
WFMAIL 43 IGNORE Automatic-Reply
WFMAIL 44 IGNORE FYI



3. Create the following new Mailer Tag:

WFMAIL 25 IGNORE Autoreply-Re: FYI: Remittance Advice


4. Save the Settings.

5. Stop and Restart the Mailer

6. SQL > select * from wf_mailer_tags

7. Test the Remittance Advise Workflow now

No comments: