IO Error: Connection reset by peer

[Anonymous]

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,

[manodwhb]

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

[Anonymous]

Thanks, Manohar for the reply!

My source and target are Oracle Databases.

Any info on why this kind of error occurs?

Thank you,

[TRF]

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

[manodwhb]

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

https://community.talend.com/t5/Design-and-Development/resolved-Connection-reset-on-tOracleConnectio...

[Anonymous]

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