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
Expand all | Collapse all

Connection reset by peer

  • 1.  Connection reset by peer

    Posted Wed June 11, 2008 12:16 PM

    [FONT=Arial][SIZE=2]2008-06-11 08:00:25 EST FastTrack.CIFAPCA:selectUnsentFees Io exception: Connection reset by peer: socket write error Stack trace data … a17182d0373811dda4199b4ac7508681 a17182d0373811dda4199b4ac7508681 a17182d0373811dda41d9b4ac7508681
    2008-06-11 08:00:25 EST FastTrack.CIFAPCA:selectUnsentFees [ADA.1.316] Cannot execute the SQL statement “SELECT t1.SWCASEREF,t1.REQUESTID,t1.FEEACCNO,t1.CUSTNAME,t1.FEEAMT,t1.FEECHARGED,t1.FEEDESCR,t1.FEETRNCODE,t1.TRACEACC,t1.TRACEACCNAME,t1.FEEGLACC FROM STAFFWARE_OWNER.FEES t1 WHERE (t1.SENTDATE IS NULL AND ( LENGTH(t1.FEEACCNO) > 2 AND LENGTH(t1.FEEACCNO) < 16 ) AND ( t1.FEETRNCODE = ‘13’ OR t1.FEETRNCODE = ‘50’ ) AND t1.FEEAMT > 0) “. " (17002) Io exception: Connection reset by peer: socket write error” Io exception: Connection reset by peer: socket write error Stack trace data … a17182d0373811dda4199b4ac7508681 a17182d0373811dda4199b4ac7508681 a17182d0373811dda41d9b4ac7508681
    2008-06-11 08:00:25 EST FastTrack.CIFAPCA:selectUnsentFees Io exception: Connection reset by peer: socket write error Stack trace data … a17182d0373811dda4199b4ac7508681 a17182d0373811dda4199b4ac7508681 a17182d0373811dda41d9b4ac7508681
    2008-06-11 08:00:25 EST FastTrack.CIFAPCA:selectUnsentFees [ADA.1.208] Cannot disconnect from the database. " (17002) Io exception: Connection reset by peer: socket write error” Io exception: Connection reset by peer: socket write error Stack trace data … a17182d0373811dda4199b4ac7508681 a17182d0373811dda4199b4ac7508681 a17182d0373811dda41d9b4ac7508681
    2008-06-11 08:00:25 EST InfrastructureServices.adapters:OracleAdapter An error occurred while attempting to destroy connection InfrastructureServices.adapters:OracleAdapter(35) Stack trace data … a17182d0373811dda4199b4ac7508681 a17182d0373811dda4199b4ac7508681 a17182d0373811dda41d9b4ac7508681
    2008-06-11 08:00:25 EST FastTrack.CIFAPCA:selectUnsentFees [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service FastTrack.CIFAPCA:selectUnsentFees. [ADA.1.316] Cannot execute the SQL statement "SELECT t1.SWCASEREF,t1.REQUESTID,t1.FEEACCNO,t1.CUSTNAME,t1.FEEAMT,t1.FEECHARGED,t1.FEEDESCR,t1.FEETRNCODE,t1.TRACEACC,t1.TRACEACCNAME,t1.FEEGLACC FROM STAFFWARE_OWNER.FEES t1 WHERE (t1.SENTDATE IS NULL AND ( LENGTH(t1.FEEACCNO) > 2 AND LENGTH(t1.FEEACCNO) < 16 ) AND ( t1.FEETRNCODE = ‘13’ OR t1.FEETRNCODE = ‘50’ ) AND t1.FEEAMT > 0) “. " (17002) Io exception: Connection reset by peer: socket write error” Io exception: Connection reset by peer: socket write error Stack trace data … a17182d0373811dda4199b4ac7508681 a17182d0373811dda4199b4ac7508681 a17182d0373811dda41d9b4ac7508681
    2008-06-11 08:00:25 EST FastTrack.CIFAPCA:selectUnsentFees com.wm.pkg.art.error.DetailedSystemException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service FastTrack.CIFAPCA:selectUnsentFees. [ADA.1.316] Cannot execute the SQL statement “SELECT t1.SWCASEREF,t1.REQUESTID,t1.FEEACCNO,t1.CUSTNAME,t1.FEEAMT,t1.FEECHARGED,t1.FEEDESCR,t1.FEETRNCODE,t1.TRACEACC,t1.TRACEACCNAME,t1.FEEGLACC FROM STAFFWARE_OWNER.FEES t1 WHERE (t1.SENTDATE IS NULL AND ( LENGTH(t1.FEEACCNO) > 2 AND LENGTH(t1.FEEACCNO) < 16 ) AND ( t1.FEETRNCODE = ‘13’ OR t1.FEETRNCODE = ‘50’ ) AND t1.FEEAMT > 0) “. " (17002) Io exception: Connection reset by peer: socket write error” Io exception: Connection reset by peer: socket write error Stack trace data … a17182d0373811dda4199b4ac7508681 a17182d0373811dda4199b4ac7508681 a17182d0373811dda41d9b4ac7508681
    2008-06-11 08:00:26 EST FastTrack.support.database:oracleAdapterMonitor Io exception: Connection reset by peer: socket write error Stack trace data … a17182d0373811dda4199b4ac7508681 NULL a17182d0373811dda4199b4ac7508681
    2008-06-11 08:00:26 EST FastTrack.support.database:oracleAdapterMonitor [ADA.1.208] Cannot disconnect from the database. " (17002) Io exception: Connection reset by peer: socket write error” Io exception: Connection reset by peer: socket write error Stack trace data … a17182d0373811dda4199b4ac7508681 NULL a17182d0373811dda4199b4ac7508681
    2008-06-11 08:00:26 EST InfrastructureServices.adapters:OracleAdapter An error occurred while attempting to release connection InfrastructureServices.adapters:OracleAdapter(36)

    Is this becoz oracle db server is down.
    Please kindly respond
    [/size][/font]


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Connection reset by peer

    Posted Thu June 12, 2008 03:14 PM

    This means that Oracle terminated your connection. It normally occurs due to a timeout or a restart. Suggestion: check your connection pool parameters. If your minimum number of connections is set to anything other than zero, set it to zero. This ensures that stale connections are not left in the pool.

    • Percio

    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services