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>
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.
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?
