Talend Job Hangs without any errors

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hi,
Could you please check document: https://community.talend.com/t5/Migration-Configuration-and/Data-truncation-error-Data-too-long-for-... 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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[_AnonymousUser]

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