One Star

Problem in catching rejected Output from Tmap

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

Re: Problem in catching rejected Output from Tmap

One Star

Re: Problem in catching rejected Output from Tmap

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)
Fifteen Stars

Re: Problem in catching rejected Output from Tmap

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.
Rilhia Solutions
One Star

Re: Problem in catching rejected Output from Tmap

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

Re: Problem in catching rejected Output from Tmap

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

Re: Problem in catching rejected Output from Tmap

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.
Fifteen Stars

Re: Problem in catching rejected Output from Tmap

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
Rilhia Solutions
One Star

Re: Problem in catching rejected Output from Tmap

Yes all rejectOutput columns are Nullable.
Fifteen Stars

Re: Problem in catching rejected Output from Tmap

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?
Rilhia Solutions
One Star

Re: Problem in catching rejected Output from Tmap

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.