topic Re: problem to load: tfilellist xml to table sql in Talend Studio

problem to load: tfilellist xml to table sql

hechmi — Sun, 21 Oct 2018 23:13:36 GMT

Hi all;

i have a problem when i load table from tfilelist xml

in tfilelist i have 290 file xml when i load with iterate xsd and tmap to table mysql , just one row i find in a table

my job is: tfilelist (import all file xml )------>tfileinputxml(xsd)---->tmap---->table sql

the proble is 290 file input ------> 1 rowoutput ???? i want to have 290 row ourput (in sql )

i put a screen

job of loadmysql out put in data base mysql

Re: problem to load: tfilellist xml to table sql

Anonymous — Mon, 22 Oct 2018 05:17:15 GMT

Hi,

For the interim analysis, could you please a dd a tlogrow instead of tMySQLOutput and run the job again? This step is to verify whether the data is coming till tMySQLOutput.

Once it is confirmed that the data is coming till that point, could you please select Die on error option in tMySQLOutput and run the job again? Most probably the data might be ignored due to some DB error. But this will be tracked if we add Die on error.

Please let us know the results and we will take it from there.

Warm Regards,

Nikhil Thampi

Re: problem to load: tfilellist xml to table sql

hechmi — Mon, 22 Oct 2018 09:16:18 GMT

tkank you @nthampi ;

the solution in two step :

-first i add a tlogrow instead of tMySQLOutput and run the job i find the error that is a double cote in colum date i correct it and run the job again, no error her and the job run ok

and run the job again.

-second step i select Die on error option in tMySQLOutput and i drop the table from data base and run the job again no error her and the job run ,good solution

best regards

Re: problem to load: tfilellist xml to table sql

Anonymous — Mon, 22 Oct 2018 09:34:25 GMT

Happy to know that you were able to resolve the issue.

Enjoy programming in Talend 🙂

Warm Regards,

Nikhil Thampi