topic Re: Talend Job Hangs without any errors in Talend Studio

Talend Job Hangs without any errors

Anonymous — Sat, 16 Nov 2024 12:47:24 GMT

My Talend Job hangs without producing an error. I have a mysql input and a MS SQl output. After several thousand rows, the job just hands (the rows are not increasing on the output). I have also tried outputting to a csv and get the same issue. I don't see any errors, if I leave it running for a while, it times out. I can't use trace debug because the issue occurs after about 50,000 rows. The trace debug runs very slow it would take a couple of hours to get to the point it hangs. Is there a different way to debug or to force Talend to display an error?

Re: Talend Job Hangs without any errors

_AnonymousUser — Sat, 24 Sep 2011 20:56:47 GMT

I've got the same error. My job which has several other child jobs and running parallelally, hangs sometimes and other dont.

Re: Talend Job Hangs without any errors

_AnonymousUser — Wed, 05 Oct 2011 07:25:27 GMT

Any idea?
More info: I don't even get an output timeout like the original poster it just stops without any log on workspace\.metadata\.log or in the job logs. No exception ... no nothing
* I've tested it in 4.2.3, Talend 5M3, M4 and M5.

I use parallel execution in iterates so maybe its a Thread deadlock. How can I debug this?

Re: Talend Job Hangs without any errors

Anonymous — Tue, 13 Dec 2011 16:37:23 GMT

This is happening to me too without any error...

Re: Talend Job Hangs without any errors

Anonymous — Sat, 01 Nov 2014 10:37:06 GMT

Hello
I have the same issue plze Help,
I don't even get an output timeout like the original poster it just stops without any log on workspace\.metadata\.log or in the job logs. No exception ... no nothing

Re: Talend Job Hangs without any errors

Anonymous — Sat, 01 Nov 2014 12:59:55 GMT

Do you run the job in the studio, on a jobserver or as standalone job?

Re: Talend Job Hangs without any errors

Anonymous — Mon, 03 Nov 2014 06:48:08 GMT

Hi nadhem,

Could you please give us more information about your current job situation? Screenshots will be preferred.
Best regards
Sabrina

Re: Talend Job Hangs without any errors

Anonymous — Fri, 14 Nov 2014 17:54:18 GMT

I am getting the same thing.
I am trying to get the lastInsertId but the logger shows only until id 554 but I see that 1315 rows have been inserted.
I get no errors, it just hangs there.
I am using:
Version: 5.6.0
Build id: V5.6.0_20141024_1545
On windows 7 Pro 64 bit.
The job is just running on my machine for now.

Re: Talend Job Hangs without any errors

Anonymous — Fri, 14 Nov 2014 23:20:35 GMT

Does the job hangs also if you do not use a tLogRow?

Re: Talend Job Hangs without any errors

Anonymous — Mon, 17 Nov 2014 09:21:05 GMT

Hi AntonioCS,

Did your issue repro on other versions before? Did you store look up data on Disk in tMap?

Best regards
Sabrina

Re: Talend Job Hangs without any errors

Anonymous — Mon, 17 Nov 2014 10:10:48 GMT

Does the job hangs also if you do not use a tLogRow?

No it did not.
I removed the tLogRow and it finished and it also should me some mysql error msgs:
"Data truncation: Data too long for column 'name' at row 1Data truncation: Data too long for column 'name' at row 1Data truncation: Data too long for column 'name' at row 1Data truncation: Data too long for column 'name' at row 1Data truncation: Data too long for column 'name' at row 1Data..."
No tLogs for me
Thanks for the help

Re: Talend Job Hangs without any errors

Anonymous — Mon, 17 Nov 2014 10:20:20 GMT

Hi,
Could you please check document: https://community.talend.com/t5/Migration-Configuration-and/Data-truncation-error-Data-too-long-for-column/ta-p/24101?content-lang=en to see if it is working for your case?
Best regards
Sabrina

Re: Talend Job Hangs without any errors

Anonymous — Mon, 17 Nov 2014 10:23:32 GMT

Hi,
Could you please check document: https://community.talend.com/t5/Migration-Configuration-and/Data-truncation-error-Data-too-long-for-column/ta-p/24101?content-lang=en to see if it is working for your case?
Best regards
Sabrina

Hey,
I wasn't saying that the error was related to talend.
The field is indeed too small in some cases, what I was saying was that talend appears to hang with the tLog and it also not shows these error msgs because as soon as I removed the tLog the jog finished it I saw those error msgs.
Thanks

Re: Talend Job Hangs without any errors

Anonymous — Mon, 17 Nov 2014 15:00:28 GMT

Hi,
Have you checked “Die on error ” option in your tMySqlOutput?
Best regards
Sabrina

Re: Talend Job Hangs without any errors

Anonymous — Mon, 17 Nov 2014 15:01:57 GMT

I didn't check it. Will do!
Thanks for the help.

Re: Talend Job Hangs without any errors

Anonymous — Mon, 17 Nov 2014 15:19:29 GMT

Hi,
Feel free to let us know if there is any error message printed on console.
Best regards
Sabrina

Re: Talend Job Hangs without any errors

Anonymous — Fri, 29 Jul 2016 11:13:44 GMT

Hi Friends,
I have one scenario,how to transfer table from mssql to postgres .?
My Talend Job hangs without producing an error. I have a mssql input and a postgres output. After several thousand rows, the job just hands (the rows are not increasing on the output).

Mssql table has cores of records,but it is not getting through..!
Can anyone share your inputs.
Thanks in advance.

Re: Talend Job Hangs without any errors

Anonymous — Fri, 29 Jul 2016 11:33:39 GMT

Such a hang is mostly caused by a locked record/table in the database. Check if you have transaction locks.

Re: Talend Job Hangs without any errors

Anonymous — Mon, 01 Aug 2016 08:41:45 GMT

Hi sasikumar_ml,
Have you tried to check out "Die on error" option on tpostgresqloutput component to see if there is any error printed on console?
Best regards
Sabrina

Re: Talend Job Hangs without any errors

_AnonymousUser — Thu, 30 Mar 2017 12:52:19 GMT

Dear All,
I'm also getting the hang issue. I'm using parent child Jobs. something like (job1(parent job))--call to-->(job2)--call to-->(job3).
Once job3 complete then control Comes back on job2, here it validat the gerenated XML with xsd. Code got stuck here
in job2. This is just intermittent issue. We use .sh executable file and use command line to run it via schedule Job.
I observed stuck unix command calling that Job to run. In DB, no lock observed at all. No Network issue observed.
I have used tlogRow in job2. I this the reason? but issue doesn't come always. even for the bulk data, Maximum times it runs well.
Regards,
Veer