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
