Discussion :

[kaskarot]

Bonjour

J'utilise une sous-transformation PARTNER_CONTACT_SUB avec 2 champs mappés (voir partner.png).
Ensuite dans ma sous transformation j'exécute une requête sql dans une table input "PARTNER TYPE SUB" (see partner_contact.png) avec pour les deux mark? les références de l'étape "INPUT SUB".
Mais quand j'exécute cette tranformation Pentaho répond ceci:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
 
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : Unexpected error
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - An error occurred executing SQL:
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - SELECT *, ? as partner_id 
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - FROM llx_socpeople 
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - where fk_soc = ?;
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - 
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - offending row : [societe_id Integer(9)], [nom String], [name_alias String], [entity Integer(9)], [ref_ext String], [ref_int String], [statut Integer(2)], [parent Integer(9)], [tms Timestamp], [datec Timestamp], [status Integer(2)], [code_client String], [code_fournisseur String], [code_compta String], [code_compta_fournisseur String], [address String], [zip String], [town String], [fk_departement Integer(9)], [fk_pays Integer(9)], [fk_account Integer(9)], [phone String], [fax String], [url String], [email String], [socialnetworks String], [skype String], [whatsapp String], [linkedin String], [youtube String], [googleplus String], [snapchat String], [instagram String], [facebook String], [twitter String], [fk_effectif Integer(9)], [fk_typent Integer(9)], [fk_forme_juridique Integer(9)], [fk_currency String], [siren String], [siret String], [ape String], [idprof4 String], [idprof5 String], [idprof6 String], [tva_intra String], [capital BigNumber(24, 8)], [fk_stcomm Integer(9)], [note_private String], [note_public String], [model_pdf String], [prefix_comm String], [client Integer(2)], [fournisseur Integer(2)], [supplier_account String], [fk_prospectlevel String], [fk_incoterms Integer(9)], [location_incoterms String], [customer_bad Integer(2)], [customer_rate Number], [supplier_rate Number], [fk_user_creat Integer(9)], [fk_user_modif Integer(9)], [remise_client Number], [remise_supplier Number], [mode_reglement Integer(2)], [cond_reglement Integer(2)], [mode_reglement_supplier Integer(2)], [cond_reglement_supplier Integer(2)], [fk_shipping_method Integer(9)], [tva_assuj Integer(2)], [localtax1_assuj Integer(2)], [localtax1_value Number(6, 3)], [localtax2_assuj Integer(2)], [localtax2_value Number(6, 3)], [barcode String], [fk_barcode_type Integer(9)], [price_level Integer(9)], [outstanding_limit BigNumber(24, 8)], [order_min_amount BigNumber(24, 8)], [supplier_order_min_amount BigNumber(24, 8)], [default_lang String], [logo String], [canvas String], [import_key String], [webservices_url String], [webservices_key String], [fk_multicurrency Integer(9)], [multicurrency_code String], [fk_entrepot Integer(9)], [logo_squarred String], [is_company_ext Boolean], [partner_id Integer]
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - 
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - Error setting value #3 [String] on prepared statement
2021/02/01 14:27:48 - PARTNER CONTACT INPUT.0 - Parameter index out of range (3 > number of parameters, which is 2).

Avez-vous une idéé ?

Merci par avance

Ma config :
Pentaho 9.0 under ubuntu 18