topic Re: How to kill/Abort job when it is stuck while establishing connection in Talend Studio

How to kill/Abort job when it is stuck while establishing connection

sacuke1 — Sat, 16 Nov 2024 06:03:14 GMT

Hi,

I am trying to kill/Abort job when it is stuck while establishing JDBC connection.

Sometimes it happens that JDBC connection failed to establish and instead of failing my job is getting stuck at tJDBCconnection component.

I tried to check the execution time and forcefully die the job but whenever i connect any the component to tJDBCconnection, it stops working because it is stuck.

Please let me know if there is any solution in talend to fail the job automatically when it is stuck while connecting to database

Re: How to kill/Abort job when it is stuck while establishing connection

Anonymous — Wed, 17 Apr 2019 09:37:14 GMT

Hi @sacuke,

I am not entirely sure what you are asking here. You say "...but whenever I connect any component to tJDBCConnection, it stops working because it is stuck". Do you mean when you use the tJDBCConnection as the connection for another DB component, or when you physically connect it to it? Can you give us a screenshot of what you job looks like. That might help a little

Regards

Richard

Re: How to kill/Abort job when it is stuck while establishing connection

sacuke1 — Wed, 17 Apr 2019 11:15:32 GMT

Hi Richard,

I was trying to say that how to fail the job when it stuck at some component.

Re: How to kill/Abort job when it is stuck while establishing connection

sacuke1 — Wed, 17 Apr 2019 11:19:46 GMT

Hi Richard,

in the screenshot my job is stuck at tpostgrerow component and i have to kill this job automatically.

stuck job.PNG

Re: How to kill/Abort job when it is stuck while establishing connection

Anonymous — Wed, 17 Apr 2019 12:16:40 GMT

Your connection isn't failing there. It looks like your truncate is taking a long time. You need to figure out why this is the case. If the database is doing something, the job will not just stop.

By the way, I would connect your Connection components with OnSubJobOK links and not OnComponentOK links.