Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (3)
14 Replies
Anonymous
Not applicable
Author

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

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

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

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
Anonymous
Not applicable
Author

Hi
Add tMysqlCommit as the following image.
Regards,
Pedro
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

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