Connection reset by peer

[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]

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