Iterating over several subjobs.

One Star

Iterating over several subjobs.

I have my xml data split into several xml files I iterate over them and input them to my DB.
So I am using tFileList?Iterate?
Each of the tFileInputXML-->tXMLMap--->tMysqlSP inputs data into a different table.
This worked correctly in Talend 4.2.4 inserting data into the main table first. This order is important as there are constraints between the tables.
We have moved to Talend 5.1 and the job has stopped working inserting to table 3 first.
I have tried using on OnSubjobOk but this also fails inputting the same files data twice to the table 2 and table 3.
tMysqlConnection
|
OnSubjobOk
|
tFileList--Iterate-->tFileInputXML-->tXMLMap--->tMysqlSP(main table)
| |
| OnComponentOk
| |
| tFileInputXML-->tXMLMap--->tMysqlSP(Table 2)
| |
| OnComponentOk
| |
| tFileInputXML-->tXMLMap--->tMysqlSP(Table 3)
OnSubjobOk
|
tMysqlCommit
One Star

Re: Iterating over several subjobs.

Hi sdel,
Logically jobs looks perfectly fine.
What happens when it stops inserting into Table 3, can you please provide us some error logs and if possible screenshots as well.
--
Regards,
Vinod
Seven Stars

Re: Iterating over several subjobs.

I think the problem is using OnComponentOK from tFileInputXML. Try making the OnComponentOK from tMysqlSP.
One Star

Re: Iterating over several subjobs.

Yes connecting from the tMysqlSP worked. Thanks