| Author |
Message
|
| jeffisom |
 Posted: Fri Oct 12, 2007 12:55 pm Post subject: SendMail Node (IA07) doesn't send multiple emails from flow |
 |
|
Newbie
Joined: 11 Oct 2007
Posts: 7
|
I am using the IA07 SupportPac version 1.10 to send exception emails to our ticket tracking system. Our process collects exceptions and messages throughout and then if any exceptions exist it is put on a queue for the Flow I'm building to pick up.
My flow picks the message up just fine and when I get to the section where I check for multiple messages, I loop through them and propagate a message for the SendMail node to the 'out1' terminal of the compute node for each exception.
Debugging shows that this is happening and all 3 messages in my test case are propagated to the SendMail node and there is even the successful message from the SendMail node's 'out' terminal placed in a queue for all three messages. But I only get one email message. Sometimes the first one and sometimes the second or third one.
Initially the SendMail node was in a subflow so all 3 calls to it were within the same flow context, but I even pulled it out into it's own full-fledged flow and had the same results. 3 messages put on the queue by the propagate from the 'out1' terminal, all 3 consumed by the SendMail flow and 3 successful messages in the out queue for the SendMail flow
The only other pertinent information I can think of is that no matter what the timing the message put time for the success messages is always identical.
Has anyone seen this behavior? |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Oct 12, 2007 4:39 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
...
What does your mailserver log say?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jeffisom |
| Posted: Sun Oct 14, 2007 12:20 pm Post subject: |
|
|
Newbie
Joined: 11 Oct 2007
Posts: 7
|
| I'm working on getting that information from our exchange admins, but subsequent behavior is making me think that the messages are being filtered by the mail server. I'll let you know what I find out Monday. |
|
| Back to top |
|
|
| marcin.kasinski |
| Posted: Mon Oct 15, 2007 4:02 am Post subject: |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
| jeffisom wrote: |
| I'm working on getting that information from our exchange admins, but subsequent behavior is making me think that the messages are being filtered by the mail server. I'll let you know what I find out Monday. |
Two additional questions :
How do you create message ?
How do you separate e-mails ?
_________________
Marcin |
|
| Back to top |
|
|
| jeffisom |
| Posted: Mon Oct 15, 2007 8:54 am Post subject: |
|
|
Newbie
Joined: 11 Oct 2007
Posts: 7
|
The Email messages are created with the following ESQL
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
CALL CopyMessageHeaders();
-- CALL CopyEntireMessage();
DECLARE CCB_Char CHAR;
DECLARE myBroker CHAR;
SET myBroker = BrokerName;
SET CCB_Char = CAST(InputRoot."BLOB"."BLOB" AS CHAR CCSID 1208 ENCODING InputRoot.MQMD.Encoding);
SET OutputRoot.XML.Message."From" = myBroker||'@standard.com';
SET OutputRoot.XML.Message."To" = 'jisom@standard.com';
SET OutputRoot.XML.Message.Subject = Environment.Subject;
SET OutputRoot.XML.Message.Body = CCB_Char;
RETURN TRUE;
END;
The separate emails are created by propagating a blob message with the CCB_Char data to the compute node with the above ESQL for each exception in the incoming message. The CCB_Char message blob is the FW format data required by our ticketing system. |
|
| Back to top |
|
|
| ggriffith |
| Posted: Wed Oct 17, 2007 8:30 am Post subject: |
|
|
Acolyte
Joined: 17 Oct 2007
Posts: 67
|
| You'll find that the MQMD.MsgId is being passed to the mail server and used as the mail MESSAGE-ID. As the MsgId is the same for all propagated messages, the mail system is probably filtering out 2 of your messages. Try assigning a new unique MsgId before propagating, possibly using the UUID or TIMESTAMP functions. |
|
| Back to top |
|
|
| jeffisom |
| Posted: Wed Oct 17, 2007 12:30 pm Post subject: |
|
|
Newbie
Joined: 11 Oct 2007
Posts: 7
|
| Quote: |
| MQMD.MsgId is being passed to the mail server and used as the mail MESSAGE-ID |
That was the missing piece to the puzzle!
Thanks ggriffith! I now get a slew of messages in my inbox!  |
|
| Back to top |
|
|
|
|
