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:
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: Sean Hoppe on