topic If one Excel file fails, how does the job not stop and continue to process the next file? in Talend Studio

If one Excel file fails, how does the job not stop and continue to process the next file?

laughsmile — Wed, 08 Jan 2025 05:44:39 GMT

Hello everyone.

We use tLogCatcher to handle the error and use tFileList to get a list of EXCEL files and tLoop to process files one by one. If one file fails, will the job not stop and continue to process the next files?

Thanks in advance.

Ryu

Re: If one Excel file fails, how does the job not stop and continue to process the next file?

laughsmile — Wed, 08 Jan 2025 07:00:06 GMT

Hi monica46cole

Thanks for your answer.

You say: "configure the tLogCatcher component to handle the error and move on to the next iteration. You can set the error handling strategy to log the error and proceed with the next file in the loop."

But I can't find the setting in the tLogCatcher component to handle the error and move on to the next iteration. Would you please show me how to do it by giving the visual representation?

Ryu

Re: If one Excel file fails, how does the job not stop and continue to process the next file?

Bhushan_Mahajan — Thu, 09 Jan 2025 07:00:22 GMT

@laughsmile Please SET ErrorMode=0

Re: If one Excel file fails, how does the job not stop and continue to process the next file?

Dave_Simo — Thu, 09 Jan 2025 12:31:33 GMT

Hello,

To continue the iteration even if there is an error while processing a file you can this piece of code in tJavaFlex as below :

We see that the iteration continued well even if an error was encountered on the first Excel file.

Best Regards,