topic Re: Empty output table with mysql in Talend Studio

Empty output table with mysql

Anonymous — Sat, 16 Nov 2024 12:17:29 GMT

Hello,
i want to get the inner join exceptions so i've got an output in tmap and it's work fine when i the output is a tlogrow or a csv file.
when i replace tlogrow by a mysql table, the table is empty instead of the job telling me there is 163 rows..
no messages, no errors..
what's wrong???
thanks for help, i' m in hurry for that job.
claudine

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 09:11:46 GMT

Hi
Please upload some screenshot of this job.
Check the settings of tMysqlOutput again.
Regards,
Pedro

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 09:19:34 GMT

hello Pedro,
sorry for screenshot, theres was too big....
so post is modified now.
thanks

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 09:26:05 GMT

Hi
You'd better select "use an existing connection" checkbox and add tMysqlCommit in this job.
Regards,
Pedro

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 09:37:07 GMT

i already use an existing connection.
and for the commit, i dont understand why, and where do you suggest to put it??
thanks for so fast answered
claudine

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 09:40:52 GMT

Hi
Add tMysqlCommit as the following image.
Regards,
Pedro

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 09:45:38 GMT

hi Pedro
i just change "insert" by "insert ignore" and here is the output, an error in screen but not in output and table alawas empty. i'v very often do that kind of jobs in older versions, and never have probleme. it's a very very simple job...
thanks
claudine

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 09:54:44 GMT

hello Pedro,
i've use "commit automatic" in the connexion and INSERT in the action table and i've got the output.
I'saw your post later, i'll try your solution too.
Thanks for help
claudine

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 09:56:36 GMT

Hi
Great!
Besides, If you check "commit automatic", there is no need to use tMysqlCommit.
Regards,
Pedro

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 10:06:12 GMT

yes pedro, i understood.
i've a last question, i'va always have a red error on job, but the output is ok, have you an idea??
thanks
claudine

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 10:09:52 GMT

Hi
You might restart TOS and run this job again. Does the error recur?
Sometimes this is due to memory error.
Regards,
Pedro

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 10:15:46 GMT

Hello Pedro,
Really great thanks for all your help, your right, i restart talend and now all is ok. My client 'll be happy so do i!
have a nice day
claudine

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 10:56:05 GMT

Hi Pedro,
just for information. As i made a lot of tests, change composant, change name of rows and so on, i saw the name in the output of tmap section has a very strange look.
i've got the solution, i review all links...but it seems to be a bug...
regards,
claudine

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 11:00:05 GMT

Hi
Have you tried to reopen this job?
If it doesn't work after reopening it, you have to delete and recreate this job...
A bug is an issue which can be reproduced. But this is difficult...
Regards,
Pedro

Re: Empty output table with mysql

Anonymous — Fri, 18 May 2012 11:15:51 GMT

hi,
If i reopen it's the same, so i recreate job.
I agree with your bug definition, and i'll check if thoses problems be back.
thanks
claudine