tFlowToIterate: Corrupt amount of iteration (# of expected iteration are multiplied times three which is curious)

[AKizilarslan1702922386]

Hi folks,

I am facing a really curious situation where my # of expected iterations are multiplied by three (does not matter if I expect 3, 15, 75, 100,... iterations).

The expected iterations are executed two more times jor every job execution (so, in total three).

Let my try to give an example:

I select five rows from my DB and want to "print" the contents of a column within tJava (System.out.println). However, each line is "printed" by a factor of three (see screenshot of Job).

The Console Output looks following:

< First batch of Iterations and should terminate here >

113000000408

113000001261

113000001258

113000000273

113000000402

< Second batch of Iterations ??? Why? >

113000000408

113000001261

113000001258

113000000273

113000000402

< Third batch of Iterations ??? Why? >

113000000408

113000001261

113000001258

113000000273

113000000402

My Java Code does not have any loops. It's just a System.out.println().

[Anonymous]

Hi

Can you share a full screenshot of job? I guess there is another iteration before tDBInputxxx component.

Regards

Shong

[AKizilarslan1702922386]

Hi shong, of course. The job evolved now a little bit but still same behaviour:

[AKizilarslan1702922386 · Accepted solution]

I can not explain it to me but I solved the problem by splitting from tDbInput to a second "SubjectOk (order 2)". Can someone understand why it is now working as expected?