topic Re: Io exception: Software caused connection abort: in Talend Studio

Io exception: Software caused connection abort:

Anonymous — Mon, 09 May 2016 05:14:23 GMT

Hi Can anyone help me on this. This project, in most of the time, it has no problem. Once a while I will get this error. Whenever we re-run the project the, the job will execute with no error.
The question is, is there any particular thing I may need to configure to avoid this irritating issue?.
The error is paste below
java.sql.SQLException: Io exception: Software caused connection abort: recv failed
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:566)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:418) at oracle.jdbc.driver.PhysicalConnection.<init>

To see the whole post, download it here

Re: Io exception: Software caused connection abort:

Anonymous — Mon, 09 May 2016 06:43:14 GMT

Most likely, this is a network timeout issue.
You need to investigate this as it is unlikely to be down to Talend.
From a Talend point of view, you could add some exception handling so that you could retry these operations.

Re: Io exception: Software caused connection abort:

Anonymous — Mon, 09 May 2016 08:07:49 GMT

Hi,
yes we want to investigate but not sure where to start. Like you said, it could be network time out but the customer say no issue with the database connection.
We want to know
1. What happen to the connection?
2. Why this could happen? can connection closed? Not enough memory?
3. Where I can put the tracing so that I will get a more comprehensive information to investigate?