I have 233 records and i am loading into the excel.
But it is loading only 43 records and after that it is stuck.
If i remove the onsubjobOK and run separately it is running fine
You load data into excel... but after 43 it's stuck... do you get an error?
There's a checkbox in Excel component stop to read on empty rows?
Beside the checkbox it works without onSubjobOk, clearly that's not the problem?
DB Table -> 233 records -> Excel1
OnSubjobOk -> Excel1 -> only 43 records -> processing data and -> ExcelFinal
Your picture of your jobflow is kinda hard to understand.
consider this flow :
1st : from table to excel
2nd : From the excel sheet loading to the default template
This 2 process is happening in my flow.
So the problem is, If the 1st and 2nd process put together in single job OR connected using 2 sub jobs --- Not working it gets stuck till 45 records
If i run the second flow alone separately it is running fine
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.