I was getting a similar kind of error as discussed in the following posting:
[url=“wmusers.com”]wmusers.com
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
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