com.microsoft.sqlserver.jdbc.SQLServerException: Connection timed out (Read failed)

%3CLINGO-SUB%20id%3D%22lingo-sub-2880382%22%20slang%3D%22en-US%22%3Ecom.microsoft.sqlserver.jdbc.SQLServerException%3A%20Connection%20timed%20out%20(Read%20failed)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2880382%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20an%20ETL%20job%20which%20will%20load%20data%20from%20SQL%20server%202012%20to%20Azure%20SQL%20Server.%20All%20the%20data%20from%20source%20will%20be%20fetched%20and%20inserted%20into%20destination.%20I%20am%20running%20multiple%20jobs%20in%20parallel.%3C%2FP%3E%3CP%3EI%20am%20facing%20the%20below%20error.%20When%20anyone%20of%20the%20job%20fails%20due%20to%20this%2C%20all%20the%20other%20jobs%20running%20in%20parallel%20also%20fails%20due%20to%20read%20time%20out.%3C%2FP%3E%3CP%3E%3CSTRONG%3Ecom.microsoft.sqlserver.jdbc.SQLServerException%3A%20Connection%20timed%20out%20(Read%20failed)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20How%20to%20increase%20the%20timeout%3F.%20Is%20there%20a%20way%20to%20increase%20timeout%20for%20each%20query%3F%3C%2FP%3E%3CP%3E2.%20How%20to%20prevent%20other%20jobs%2Fqueries%20failing%20when%20one%20job%2Fquery%20fails%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello All,

 

I have created an ETL job which will load data from SQL server 2012 to Azure SQL Server. All the data from source will be fetched and inserted into destination. I am running multiple jobs in parallel.

I am facing the below error. When anyone of the job fails due to this, all the other jobs running in parallel also fails due to read time out.

com.microsoft.sqlserver.jdbc.SQLServerException: Connection timed out (Read failed)

 

1. How to increase the timeout?. Is there a way to increase timeout for each query?

2. How to prevent other jobs/queries failing when one job/query fails?

 

Thanks,

0 Replies