topic Re: tloop never ends in Talend Studio

tloop never ends

anut — Thu, 19 Sep 2013 20:36:39 GMT

Hi,

I want tloop component to run until the count of records from MySQL component(Talend_Statistics_READ) =4 and once the condition is met, I want the remaining ETL to run.
But in my case when count =4, the loop is not ending and thereby running the remaining ETL multiple times.
I tried to modify the condition in tloop component but can't get it to work as required. When I set the condition
as ((Integer)globalMap.get("tMysqlInput_2_NB_LINE")==4), Job starts and ends immediately.
Any ideas.
Thanks,
anut

Re: tloop never ends

Anonymous — Thu, 19 Sep 2013 21:32:18 GMT

Assuming you have the correct globalMap key and the correct number of rows are being returned, it looks okay to me.
I'd check the Java code to ensure that looks okay...
while (((Integer) globalMap.get("tMysqlInput_2_NB_LINE") <= 4)) {
...
globalMap.put("tMysqlInput_2_NB_LINE", nb_line_tMysqlInput_1);
...
}

Re: tloop never ends

Anonymous — Fri, 20 Sep 2013 08:46:11 GMT

if you set ((Integer)globalMap.get("tMysqlInput_2_NB_LINE")==4), job will end immediately definitely.
because you choose while condition and set declaration globalMap.put("tMysqlInput_2_NB_LINE",0)
like

int i=0;
while (i==4)
{
//loop cant be run because the condition is false
}

and without iteration, when condition is right (Integer)globalMap.get("tMysqlInput_2_NB_LINE")<=4)
loop cant be ended
So i suggest that you should re-desgin your job...

Re: tloop never ends

Anonymous — Fri, 20 Sep 2013 08:57:30 GMT

Setting aside the i==4 issue, the original requirement looked ok, to me.
Assuming that everything I couldn't see from the Job, as good.
The while expressions look a little odd; but they should translate to what seems to be required.