Progress transaction is other ID & commiting transaction is other id?

, ,
1

Hi,

Am getting,

[FONT=&quot][ART.114.302] Adapter Runtime (Transaction): Error while committing transaction 940. The transaction in progress is 939.

This is my transaction:

[FONT=&quot][SIZE=2]pub.art.transaction:startTransaction
SEQUENCE(Try/Catch)

  • SEQUENCE(Try)
    • Update Operation using local_transaction
    • Loop (start)
      • Select (Check particular record present in db table or not) (NO_TRANSACTION)
      • Branch(On output)
        • $null: INSERT (LOCAL_TRANSACTION)
        • $default: UPDATE (LOCAL_TRANSACTION)
      • pub.art.transaction:commitTransaction
  • SEQUENCE(Catch)
    • GetLastError
    • Rollback[/size][/font]

Any idea for reason am getting this error?

Regards,
Sam
[/FONT]

2

Forgot to add this:

Whenever am doing for single record insert/update its working fine. If the Loop is for more than one item, getting the error [[ART.114.302] Adapter Runtime (Transaction): Error while committing transaction 940. The transaction in progress is 939]

3

It worked for me…
Made a mistake by placing the commit within branch statement.

Thank you All.