Handling Schema Mismatch Exceptions in Talend XML Processing

portix — Thu, 16 Jan 2025 17:38:48 GMT

In my Talend job, I am processing XML files from a directory using a tFileInputXML component. The issue is that the directory may contain XML files with different schemas. When the job tries to process a file with an unexpected schema, it throws an exception, causing the entire job to fail.

I cannot filter the files in advance using tFileList because I do not have the file names or any predefined criteria to identify the incompatible files beforehand.

What I need is for Talend not to stop. I want to catch the exception when it occurs (for example, using a tLogCatcher or similar component) and continue processing the rest of the files without stopping the entire job.

The error is as follows (it occurs in the tXMLMap when trying to map):
Exception in component tXMLMap_1_TXMLMAP_OUT (handlingError) java.lang.RuntimeException: row3.content can't be empty

Re: Handling Schema Mismatch Exceptions in Talend XML Processing

Dave_Simo — Thu, 16 Jan 2025 17:48:30 GMT

Hello,

If you want to escape the exception when processing your XML, you can use the solution proposed in this post.

https://community.qlik.com/t5/Design-and-Development/If-one-Excel-file-fails-how-does-the-job-not-stop-and-continue/td-p/2500309

Best regards

topic Re: Handling Schema Mismatch Exceptions in Talend XML Processing in Talend Studio

Handling Schema Mismatch Exceptions in Talend XML Processing

Re: Handling Schema Mismatch Exceptions in Talend XML Processing