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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cemonteverde
Contributor
Contributor
‎2022-09-14 05:41 AM

tInputDelimited file is not exporting properly all rows to MySQL DB

Hello, I have the following issue...I have my tInputDelimited component which is exporting 82100 rows to MySQL DB component, it seems that everything is okay, but when I look up in my DB there are only 82000 rows, there are missing 100 rows. Could it be an issue regarding MySQL component?

Also I tried to get an output in a tOutputDelimited file next to the DB component and for that it works. So I think that maybe the issue is in the DB.

Labels (3)
Labels
329 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2022-09-14 07:06 AM

Can you show us a screenshot of your job and also a screenshot of your MySQL component (the settings) used to insert the data?

329 Views
0 Likes
Anonymous
Not applicable
‎2022-09-14 10:58 PM

Hello,

Could you please try to capture rejected records from tMysqlOutput manually to see if these 100 rows are rejected by your MySql DB?

Best regards

Sabrina

329 Views
0 Likes