Plz help more than one Local_Transaction Error

Hi,

I was getting a similar kind of error as discussed in the following posting:
http://www.wmusers.com/wmusers/messages/117/36127.shtml?1116869622

but then I was getting this error when working with MQ Adapter. I wish to implement the implicit transaction but couldnt figure out of what changes need to be done to make sure that there is no more than one local_trasaction? We are getting this error every alternate time.

Could someone please provide the better ways? I am stuck at this point and have spend lots of time figuring different ways.

Adapter Runtime: Error Logged. See Error log for details. Error: [ART.117.4036] Adapter Runtime (Adapter Service): Unable to commit transaction. Transaction state:Transaction is active

Thanks.

Hi,

No takers on this one !!

In JDBC connections, we can specify the Local_Transaction or No_Transaction; but in MQ Adapter I doesnt know where we configure/mention to use Local_Transaction/No_Transaction. Does anyone come across this before?

I was curious to find if we could use couple of start/commit/rollback for different connections but in the same flowservice. For instance, something like this:


-startTransaction 1
-Sequence (on Success)
-Sequence (on failure)
-Adapter Service1 (get Msgs from Queue 1; Connection 1)
-Start Transaction 2
-Sequence (on Success)
-Sequence (on failure)
-Adapter Service2 (put Msgs into Queue 2; Connection 2)
-Commit Tramsaction 2
-Sequence (on done)
-RollBack Transaction 2
-Commit Transaction 1
-Sequence (on done)
-Rollback Transaction 1

Someone plz help me crack this

Thanks.