(conn=1910) Read timed out

[FGuijarro]

Hi,

I´m using Talend Open Studio 7.3.1

I´m trying to merge 10 tables (one for each month from Jan to Oct) from DB_1 to ONE table in DB_2

• The workspace is on my laptop
• INPUT (10 tables) are on Server_1, DB_1. Each table has around 15.000.000 rows
• OUTPUT is just one table on Server_2, DB_2

To connect to the Server_1 and to the Server_2, I need to connect a VPN.

The process starts OK but after 3-4hours, Talend gives me an error. I think it´s because VPN was disconnected automatically but I´m not sure although my internet conection is still connected.

Can you help me with this, please? The error message is:

Starting job Inteligencia_Negocio_JOB at 21:59 24/10/2020.

[statistics] connecting to socket on port 4000

[statistics] connected

(conn=1910) Read timed out

Exception in component tDBOutput_1 (Inteligencia_Negocio_JOB)

java.sql.SQLException: Cannot do an operation on a closed statement

at org.mariadb.jdbc.MariaDbStatement.checkClose(MariaDbStatement.java:1512)

at org.mariadb.jdbc.ClientSidePreparedStatement.executeBatch(ClientSidePreparedStatement.java:280)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.tDBInput_1Process(Inteligencia_Negocio_JOB.java:1936)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.tDBRow_3Process(Inteligencia_Negocio_JOB.java:977)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.tDBRow_2Process(Inteligencia_Negocio_JOB.java:755)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.tDBRow_1Process(Inteligencia_Negocio_JOB.java:530)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.runJobInTOS(Inteligencia_Negocio_JOB.java:2465)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.main(Inteligencia_Negocio_JOB.java:2314)

[statistics] disconnected

[Anonymous]

Hello,

It looks like the DB connection is closed.

Are you adding tDBclose and tDBcommit components in your work flow? Screenshots of your job design will be preferred.

Best regards

Sabrina

[FGuijarro]

Hi Sabrina,

Thank you for your answer. I really appreciate it!

To connect the DB to the server, it´s always under a VPN so is it possible that VPN start the sleep mode and was disconnected??

This is the design:

Thank you for your feedback!

Best Regards,

Fernando.