Connection drop from Azure SQL DB

chamak — Sat, 16 Nov 2024 07:21:26 GMT

First up environment:

DWH SQL Server: Azure SQL

Two source systems both: Azure SQL

Talend: Talend Integration Cloud running via Remote Engine hosted in Azure VM (Let's call it RE1)

Job design:

one primary job (let's call it J1) parallelizes two child jobs. Each child job parallelizes approx 30 child jobs. so when J1 is fired, all ~60 jobs run in parallel.

Problem: When I ran J1 form talend studio from my PC a number of times it succeeded without any issue every time. However, when migrated to Talend Integration Cloud and the flow is run using our RE1 on Azure VM it is failing intermittently and without any set pattern, having the following error message among a lot others:

Exception in component tDBSP_1 (Load_TBS_LKP_LClientProfile) com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed. ClientConnectionId:8686f299-f863-49ce-aeea-c7301e3bb9e7". at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2826) at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1827) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2391) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2042) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1889) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1120) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:700) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at etl_talend.load_tbs_lkp_lclientprofile_0_1.Load_TBS_LKP_LClientProfile.tFixedFlowInput_1Process(Load_TBS_LKP_LClientProfile.java:2533) at etl_talend.load_tbs_lkp_lclientprofile_0_1.Load_TBS_LKP_LClientProfile$5.run(Load_TBS_LKP_LClientProfile.java:13068) Caused by: java.io.IOException: SQL Server returned an incomplete response. The connection has been closed.

I'm just confused what should be my next course of action? Cheers

Re: Connection drop from Azure SQL DB

Anonymous — Mon, 12 Nov 2018 08:45:02 GMT

Hello,

Have you tried to set SSL preferences to configure your Talend Studio for secure communications with remote servers?

Best regards

Sabrina

topic Re: Connection drop from Azure SQL DB in Talend Studio

Connection drop from Azure SQL DB

Re: Connection drop from Azure SQL DB