topic Re: OnComponentError with tRunJob_1 (Parent Job) x "Die on Error" on tDBOutput (Child Job) in Talend Studio

OnComponentError with tRunJob_1 (Parent Job) x "Die on Error" on tDBOutput (Child Job)

FSternberg — Fri, 15 Nov 2024 23:06:46 GMT

I have 05 CSV files to import in the SQL base and the JOB is working fine.

I configured the “Die on Error” option in the tDBOutput_1 (Child Job) component so that in case I have any problem importing the file into the SQL database, rename the file as "NOK" at the end .

But I'm only able to rename it as “NOK” when I enable the “Die on “Error” option in tRunJob_1 but I can't use it because in this case only the first file is processed.

Can you help me with one suggestion?

I am sending in attached the file with one draft to better understanding.

Thanks!

Re: OnComponentError with tRunJob_1 (Parent Job) x "Die on Error" on tDBOutput (Child Job)

Anonymous — Wed, 16 Mar 2022 07:51:50 GMT

@Felipe Sternberg , also move this operation (ttFileCopy) to child job, pass the file path to child job, read the data from current file and insert them into DB, uncheck 'die on error' box on tRunJob and check the 'die on error' box on tDBOutput.

Please try and let me know if you still have any issues.

Regards

Shong

Re: OnComponentError with tRunJob_1 (Parent Job) x "Die on Error" on tDBOutput (Child Job)

FSternberg — Wed, 16 Mar 2022 13:06:03 GMT

Hello, I am a litle confuse, can you give me one draft here please of child job.

And if I´ll check "die on error" in DBOutput the others files will be executed?

Re: OnComponentError with tRunJob_1 (Parent Job) x "Die on Error" on tDBOutput (Child Job)

Anonymous — Thu, 17 Mar 2022 04:17:30 GMT

Pass the file path to child job and process each file in child job, unchecking the 'die on error' box on tRunjob will make the main job continue to execute even though there is an error occurs in child job.

Checking the 'die on error' box on tDBOuput will make the tFileCopy linked by onComponentError working.

The child job looks like:

tFileInputDelimited--main-tDBOutput--oncomponentError--tFileCopy

tFileInputDelimited: read the current file.

Regards

Shong