| Author |
Message
|
| JYama |
 Posted: Fri Mar 14, 2008 12:10 am Post subject: Unit of work of WMB FowOrder node? |
 |
|
Master
Joined: 27 Mar 2002
Posts: 281
|
Hello, experts,
I'd like to just check on the spec of WMB FlowOrder node.
I know this node has two terminals, 1st and 2nd.
What happens if an error occures in a message flow wired 2nd terminal?
Is this correct that both flows wired 1st and 2nd will be rollbacked at the same time?
In other words, the flow wired '1st teminal' will fail even if it succeeded, for example, MQOutput?
Regards,
 |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Fri Mar 14, 2008 12:53 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
What i experienced
Flow Order Node
It goes to the First terminal and then to Second terminal,
If the first is success then only it goes to Second terminal
If First is successfull and Second is failed , it wont roll back the first trancation happened.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| AkankshA |
| Posted: Fri Mar 14, 2008 1:05 am Post subject: Re: Unit of work of WMB FowOrder node? |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
| JYama wrote: |
Hello, experts,
I'd like to just check on the spec of WMB FlowOrder node.
I know this node has two terminals, 1st and 2nd.
What happens if an error occures in a message flow wired 2nd terminal?
Is this correct that both flows wired 1st and 2nd will be rollbacked at the same time?
In other words, the flow wired '1st teminal' will fail even if it succeeded, for example, MQOutput?
Regards,
|
not sure of what happens actually...
if u want a complete rollback even if an error occures in a message flow wired 2nd terminal.. how about using different terminals of compute node(in V6 only)
_________________
Cheers |
|
| Back to top |
|
|
| JYama |
| Posted: Fri Mar 14, 2008 1:12 am Post subject: |
|
|
Master
Joined: 27 Mar 2002
Posts: 281
|
Thank you for your comment, Gaya3.
Which version of WMB did you use?
Actually, one of my colleagues tried a simulation like this;
MQOutput1 wired 1st terminal with correct queue name ,
MQOutput2 wired 2nd terminal with incorrect queue name .
As a result, there were no messages on both queues indicated by the MQOutput nodes.
Therefore, it seemed that the message flow worked as a ONE transaction...
Last edited by JYama on Sun Mar 16, 2008 4:08 pm; edited 1 time in total |
|
| Back to top |
|
|
| fschofer |
| Posted: Fri Mar 14, 2008 1:28 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
the behaviour of the MQOutput Node behind 1st terminal depends on the transaction setting of the node and the message flow.
If for example the transaction mode of the MQOutput Node is set to 'No'
then the message written by this node will remain even if a exception occurs behind 2nd terminal.
Greetings
Frank |
|
| Back to top |
|
|
| JYama |
| Posted: Fri Mar 14, 2008 1:41 am Post subject: |
|
|
Master
Joined: 27 Mar 2002
Posts: 281
|
Thank you very much for prompt responses, all! 
Last edited by JYama on Sun Mar 16, 2008 4:00 pm; edited 1 time in total |
|
| Back to top |
|
|
| sunny_30 |
| Posted: Fri Mar 14, 2008 7:07 am Post subject: |
|
|
Master
Joined: 03 Oct 2005
Posts: 258
|
Hi All,
A question on the same topic.
What happens if I propagate multiple output messages out of the 1st-terminal connected to the Flow-order. Note that I set the MQoutput node Transaction to 'yes'.
If an error happens in the 2nd-terminal, will all the 'propagated' messages from the 1st-terminal of the FlowOrder roll back?
Thanks,
Sunny. |
|
| Back to top |
|
|
| JYama |
| Posted: Sun Mar 16, 2008 4:24 pm Post subject: |
|
|
Master
Joined: 27 Mar 2002
Posts: 281
|
| sunny_30 wrote: |
| If an error happens in the 2nd-terminal, will all the 'propagated' messages from the 1st-terminal of the FlowOrder roll back? |
According to the discussion so far, I believe all of the mesages will be rollbacked.
As fschofer said, it depends on the transaction mode of the MQOutput Node, so if you set this property 'Yes', the message flow works as ONE transaction.
I guess, if you want to handle your messages in different UOW scope, you may need to consider independent message flows. 
Regards, |
|
| Back to top |
|
|
| svu |
| Posted: Thu Aug 26, 2010 1:03 am Post subject: |
|
|
Voyager
Joined: 30 Jan 2006
Posts: 99
|
| JYama wrote: |
As a result, there were no messages on both queues indicated by the MQOutput nodes.
Therefore, it seemed that the message flow worked as a ONE transaction... |
I see opposite behavior. 1st output of FlowOrder connected to transactional MQOutput, 2nd output connected to another MQOutput, transactional as well. If 2nd output fails because of the invalid message (parsing error), I am still getting the message on the first queue. Irritating. Perhaps I have to fallback to Compute-based workaround (using out and out1) |
|
| Back to top |
|
|
|
|
