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
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
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
[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:
[Jul 27, 2010 8:28:45 PM EDT]:1280276925427:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:auohscgna07:
[Jul 27, 2010 8:28:45 PM EDT]:1280276925427:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:auohscgna07:
[Jul 27, 2010 8:28:45 PM EDT]:1280276925427:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:auohscgna07:
[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
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
-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
-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
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.
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
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.
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
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:
Post a Comment