Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Problems with set variables

  1. #1

    Default Problems with set variables

    Hi, all

    I have a problem with set variables.

    I have a job with a transformation and a job:

    The transformation selects rows of a table.

    The job calls a transformacion that has the set variables.

    I need that the set variables agrees more of a row of entry, as what I have a job who settear a variable, but still it gives me the following mistake:

    2008/01/10 22:11:16 - Set Variables.0 - ERROR (version 2.5.1, build 1 from 2008/01/10 21:38:36) : Unexpected error : be.ibridge.kettle.core.exception.KettleStepException:
    2008/01/10 22:11:16 - Set Variables.0 - ERROR (version 2.5.1, build 1 from 2008/01/10 21:38:36) : Only 1 input row was expected to set the variables and at least 2 were received.
    2008/01/10 22:11:16 - Set Variables.0 - ERROR (version 2.5.1, build 1 from 2008/01/10 21:38:36) : be.ibridge.kettle.core.exception.KettleStepException:
    2008/01/10 22:11:16 - Set Variables.0 - ERROR (version 2.5.1, build 1 from 2008/01/10 21:38:36) : Only 1 input row was expected to set the variables and at least 2 were received.


    Already check the example of the process all tables.

    does someone know how solve like this problem?

    Regards,
    Neldy

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Set variables may only receive 1 row per execution. If it would get multiple rows only the last row would be really used... you have to build something around it with "execute for each row"

    Regards,
    Sven

  3. #3

    Default

    Thank you sven,
    Already it does not give me the mistake.

    My idea is to prove the set variable step and to see if the data goes on from the transformation 1 to the transformation 3.

    My problem is that it does not insert the data in the table when I place the Job 2.

    I have the following thing
    Transfomacion 1 -> Job 2 -> transfomacion 3.

    Transformation 1
    Selects data of a table and calculates a value "y"

    In the Job 2:

    Transformation 2, which includes
    -Get rows from result
    -set variable: it turns "y" in a variable
    -Copy rows to result

    In the transfomacion 3
    -Get rows from result
    -Table output

    I attach the transformations and the Job

    Regards,
    Neldy
    Attached Files Attached Files
    Last edited by neldy; 01-11-2008 at 08:04 AM.

  4. #4

    Default

    In the job 2 have checked "execute for every input row" and "Copy previous results to args", also I have checked in the transformation 2 ("execute for every input row" and "Copy previous results to args") and I do not have checked "clear list of result rows before execution" .

    do not see which is the mistake.



    Regards,
    Neldy
    Last edited by neldy; 01-11-2008 at 08:39 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.