| Author |
Message
|
| bprasana |
 Posted: Fri Aug 02, 2013 7:21 am Post subject: RollBack Strategy for batch Request |
 |
|
Disciple
Joined: 18 Apr 2005
Posts: 179
|
Hi,
I am using WMB 8.0.0.1.
We receive a request as SOAP over HTTP.
at ESB we have to split the message into multiple parts and send them one by one to MQ.
Requirement is ROLLBACK ONLY failed messages and not the entire batch. We are supposed to continue processing till the last record.
Exception needs to be raised only for failed messages.
If I use a loop to send multiple propagate statements on any failure during the mapping or during the 'PUT to Q', the entire batch gets rolled back.
We thought of having a try catch node before this 'while loop' compute nde and then try to record the exception list in Catch path. And connect the catch path back to same while loop so that while loop processes from where it has left. We are setting suitable Environment variables to ensure while loop processes only from where it has left.
in the catch path we also include a flow order node to first send the message back to Main path and then Throw exception after all records are processed.
Conceptually this should work. But Looks like a complex solution for a simple problem. So Is there a better strategy? What approach did you take? |
|
| Back to top |
|
 |
| bprasana |
| Posted: Fri Aug 02, 2013 7:25 am Post subject: sorry please delete this post |
|
|
Disciple
Joined: 18 Apr 2005
Posts: 179
|
| I dint realise i was posting in a wrong forum. Please delete. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Aug 02, 2013 10:27 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
I would not use WMB transaction mode for this (ie. I would set Transaction mode to off).
I would make use of GlobalCache and do all my transforms one-by-one into GlobalCache objects. When all records have been processed, drop the successfully transformed messages into the queue.
You need to be off 8.0.0.1. Your toolkit needs to be at least 8.0.0.2 iFix 001. Runtime similar.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| dogorsy |
| Posted: Fri Aug 02, 2013 10:38 am Post subject: Re: RollBack Strategy for batch Request |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| bprasana wrote: |
Hi,
I am using WMB 8.0.0.1.
We receive a request as SOAP over HTTP.
at ESB we have to split the message into multiple parts and send them one by one to MQ.
Requirement is ROLLBACK ONLY failed messages and not the entire batch. We are supposed to continue processing till the last record.
Exception needs to be raised only for failed messages.
If I use a loop to send multiple propagate statements on any failure during the mapping or during the 'PUT to Q', the entire batch gets rolled back.
We thought of having a try catch node before this 'while loop' compute nde and then try to record the exception list in Catch path. And connect the catch path back to same while loop so that while loop processes from where it has left. We are setting suitable Environment variables to ensure while loop processes only from where it has left.
in the catch path we also include a flow order node to first send the message back to Main path and then Throw exception after all records are processed.
Conceptually this should work. But Looks like a complex solution for a simple problem. So Is there a better strategy? What approach did you take? |
why are you posting the same question again ?...
I have already given you the answer in the first post |
|
| Back to top |
|
|
| dogorsy |
| Posted: Fri Aug 02, 2013 10:41 am Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| lancelotlinc wrote: |
I would not use WMB transaction mode for this (ie. I would set Transaction mode to off).
I would make use of GlobalCache and do all my transforms one-by-one into GlobalCache objects. When all records have been processed, drop the successfully transformed messages into the queue.
You need to be off 8.0.0.1. Your toolkit needs to be at least 8.0.0.2 iFix 001. Runtime similar. |
nope, the answer is a continue handler in the esql. That was answered in the original post, but some people like asking the same question several times, maybe that way they get more answers ?... |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Aug 02, 2013 10:43 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20703
Location: LI,NY
|
| dogorsy wrote: |
| nope, the answer is a continue handler in the esql. That was answered in the original post, but some people like asking the same question several times, maybe that way they get more answers ?... |
You obviously missed
| Quote: |
| I didn't realize i was posting in a wrong forum. Please delete. |
and sorry I moved instead of simply deleting...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
