One Star

Empty output table with mysql

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
14 REPLIES
One Star

Re: Empty output table with mysql

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

Re: Empty output table with mysql

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

Re: Empty output table with mysql

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

Re: Empty output table with mysql

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
One Star

Re: Empty output table with mysql

Hi
Add tMysqlCommit as the following image.
Regards,
Pedro
One Star

Re: Empty output table with mysql

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
One Star

Re: Empty output table with mysql

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
One Star

Re: Empty output table with mysql

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

Re: Empty output table with mysql

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
One Star

Re: Empty output table with mysql

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

Re: Empty output table with mysql

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
One Star

Re: Empty output table with mysql

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
One Star

Re: Empty output table with mysql

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
One Star

Re: Empty output table with mysql

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