webMethods

webMethods

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

  • 1.  Adapter service transaction issue

    Posted Fri October 27, 2006 05:04 AM

    I have a flow service A . I use some jdbc adapter services in it.All adapter services are in same db connection which is LOCAL_TRANSACTION type.And service A will be repeat invoked by another main service B

    code of service A like below:

    …
    StartTransaction(transactionname=currentDatetime)
    Sequence (Exit on success)
    Sequence (Exit on failure)
    jdbc adapter service (select data from one table)
    jdbc adapter service (insert data to table a)
    jdbc adapter service (update data to table b)
    …
    commit transaction
    Sequence (Exit on done)
    rollbackTransaction
    error handler
    …

    Then I see those message in serverlog

    [13102]2006-10-26 23:28:25 EDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.114.305] Adapter Runtime (Transaction): Error while rolling back transaction 2006102611282411. The transaction in progress is Root connection state.

    The same log keeps coming out.I don’t how to deal with this:( ,please help me.Thanks

    ProductwebMethods Integration ServerVersion6.1 build 132


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


  • 2.  RE: Adapter service transaction issue

    Posted Fri October 27, 2006 07:19 PM

    transactionName in pub.art.transaction:rollbackTransaction should correspond to the transactionname in pub.art.transaction:startTransaction



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


  • 3.  RE: Adapter service transaction issue

    Posted Fri October 27, 2006 07:59 PM

    Hi Shen,

    Make sure your start transaction and commit transaction are there in the same high level sequence

    Rgds,
    Pradeep


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


  • 4.  RE: Adapter service transaction issue

    Posted Fri October 27, 2006 08:15 PM

    Change Transaction Type to “NO_TRANSACTION” and give a try. Hope, it would resolve your problem.


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


Related Content