IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

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

  • 1.  Progress transaction is other ID & commiting transaction is other id?

    Posted Tue December 08, 2009 08:59 AM

    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]


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Progress transaction is other ID & commiting transaction is other id?

    Posted Tue December 08, 2009 09:06 AM

    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]


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Progress transaction is other ID & commiting transaction is other id?

    Posted Tue December 08, 2009 09:46 AM

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

    Thank you All.


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


Related Content