topic Re: IO Error: Connection reset by peer in Talend Studio

IO Error: Connection reset by peer

Anonymous — Sat, 16 Nov 2024 04:28:26 GMT

Hi All,

I have two jobs (Parent and Child). Parent Job calls the child job in 4 parallel paths to full load 23 tables.

In the process, the jobs were able to load a few of the tables without any issues. But at some point, the Child job is throwing the below error.

IO Error: Connection reset by peer
java.sql.SQLRecoverableException: IO Error: Connection reset by peer

Did anyone face this issue? If so, please share your thoughts.

Thank you,

Re: IO Error: Connection reset by peer

manodwhb — Fri, 04 Oct 2019 08:50:42 GMT

@bojareddy ,what is your Target ? if it is Microsoft SQL server ,are you using Open Source JTDS DB verion,while creating connection in Talend? If yes change it to Microsoft and let me know that issue still exists?

Re: IO Error: Connection reset by peer

Anonymous — Fri, 04 Oct 2019 09:06:12 GMT

Thanks, Manohar for the reply!

My source and target are Oracle Databases.

Any info on why this kind of error occurs?

Thank you,

Re: IO Error: Connection reset by peer

TRF — Fri, 04 Oct 2019 09:35:39 GMT

May occur if there is a network error (connection is loosed between the machine on which the job is running and the database server)

Re: IO Error: Connection reset by peer

manodwhb — Fri, 04 Oct 2019 09:59:41 GMT

@bojareddy ,check the below link may be same issue.

https://community.talend.com/t5/Design-and-Development/resolved-Connection-reset-on-tOracleConnection/td-p/103210

Re: IO Error: Connection reset by peer

Anonymous — Fri, 04 Oct 2019 19:27:00 GMT

Hi,

If you are using a shared Oracle connection for loading data using tOracleConnection, then you need to make sure that the connection is not closed till all the parallel processing elements are complete. If you are making any commit using tOracleCommit, then you need to uncheck the close connection option till all the executions are complete. You can use a tOracleClose later in the process or in PostJob area of the Talend job.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved