How to handle null exception in tAdvancedFileOutputXml component

tanjaj — Sat, 16 Nov 2024 01:37:34 GMT

Hi,

Talend job iterates through site names in excel file, compares it with data in DB and generates XML files with orders details. For one code, there are no orders, but it throws me an error and kills the job. In case of Order id doesn't exist I want to generate an empty file or to handle it on some other way, but definitely not to fail the job.

I tried with checking "Create attribute even if its value is NULL" but i have the same result.

I'm sending screenshots of my job and tAdvancedFileOutputXML component configuration.

Error trace:

Exception in component tAdvancedFileOutputXML_2 (Child_export_job)

java.lang.NullPointerException

at expot_xml_data.child_export_job_1_0.Child_export_job.tDBInput_5Process(Child_export_job.java:1385)

at expot_xml_data.child_export_job_1_0.Child_export_job.tDBInput_4Process(Child_export_job.java:967)

at expot_xml_data.child_export_job_1_0.Child_export_job.runJobInTOS(Child_export_job.java:4405)

at expot_xml_data.child_export_job_1_0.Child_export_job.runJob(Child_export_job.java:4224)

at expot_xml_data.export_data_xml_1_0.export_data_xml.tFileList_1Process(export_data_xml.java:1679)

at expot_xml_data.export_data_xml_1_0.export_data_xml.runJobInTOS(export_data_xml.java:3659)

at expot_xml_data.export_data_xml_1_0.export_data_xml.main(export_data_xml.java:3486)

Exception in component tRunJob_1 (export_data_xml)

java.lang.RuntimeException: Child job running failed.

java.lang.NullPointerException: null

at expot_xml_data.export_data_xml_1_0.export_data_xml.tFileList_1Process(export_data_xml.java:1700)

at expot_xml_data.export_data_xml_1_0.export_data_xml.runJobInTOS(export_data_xml.java:3659)

at expot_xml_data.export_data_xml_1_0.export_data_xml.main(export_data_xml.java:3486)

Re: How to handle null exception in tAdvancedFileOutputXml component

manodwhb — Fri, 21 Aug 2020 14:12:50 GMT

@Tanja Jovovic ,check the below case .

https://www.talendforge.org/forum/viewtopic.php?pid=204410

Re: How to handle null exception in tAdvancedFileOutputXml component

tanjaj — Fri, 21 Aug 2020 15:05:29 GMT

I got it.

I just added one IF in component tJavaRow ("Dates as global var" from screenshot), like this:

if(input_row.min_Date != null && input_row.max_Date != null){

context.min_Date = input_row.min_Date;

context.max_Date = input_row.max_Date;

}

And in tAdvancedFileOutXml component I checked Don't generate empty file.

S, for the missing orders it just didn't generate files.

@Manohar B Thank you fr the reply.

topic Re: How to handle null exception in tAdvancedFileOutputXml component in Talend Studio

How to handle null exception in tAdvancedFileOutputXml component

Re: How to handle null exception in tAdvancedFileOutputXml component

Re: How to handle null exception in tAdvancedFileOutputXml component