Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Error in the transformation help me!!

  1. #1

    Default Error in the transformation help me!!

    Hi, all.

    Sorry for my English.

    I have two transformations in a Job: Transformation 1 and Transformation 2.

    My problem is the following one:

    In the first transformation have a step set variable, who presents a mistake when to run the transformation:

    2007/12/24 12:57:53 - Set Variables.0 - Setting environment variables...
    2007/12/24 12:57:53 - Set Variables.0 - Set variable Y to value [18000009]
    2007/12/24 12:57:53 - Set Variables.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Unexpected error : be.ibridge.kettle.core.exception.KettleStepException:
    2007/12/24 12:57:53 - Set Variables.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Only 1 input row was expected to set the variables and at least 2 were received.
    2007/12/24 12:57:53 - Set Variables.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : be.ibridge.kettle.core.exception.KettleStepException:
    2007/12/24 12:57:53 - Set Variables.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Only 1 input row was expected to set the variables and at least 2 were received.
    2007/12/24 12:57:53 - Set Variables.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) :
    2007/12/24 12:57:53 - Set Variables.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.trans.step.setvariable.SetVariable.processRow(SetVariable.java:154)
    2007/12/24 12:57:53 - Set Variables.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.trans.step.setvariable.SetVariable.run(SetVariable.java:184)

    How can I solve this mistake?

    What can I do in order that every row that goes out of the transformation 1 among to the transformation 2, using the variable "y" that is in the step set variables, That executes the transformation 2 completely, every time among a row in the transformation 2?.

    I attach the Job and the transformations.

    Regards.
    Neldy






    Attached Files Attached Files

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

    Default

    Only 1 row may hit the set variables step... if more than 1 row hit the step only the last one would be taken.

    Regards,
    Sven

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.