Database error - I/O Error: Software caused connection abort

Database I/O Error: Software caused connection abort

Scenario:

During a normal, daily SQL select a database exception error occurs in the EBI Auditor. This error is unexpected.

Issue:

EXTOL Business Integrator is unable to make a connection to the JDBC DataSource. 90% of the time the issue resides on the database (ERP) side.

EXTOL error message:


EXTOL Business Integrator I/O Error: Software caused connection abort

Starting Comm
Invoking Interface Adapter.
Name : BOSS_JDE_Exp_Ship_DB_Adapter_Select
Version : 09-17-2013
Interaction : Select
SQLException:
Message : I/O Error: Software caused connection abort: recv failed
State : 08S01
Error Code : 0
Stack trace: java.sql.SQLException: I/O Error: Software caused connection abort: recv failed
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1053)

Resolution:

Contact IT's infrastructure team to determine if there are database related issues. At this point, it is is NOT an EXTOL Business Integrator issue.



By: on
A free web counter provided by GoStats.