topic Re: Iterating over several subjobs. in Talend Studio

Iterating over several subjobs.

Anonymous — Thu, 23 Aug 2012 09:56:30 GMT

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

Re: Iterating over several subjobs.

Anonymous — Thu, 23 Aug 2012 10:18:43 GMT

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

Re: Iterating over several subjobs.

alevy — Thu, 23 Aug 2012 10:21:29 GMT

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

Re: Iterating over several subjobs.

Anonymous — Thu, 23 Aug 2012 14:41:14 GMT

Yes connecting from the tMysqlSP worked. Thanks