hi,
I'm testing JasperETL and I found (maybe) a odd bug/problem.
I have 3 .xls files in entry and I want to obtain one .xls file with a concatenation and selection.
[URL=http://img120.imageshack.us/my.php?image=pb1tl6.jpg][IMG]http://img120.i...
[URL=http://img241.imageshack.us/my.php?image=pb2jn8.jpg][IMG]http://img241.i...
As you can see on these pictures. I have 464 rows then 494 rows. between the 2, I don't do anything (only push "Run")
Data in my 3 xls files haven't change. On the last picture, you can see the treatment that I do.
[URL=http://img412.imageshack.us/my.php?image=pb3vd4.jpg][IMG]http://img412.i...
I can send you the 3 files, if you want.
I thank you for your futures answers and I apologize for my bad frenchy speaking
Guillaume
Post edited by: test.guillaume, at: 2007/02/20 14:08
Post edited by: test.guillaume, at: 2007/02/20 14:09
Post edited by: test.guillaume, at: 2007/02/20 14:11
Post edited by: test.guillaume, at: 2007/02/20 14:12
I'm testing JasperETL and I found (maybe) a odd bug/problem.
I have 3 .xls files in entry and I want to obtain one .xls file with a concatenation and selection.
[URL=http://img120.imageshack.us/my.php?image=pb1tl6.jpg][IMG]http://img120.i...
[URL=http://img241.imageshack.us/my.php?image=pb2jn8.jpg][IMG]http://img241.i...
As you can see on these pictures. I have 464 rows then 494 rows. between the 2, I don't do anything (only push "Run")
Data in my 3 xls files haven't change. On the last picture, you can see the treatment that I do.
[URL=http://img412.imageshack.us/my.php?image=pb3vd4.jpg][IMG]http://img412.i...
I can send you the 3 files, if you want.
I thank you for your futures answers and I apologize for my bad frenchy speaking
Guillaume
Post edited by: test.guillaume, at: 2007/02/20 14:08
Post edited by: test.guillaume, at: 2007/02/20 14:09
Post edited by: test.guillaume, at: 2007/02/20 14:11
Post edited by: test.guillaume, at: 2007/02/20 14:12
5 Answers:
Posted on February 22, 2007 at 7:33am
Hi,
If i understand your problem,
1/you don't change your 3 input files
2/you launch 2 times your job
3/the number of row (displayed thanks statistic mode) on one of your output file changes at each launch!
It's a very strange problem!
To be sure is not a problem with statistics mode : can you check the number of lines of the output file (to see if the statistics mode displays the good number of line)
However, I think this problem should be linked to the bug 467 ( http://talendforge.org/bugs/view.php?id=467 ) "tMap output branches execution order is unpredictable". But this bug is ressolved and the correction is included on your JasperETL 1.1.1!!!
Can you send me [ccarbone( at )talend.com] your workspace
and your 3 input files?
______
Thank you for your support!
Cedric Carbone
Talend CTO
Post edited by: ccarbone, at: 2007/02/22 07:36
If i understand your problem,
1/you don't change your 3 input files
2/you launch 2 times your job
3/the number of row (displayed thanks statistic mode) on one of your output file changes at each launch!
It's a very strange problem!
To be sure is not a problem with statistics mode : can you check the number of lines of the output file (to see if the statistics mode displays the good number of line)
However, I think this problem should be linked to the bug 467 ( http://talendforge.org/bugs/view.php?id=467 ) "tMap output branches execution order is unpredictable". But this bug is ressolved and the correction is included on your JasperETL 1.1.1!!!
Can you send me [ccarbone( at )talend.com] your workspace
and your 3 input files?
______
Thank you for your support!
Cedric Carbone
Talend CTO
Post edited by: ccarbone, at: 2007/02/22 07:36
Posted on February 22, 2007 at 1:42pm
test.guillaume wrote:
Hi Guillaume,
I received your email with your Job.
The problem is on the setting in the input file component (tFileInputDelimited_2), you checked Extract a random number of lines option ! (see the attach screenshot)
So, there is no bug ;) Uncheck this option and our file out will be ever the same between each launch.
Futhermore, on your input file, you have to perform a transformation to change your actual decimal separator (coma) by a point (I can see 15,567 instead of 15.567)
______
Thank you for your support!
Cedric Carbone
Talend CTO [file name=tos.jpg size=57452]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/tos...
Post edited by: ccarbone, at: 2007/02/22 14:08
| I send you all. |
Hi Guillaume,
I received your email with your Job.
The problem is on the setting in the input file component (tFileInputDelimited_2), you checked Extract a random number of lines option ! (see the attach screenshot)
So, there is no bug ;) Uncheck this option and our file out will be ever the same between each launch.
Futhermore, on your input file, you have to perform a transformation to change your actual decimal separator (coma) by a point (I can see 15,567 instead of 15.567)
______
Thank you for your support!
Cedric Carbone
Talend CTO [file name=tos.jpg size=57452]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/tos...
Post edited by: ccarbone, at: 2007/02/22 14:08
![http://img120.imageshack.us/my.php?image=pb1tl6.jpg][IMG]http://img120.i...](http://img120.imageshack.us/my.php?image=pb1tl6.jpg][IMG]http://img120.imageshack.us/img120/4976/pb1tl6.th.jpg[/IMG][/URL]){kind=link}
![http://img241.imageshack.us/my.php?image=pb2jn8.jpg][IMG]http://img241.i...](http://img241.imageshack.us/my.php?image=pb2jn8.jpg][IMG]http://img241.imageshack.us/img241/6731/pb2jn8.th.jpg[/IMG][/URL]){kind=link}
![http://img412.imageshack.us/my.php?image=pb3vd4.jpg][IMG]http://img412.i...](http://img412.imageshack.us/my.php?image=pb3vd4.jpg][IMG]http://img412.imageshack.us/img412/1139/pb3vd4.th.jpg[/IMG][/URL]){kind=link}
