Database Join

[DamP]

Hi ererybody,

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.

Thx

[sboden]

Do you have 5 parameter markers in your SQL?

Probably best to attach your transformation.

Regards,
Sven

[DamP]

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

[DamP]

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 ?

Thx

[sboden]

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).

Regards,
Sven

[DamP]

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.

Thx

[sboden]

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.

Regards,
Sven

[DamP]

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

[sboden]

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

Regards,
Sven