topic Re: reject data from postgressql in Talend Studio

reject data from postgressql

Anonymous — Wed, 03 May 2017 09:40:19 GMT

I have rejects set up to redirect bad data to an excel file. I have checked the option don't generate empty file clicked. My job is still creating an empty file. Please help what should i do to avoid this thank you

Thank You

Re: reject data from postgressql

Anonymous — Wed, 03 May 2017 09:47:23 GMT

shong wrote
The reject row can't be used together with the 'die on error' option and 'extend insert' option in advanced setting tab of tMysqlOutput component, uncheck these two option and then you can use the reject row. Right click on tMysqlOutput, select Row, and then Reject.

above mentioned options are done.but still creating empty file

Re: reject data from postgressql

Anonymous — Wed, 03 May 2017 10:18:19 GMT

It seems the error comes from tFileInputDelimited component rather than DB output component. For testing, check the 'die on error' box to print the detailed error to the console to see which component throws the error.

Re: reject data from postgressql

Anonymous — Wed, 03 May 2017 10:23:56 GMT

i faced these errors after clicking die on error how to resolve this

exception in component tFileInputDelimited_1
java.lang.RuntimeException: Unparseable date: "1"
at routines.system.ParserUtils.parseTo_Date(ParserUtils.java:321)
at pya_projects.copy_of_iris_allergy_postgres_v2_0_1.Copy_of_iris_allergy_postgres_v2.tFileInputDelimited_1Process(Copy_of_iris_allergy_postgres_v2.java:1761)
at pya_projects.copy_of_iris_allergy_postgres_v2_0_1.Copy_of_iris_allergy_postgres_v2.runJobInTOS(Copy_of_iris_allergy_postgres_v2.java:3991)
at pya_projects.copy_of_iris_allergy_postgres_v2_0_1.Copy_of_iris_allergy_postgres_v2.main(Copy_of_iris_allergy_postgres_v2.java:3790)

Re: reject data from postgressql

cterenzi — Wed, 03 May 2017 11:45:31 GMT

You have a "1" in a column where Talend expects a date. Possibly your input file contains strings wrapped in quotes, but tFileInputDelimited isn't set up to interpret them?

Re: reject data from postgressql

Anonymous — Wed, 03 May 2017 12:11:55 GMT

that why i'm using rejects to capture that row

Re: reject data from postgressql

cterenzi — Wed, 03 May 2017 13:50:06 GMT

Then that's the row that's being sent to your reject file.