How to handle null exception in tAdvancedFileOutputXml component?..

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina