topic Re: Problem in catching rejected Output from Tmap in Talend Studio

Problem in catching rejected Output from Tmap

Anonymous — Wed, 14 Sep 2016 12:55:06 GMT

Hi i need to catch rejected outputs in this , but i am not geeting rejected output, please help

Re: Problem in catching rejected Output from Tmap

Anonymous — Wed, 14 Sep 2016 13:18:30 GMT

This is how you do it....
https://www.rilhia.com/quicktips/quick-tip-how-debug-tmap-errors

Re: Problem in catching rejected Output from Tmap

Anonymous — Thu, 15 Sep 2016 14:35:34 GMT

First of all thanks for the reply , but my problem was not that actually , I want to capture the rows rejected in inner join that were coming from the lookup table as u can see in my uploaded image previously .
2. I also tried to capture the error message by passing a null value in not null column but this gives me an error and job dies ( i unchecked the die on error in property window)

Re: Problem in catching rejected Output from Tmap

Anonymous — Thu, 15 Sep 2016 14:41:11 GMT

You have to add the columns to the reject row. Once you have the reject output, add the column data you want to see to it. Now if you get an error, you will see the row data as well.

Re: Problem in catching rejected Output from Tmap

Anonymous — Thu, 15 Sep 2016 14:56:34 GMT

i have added the column , still job is quitting with exit code = 1 , not inserting any row in rejected output.

Re: Problem in catching rejected Output from Tmap

Anonymous — Thu, 15 Sep 2016 15:37:32 GMT

OK, you will need to give the error stack and preferably post a screenshot of your job

Re: Problem in catching rejected Output from Tmap

Anonymous — Fri, 16 Sep 2016 06:16:47 GMT

Exception in component tAmazonAuroraInput_1_in
java.lang.RuntimeException: Null value in non-Nullable column
at parallel_test_etl.position_parallel_stagingtofirm_0_1.position_parallel_stagingtofirm.tAmazonAuroraInput_1_inProcess(position_parallel_stagingtofirm.java:6728)
at parallel_test_etl.position_parallel_stagingtofirm_0_1.position_parallel_stagingtofirm$2.run(position_parallel_stagingtofirm.java:28721)
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at parallel_test_etl.dcdc_0_1.dcdc.tRunJob_1Process(dcdc.java:3479)
at parallel_test_etl.dcdc_0_1.dcdc.tAmazonAuroraInput_2_inProcess(dcdc.java:10726)
at parallel_test_etl.dcdc_0_1.dcdc.tAmazonAuroraConnection_1_outProcess(dcdc.java:6225)
at parallel_test_etl.dcdc_0_1.dcdc.tAmazonAuroraInput_1_inProcess(dcdc.java:6046)
at parallel_test_etl.dcdc_0_1.dcdc.tJava_3Process(dcdc.java:3102)
at parallel_test_etl.dcdc_0_1.dcdc.tJava_5Process(dcdc.java:2867)
at parallel_test_etl.dcdc_0_1.dcdc.tFileInputDelimited_1Process(dcdc.java:2722)
at parallel_test_etl.dcdc_0_1.dcdc.tJava_4Process(dcdc.java:1968)
at parallel_test_etl.dcdc_0_1.dcdc.tFileExist_1Process(dcdc.java:1725)
at parallel_test_etl.dcdc_0_1.dcdc.tJava_1Process(dcdc.java:1599)
at parallel_test_etl.dcdc_0_1.dcdc.runJobInTOS(dcdc.java:15698)
at parallel_test_etl.dcdc_0_1.dcdc.main(dcdc.java:15312)
disconnected
Job dcdc ended at 10:46 16/09/2016.

Re: Problem in catching rejected Output from Tmap

Anonymous — Fri, 16 Sep 2016 08:56:46 GMT

Have you made all of your reject output columns nullable? The error you have is "Null value in non-Nullable column". If your reject row has the columns set to non nullable, then they won't return null columns

Re: Problem in catching rejected Output from Tmap

Anonymous — Fri, 16 Sep 2016 09:29:11 GMT

Yes all rejectOutput columns are Nullable.

Re: Problem in catching rejected Output from Tmap

Anonymous — Fri, 16 Sep 2016 09:32:35 GMT

Can you post a screenshot of your job. Also, is the error occurring in a childjob? Is the tMap in that childjob? How are you trying to see the data being returned via the reject output? Have you you tried linking a tLogRow to the reject output?

Re: Problem in catching rejected Output from Tmap

Anonymous — Fri, 16 Sep 2016 09:41:00 GMT

error : Exception in component tAmazonAuroraInput_1_in
java.lang.RuntimeException: Null value in non-Nullable column
at parallel_test_etl.position_parallel_stagingtofirm_0_1.position_parallel_stagingtofirm.tAmazonAuroraInput_1_inProcess(position_parallel_stagingtofirm.java:6728)
at parallel_test_etl.position_parallel_stagingtofirm_0_1.position_parallel_stagingtofirm$2.run(position_parallel_stagingtofirm.java:28721)
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at parallel_test_etl.dcdc_0_1.dcdc.tRunJob_1Process(dcdc.java:3479)
at parallel_test_etl.dcdc_0_1.dcdc.tAmazonAuroraInput_2_inProcess(dcdc.java:10726)
at parallel_test_etl.dcdc_0_1.dcdc.tAmazonAuroraConnection_1_outProcess(dcdc.java:6225)
at parallel_test_etl.dcdc_0_1.dcdc.tAmazonAuroraInput_1_inProcess(dcdc.java:6046)
at parallel_test_etl.dcdc_0_1.dcdc.tJava_3Process(dcdc.java:3102)
at parallel_test_etl.dcdc_0_1.dcdc.tJava_5Process(dcdc.java:2867)
at parallel_test_etl.dcdc_0_1.dcdc.tFileInputDelimited_1Process(dcdc.java:2722)
at parallel_test_etl.dcdc_0_1.dcdc.tJava_4Process(dcdc.java:1968)
at parallel_test_etl.dcdc_0_1.dcdc.tFileExist_1Process(dcdc.java:1725)
at parallel_test_etl.dcdc_0_1.dcdc.tJava_1Process(dcdc.java:1599)
at parallel_test_etl.dcdc_0_1.dcdc.runJobInTOS(dcdc.java:15698)
at parallel_test_etl.dcdc_0_1.dcdc.main(dcdc.java:15312)
disconnected
Job dcdc ended at 10:46 16/09/2016.