| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Transaction Issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| Dhiren |
 Posted: Wed Aug 10, 2005 3:56 am Post subject: Transaction Issue |
 |
|
Novice
Joined: 27 Jan 2005
Posts: 17
|
My message flow updates about 7 db2 tables. The flow ends with a compute node that has the esql to insert data into the 7 tables. The Transaction property of this node is set to " Commit ".
Scenario:
Say there are 5 messages to be picked from the input queue and each message update some or all 7 tables depending upon the message content.
This works fine... the message either updates some/all the tables it is required to update or it fails if the message is wrong .
But at times (Very rarely) one of the messages (the first put) is routed to the failure queue with an exception " Transaction will be committed, but a pending automatic transaction exists"
If the same failed message is routed back to the input of the flow , it successfully updates the tables.
Since this does not occur always and the flow works as desired most of the times, it is difficult to simulate the scene.
Any help would be most gratefully received! |
|
| Back to top |
|
 |
| recallsunny |
| Posted: Wed Aug 10, 2005 8:02 am Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
In your flow, does any other Compute node use the Automatic Transactionality with the same database and datasource ? If that is the case, try using different datasource in that Node. (Of course you will have to deal with the Db locking issues.)
Second thing, does your flow run multiple threads..?
 |
|
| Back to top |
|
|
| Dhiren |
| Posted: Wed Aug 10, 2005 9:36 pm Post subject: |
|
|
Novice
Joined: 27 Jan 2005
Posts: 17
|
Hi , thank you so much for your time first of all.
No my flow does not have any other compute node that use the Automatic Transactionality with the same database and datasource.
It does not run multiple threads either.... |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
