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

webMethods Simple interval tasks and Complex repeating tasks are breaking.

  • 1.  webMethods Simple interval tasks and Complex repeating tasks are breaking.

    Posted Mon November 16, 2015 11:35 AM

    Hi

    I have a problem with webMethods schedulers.
    They are breaking and showing their next run time as 0. For again to start the schedulers I need to restart the Integration server.
    Instead of restarting the server, if I disable and enable the scheduler that schedule is working for one time and again stopping at 0. i.e; the next interval as 0 seconds.

    The error logged at time of schedulers break time is :

    java.sql.SQLException: Cannot issue commit in a nested connection when there is a pending operation in the parent connection.

    IS version 7.1.2

    Simple Interval repeating interval is like 5 seconds, 7 seconds and 10 seconds like wise… Many Thanks in advance.

    Thanks
    Hari


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


  • 2.  RE: webMethods Simple interval tasks and Complex repeating tasks are breaking.

    Posted Mon November 16, 2015 12:04 PM

    Hi Hari,

    what is your Fix-Level for IS 7.1.2?

    What is your DataDirect-Driver-Version (common/lib/ext/sl53-cj??.jar)?
    Any SCG_7.1.2_DataDirect-Fix applied?

    What is your databse vendor and version?

    Regards,
    Holger


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


  • 3.  RE: webMethods Simple interval tasks and Complex repeating tasks are breaking.

    Posted Thu November 19, 2015 07:22 AM

    Hi Holger

    Thanks for your response.

    The JDBC Adapter fix level is - JDBC_6-5_Fix11

    The DataDirect-Driver-Version is - common/lib/ext/sl53-cj40.jar

    The Database vendor and version is - IBM-DB2 (9.7.7)

    Thanks
    Hari


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


  • 4.  RE: webMethods Simple interval tasks and Complex repeating tasks are breaking.

    Posted Thu November 19, 2015 09:12 AM

    Hi Hari,

    JDBC-Adapter is not involved in IS-internal Database-handling.
    Latest Fix available is Fix51.

    I just checked the System Requirements Guide for webMethods 7.x and found out that wM 7.x only supports IBM DB2 up to 9.5.

    Can you open the sl53_cj40.jar with JAR or 7zip and extract the following files:

    • fixes_40_???.txt
    • jdbcreadme_40_???.txt
      The question marks refer to the Buildnumber of the DataDirect driver.
      I am not sure about the DataDirect 4.0 Driver but for SCG_7.1.3_DataDirect42_Fix3 it is 0011.
      The original DataDirect 3.6 shipped with IS 7.1.2 has Buildnumber 0007 here.

    Which sl53_cj??.jar is listed in the classpath in the IntegrationServer/bin/ini.cnf?

    As an option for a workaround you can download the SCG_7.1.3_DataDirect40_Fix3 resp. SCG_7.1.3_DataDirect42_Fix3 and test these.

    What is your IS_7.1.2_Core Fix-Level?
    Any SCG_7.1.2_* applied?

    Anyway:
    You should consider upgrading to 7.1.3 with latest Fixes soon for planning an upgrade to a more recent (and supported) 9.x version.

    Regrads,
    Holger


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


Related Content