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.  SQL server database locked on dynamic SQL

    Posted Tue December 22, 2015 12:11 AM

    Hi Guys,

    I created one JDBC adapter (dynamic SQL) service with SQL server database. Some times, the adapter service is taking infinite time to execute a simple update query. (Query is something like - update table_name set x in (‘$var’). The var condition selects max 5 rows)

    There is no trace in the logs to investigate why the adapter service taking infinite time. Also, noticed that the table is getting locked. (No other process is using this table at that time). Could you please advise if you know any limitations with dynamic SQL on SQL server?

    webMethods version - V9.8

    Kind regards,
    Raj


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


  • 2.  RE: SQL server database locked on dynamic SQL

    Posted Tue December 22, 2015 02:52 AM

    Raja – Is there any upgrade from DB side, involve DB team to investigate this issue.

    Thanks,


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


  • 3.  RE: SQL server database locked on dynamic SQL

    Posted Thu December 24, 2015 02:01 PM

    Make sure you are on the latest adapter fix levels and try to re-product this scenario. Try running the query directly on DB, check the query execution time.

    If problems still exists contact SAG support with an incident.


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


  • 4.  RE: SQL server database locked on dynamic SQL

    Posted Mon December 28, 2015 02:44 PM

    Raja – Any recent news on this ?

    Thanks,


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


Related Content