Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-09-14 08:55 AM

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
Labels (2)
Labels
491 Views
0 Likes
10 Replies
Anonymous
Not applicable
‎2016-09-14 09:18 AM
Author

This is how you do it....
https://www.rilhia.com/quicktips/quick-tip-how-debug-tmap-errors
429 Views
0 Likes
Anonymous
Not applicable
‎2016-09-15 10:35 AM
Author

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)
429 Views
0 Likes
Anonymous
Not applicable
‎2016-09-15 10:41 AM
Author

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.
429 Views
0 Likes
Anonymous
Not applicable
‎2016-09-15 10:56 AM
Author

 i have added the column , still job is quitting with exit code = 1 , not inserting any row in rejected output.
429 Views
0 Likes
Anonymous
Not applicable
‎2016-09-15 11:37 AM
Author

OK, you will need to give the error stack and preferably post a screenshot of your job
429 Views
0 Likes
Anonymous
Not applicable
‎2016-09-16 02:16 AM
Author

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.
429 Views
0 Likes
Anonymous
Not applicable
‎2016-09-16 04:56 AM
Author

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
429 Views
0 Likes
Anonymous
Not applicable
‎2016-09-16 05:29 AM
Author

Yes all rejectOutput columns are Nullable.
429 Views
0 Likes
Anonymous
Not applicable
‎2016-09-16 05:32 AM
Author

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?
429 Views
0 Likes