topic Re: Talend job stuck at 'Starting' in Talend Studio

Talend job stuck at 'Starting'

Talha1 — Sat, 16 Nov 2024 00:03:04 GMT

My Talend job hangs after I click on Run at the point where it says 'Starting'. The output as seen in the case of TLogRow is perfect for me but the issue starts when I try to make the output as my Db. I have tried in the case of PostGreSql Db as well but it still gets stuck at 'Starting'. Please let me know if this is some rookie mistake or something more complicated. Im unsure what else I need to share to help resolve this problem.

Re: Talend job stuck at 'Starting'

veeaar — Wed, 16 Jun 2021 13:26:59 GMT

why are you writing to tlogrow and then to target?

why not directly from the tmap output ?

Re: Talend job stuck at 'Starting'

Anonymous — Thu, 17 Jun 2021 02:43:29 GMT

Hello,

Maybe check the checkbox "Die on error" on the t<DB>Output component and run it to see what is causing it to hang.

Best regards

Sabrina

Re: Talend job stuck at 'Starting'

Talha1 — Thu, 17 Jun 2021 08:07:12 GMT

That is a redundant step but I was using Tlogrow just for the sake of confirming whether any rows are being accepted or not

Re: Talend job stuck at 'Starting'

Talha1 — Thu, 17 Jun 2021 08:07:52 GMT

It doesn't die, it just stays on hang so die on error checkbox didnt make a difference

Re: Talend job stuck at 'Starting'

Talha1 — Thu, 17 Jun 2021 08:10:43 GMT

I just figured out that this job is working fine when I set Action on Table to "Default"/ "Create Table if does not exist". I'm unsure why it only works in this specific case even tho I checked the Db and the table did 'exist'. Im open to suggestions on why this was the case. Thanks!

Re: Talend job stuck at 'Starting'

Anonymous — Thu, 17 Jun 2021 08:32:36 GMT

Hello,

It seems to be a problem with the database. Did you specify the schema in the filed "Table"?

Could you please post your DB connection setting screenshots here and mask your sensitive data?

Best reagards

Sabrina