How to handle null exception in tAdvancedFileOutputXml component?..

Anonymous — Sat, 16 Nov 2024 01:16:30 GMT

Hello,

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 krogerfeedback talktosonic talktowendys whataburger survey 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)

thanks

jackyjoy

Re: How to handle null exception in tAdvancedFileOutputXml component?..

Anonymous — Wed, 21 Oct 2020 09:08:54 GMT

Hello,

Could you please post your job design screenshots on community which will be helpful for us to address your issue?

Best regards

Sabrina

topic 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?..