topic Getting Error Message java.sql. SQLRecoverableException:Closed Connection while job is running in Production server in Talend Studio

Getting Error Message java.sql. SQLRecoverableException:Closed Connection while job is running in Production server

MDouglas1687874333 — Mon, 11 Mar 2024 09:42:54 GMT

I am getting a Error Code 1Error Message java.sql.SQLRecoverableException:Closed Connection error while a talend job is running on a production server but am unable to diagnose while this is happening.

Does anyone have any suggestions on how I can go about diagnosing this?

Re: Getting Error Message java.sql. SQLRecoverableException:Closed Connection while job is running in Production server

Xiaodi_Shi — Tue, 12 Mar 2024 01:15:45 GMT

Hello,

We need a little bit more information to address your issue.

What's your product server? TMC Remote engine or TAC job server? Are you able to execute it successfully in studio? Is there any more error message or warning in log?

Best regards

Sabrina

Re: Getting Error Message java.sql. SQLRecoverableException:Closed Connection while job is running in Production server

MDouglas1687874333 — Mon, 08 Apr 2024 08:38:39 GMT

Hi,

I'm don't think we have it set up to use either TMC or TAC, as far as i have been made aware, we build the job as a java executable and use other processes to pass the inputs and run them as needed.

There's not really any other errors relating to it since we are using a custom log4j setup to create the logs, we just get the error that the connection has failed.

Re: Getting Error Message java.sql. SQLRecoverableException:Closed Connection while job is running in Production server

Xiaodi_Shi — Mon, 08 Apr 2024 10:08:36 GMT

Hello,

No errors relating to database setup or network configuration?

Best regards

Sabrina

Re: Getting Error Message java.sql. SQLRecoverableException:Closed Connection while job is running in Production server

jlolling — Thu, 11 Apr 2024 07:34:50 GMT

It could be caused by a job design where multiple job entry points exists. Can you post here a screenshot of your job design and the stack trace of the actual error message please?

Re: Getting Error Message java.sql. SQLRecoverableException:Closed Connection while job is running in Production server

MDouglas1687874333 — Mon, 15 Apr 2024 13:12:22 GMT

No, no other errors beyond what I have already posted.

Re: Getting Error Message java.sql. SQLRecoverableException:Closed Connection while job is running in Production server

MDouglas1687874333 — Mon, 15 Apr 2024 13:19:31 GMT

Job is quite large and there are other subjobs but all the errors are occurring in this particular one

Re: Getting Error Message java.sql. SQLRecoverableException:Closed Connection while job is running in Production server

jlolling — Tue, 16 Apr 2024 07:30:26 GMT

In which subjob your job dies?

Does all database input components use the same connection component?

Re: Getting Error Message java.sql. SQLRecoverableException:Closed Connection while job is running in Production server

MDouglas1687874333 — Fri, 03 May 2024 11:25:02 GMT

We believe it is dying on the "In-Scope transactions" component, at least, that is what we can determine from the server logs. And the y do all use the same connection component "Database Connection"