Could you please indicate on which talend build version you got this issue? What's your DB source? Any information will be preferred.
Thanks for your response. I am using Talend 7.1.1. My source is Salesforce and my target is Microsoft SQL Server which is hosted on Azure cloud. Whenever i execute the job it fails in 90% case and pass only 10%. I already tried with reducing batch size but no permanent solution. It always gives error that
I/O error : connection is reset by peer : socket write error
Exception in component tDBOutput_1
Java.sqlbatchupdateexception I/O error : Connection reset
Any help is greatly appreciated.
Thanks in advance.
Is it the same result when you use tDBConnection component in your job? Are you using one database connection, that is subsequently used by multiple threads? Your Job design screenshots will be helpful for us to address your issue.
Looks like issue was with selected db version while creating the connection. Earlier it was Open Source JTDS then i changed to Microsoft and it worked for me. Hope it will help some other folks.
Thanks for your help.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema