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.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Error in is while executing process model

  • 1.  Error in is while executing process model

    Posted Tue July 28, 2009 01:26 PM

    HI ALL,

    aM USING mW7.1.1

    2009-07-28 16:53:27 IST [ISP.0090.0003C] This is small order
    2009-07-28 16:53:28 IST [ISP.0090.0003C] This is small order
    2009-07-28 17:12:53 IST [CommonLib.MWS.0002W] DB Server disconnected. Will try to reconnect
    2009-07-28 17:12:53 IST [CommonLib.MWS.0001W] [wm-cjdbc36-0007][Oracle JDBC Driver]No more data available to read.
    2009-07-28 17:13:12 IST [LGU.0002.0016C] Error releasing cluster lock: Exception encountered trying to release excusive lock for target(WmLogUtil043901ab-84c7-4703-9808-c2837d1f3e5c), exception(java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver]Connection reset by peer: socket write error)
    2009-07-28 17:14:02 IST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc36-0007][Oracle JDBC Driver]Connection reset by peer: socket write error

    REGARDS,
    ANIL KUMAR ELLENDULA


    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Error in is while executing process model

    Posted Sat August 01, 2009 08:42 AM

    Hi Anil,

    There are several things that you can check:

    1- Check the db connection whether db is bounce or not.
    2- Optimize the JDBC connection pool settings according to the volume of data you are trying to fetch.
    3- If data volume is too large then try to fetch it in chunks.

    Regards,

    Arsalan.


    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Error in is while executing process model

    Posted Mon August 03, 2009 08:34 AM

    my db connection is fine and jdbc connection pool setting is good.

    how to Optimize the JDBC connection pool settings according to the volume of data you are trying to fetch.
    If my data volume is too large then how to fetch it in chunks.

    please reply me above answers to me.


    #webMethods
    #Integration-Server-and-ESB