View Full Version : Database Join
I have a problem with this step !
Then I use with 4 parameters (for example A, A, B, C) it's works fine, but not with 5 parameters (A, A, B, C, A) !! I have the error :
Erreur lors de la récupération des champs pour cette étape
Couldn't get field info from [SELECT ... FROM ... WHERE ....]
Paramètre IN ou OUT absent dans l'index :: 5
Plz it's a blocker issue for me. If someone can help me.
06-11-2008, 10:48 AM
Do you have 5 parameter markers in your SQL?
Probably best to attach your transformation.
Yes I have 5 markers !
When I have only 4 it's works, but when I add 1 parameter (and 1 marker) it's fails !!
I attach the files
I have made a lot of test and nothing works ! It seems to have a limit with the number of parameter in the database join step !
Is it possible or I do something wrong ?
06-12-2008, 03:49 AM
There was a bug in there in v3.0.0 which was fixed at a later time... which version are you using? And try the nightly build of 3.1 if you want to.
The original workaround was I think to not have the same names as parameter arguments (so copying 1 field to other different named fields).
I use v3.0.2 but I can't use a version like 3.0.4 or 3.1.0 if it isn't GA :( I don't have access to ftp but only in sourceforge.
I will try with copying field to not have the same name in database join step.
06-12-2008, 04:49 AM
3.0.3 is already a time GA (also on sf.net). You can find the non-GA versions at ftp://download.pentaho.org/client/data-integration/
Let us know whether the workaround works.
Yes I know for 3.0.3 but I wait 3.0.4 for some fix :) And I can't acces to ftp in my job :(.
But my problem is solve if I copy fields to have different name ! I attch the solution.
Thx a lot sboden
06-12-2008, 05:30 AM
If I remember correctly the step got confused with multiple identical names as arguments. It's for sure fixed in 3.1, probably also in 3.0.3