topic Multiple oncompoentok is all true in Talend Studio

Multiple oncompoentok is all true

Anonymous — Mon, 08 Jul 2019 10:46:21 GMT

This is my job design. I want to do tFileCopy_3 after all output tables such as productSpecs, SetUp, Order and OrderDetails's OnComponentOK is true. How do i catch the condition if onComponentOk on these tables are true? I want to copy file if only inserting data on these tables are true.

Re: Multiple oncompoentok is all true

fdenis — Mon, 08 Jul 2019 11:26:37 GMT

split your big job on by 2...
then create a job for orchestration using trunjob.
it's the cleanest way.
you can split your job on:
firstCopyFiles
runingNumber
insertIntoDb
ArchiveFile

Re: Multiple oncompoentok is all true

Anonymous — Mon, 08 Jul 2019 11:31:10 GMT

I need to move file on each success inserting data into database from xml file.

Re: Multiple oncompoentok is all true

fdenis — Tue, 09 Jul 2019 09:24:04 GMT

in this case you can use tparallelize
let's go

Re: Multiple oncompoentok is all true

Anonymous — Tue, 09 Jul 2019 10:03:37 GMT

where should i put tparallelize and connect?

Re: Multiple oncompoentok is all true

fdenis — Tue, 09 Jul 2019 16:16:44 GMT

you have to split and parallelize your 4 insert process then to merge with tparallelize. press f1 on selected component to have samples.

Re: Multiple oncompoentok is all true

lennelei — Tue, 09 Jul 2019 18:40:41 GMT

Hi,
1) Replace the OnComponentOk between both tFileList with a OnSubjobOk (more readable)
2) Move the tDBConnection before the first tFileList and add a OnSubjobOk link between them (to be sure the DB connection is made before the rest and that the job will stop if the connection fails)
3) Put your tFileCopy_3 below the tFileInputXML_1 after a OnSubjobOk link (to be sure the tFileCopy is made after the whole XML read/Oracle Input part)

4) I would personnaly remove the tRollback and add a tOracleClose (it's best to always close the connection and if you don't commit and close the connection, the rollback will be made)

You'll end up with somethind like this:

Regards