topic Re: com.microsoft.sqlserver.jdbc.SQLServerException:Read timed out in Talend Studio

com.microsoft.sqlserver.jdbc.SQLServerException:Read timed out

Rathesh — Fri, 15 Nov 2024 23:38:06 GMT

Hello All,

I have developed the talend jobs to fetch the data from SQL Server 2012 and push to Azure SQL Server. There is no transformation in it. I have developed a parent job which calls the child jobs and all run in parallel using multithreading option. One more parent job which calls all other parent jobs in parallel using tParallelize component, when I run this all the other jobs will run. While running this I am facing com.microsoft.sqlserver.jdbc.SQLServerException:Read timed out error.

When anyone of the job failed due to this error, all the other jobs running in parallel because of this error. And all the jobs do truncate and load. I am getting read time out on source. Some of the source tables is having more than 7 million records. Max is 34 million. Can anyone help me to resolve this!

Thanks,

Re: com.microsoft.sqlserver.jdbc.SQLServerException:Read timed out

Anonymous — Fri, 15 Oct 2021 04:03:10 GMT

Hello,

Is there any tDBClose component in your work flow?

Please check number of allowed active connection in sql server. make sure you are closing your collection properly after every call.

We will appreciate it a lot if you could post your job design screenshots here.

Best regards

Sabrina

Re: com.microsoft.sqlserver.jdbc.SQLServerException:Read timed out

Rathesh — Thu, 21 Oct 2021 14:23:25 GMT

Hello Sabrina,

I have totally 153 jobs. All the jobs have close connection component and number of parallel connection in SQL Server was set to maximum limit.

Re: com.microsoft.sqlserver.jdbc.SQLServerException:Read timed out

Anonymous — Fri, 22 Oct 2021 03:55:37 GMT

Hello,

Could you please clarify in which Talend version/edition you are? Talend open studio or subscription solution?

With talend subscription solution, you could create a support case on talend support portal so that our colleagues from support team would give you a remote assistance through support cycle with priority.

Best regards

Sabrina

Re: com.microsoft.sqlserver.jdbc.SQLServerException:Read timed out

Rathesh — Fri, 22 Oct 2021 03:59:55 GMT

Its Talend Subscription Big data version 7.3

Re: com.microsoft.sqlserver.jdbc.SQLServerException:Read timed out

Anonymous — Fri, 22 Oct 2021 05:12:01 GMT

Hello,

It's a little hard for us to address your issue on community.

Please create a support case on talend support portal so that our colleagues from support team would give you a remote assistance(zoom meeting) through support cycle with priority.

Best regards

Sabrina

Re: com.microsoft.sqlserver.jdbc.SQLServerException:Read timed out

Rathesh — Fri, 22 Oct 2021 05:55:00 GMT