IBM Support

ERROR SQL State: 08S01 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write error (SCI87523)

Troubleshooting


Problem

ERROR SQL State: 08S01 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write error (SCI87523)

Symptom

When the error occurred, all subsequent executions of the business process failed with the same error until Gentran Integration Suite was restarted.
ERROR [LightweightJDBCAdapter] Error executing sql query "SELECT COUNT(*) AS 'Count' FROM dbo.Orders ord WHERE ord.GT_key IS NULL AND ord.PaymentsPending = 0 AND ord.Void = 0".
ERROR SQL Error Code: 0
ERROR SQL State: 08S01 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write error
ERROR [JDBCService] got a bad connection, trying again

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

PRI6725

Document Information

More support for:
IBM Sterling B2B Integrator

Software version:
All

Document number:
440109

Modified date:
11 February 2020

UID

swg21529877

Manage My Notification Subscriptions

Page Feedback