rows are missing while loading to mysql

[Anonymous]

Hi,

I was reading a JSON file with 1441 records and tried to load it to MySQL server. After loading, I can see that only 1369 rows are inserted. I checked schema to see whether there is any truncation issue and found no issues. Can anyone help me with this?

[Anonymous]

Hi,

I have tried the first idea suggested by you and it did not change the output.

However, when am writing the data to a csv or excel format, am getting all the rows. How could that be possible?

[Anonymous]

Hi,

     Do you have records in incoming flow with same key values of database tables? In the case of Database, it will be overwritten but in the case of files, they will be considered as multiple rows.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

@amruthqs4talend 

If the answer has helped you, could you please mark the topic as resolved?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

That was a good suggestion but it did not solve my problem.

[Anonymous]

Hi,

   Are you saying all the records are having unique keys and they do not have any duplicates?

   Also did you try to use tDBOutput with Die on Error option enabled? If there are any data issues, it will reveal them by failing at that record.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous · Accepted solution]

Hello 

After you tmssql component use tjavarow

and try to use this code

Number of records successfully loaded : " + ((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_INSERTED"))

In talend studio to the left of it, you will have outline in that all the components will be appeared try to use them

Please find picture attached