Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Set Variables error - 1 input row expected 2 received

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default Set Variables error - 1 input row expected 2 received

    Hello Everyone!

    In the attached transformation I am reading log file and setting variables. However, it gives me the following error message when there are more than 2 rows.

    I thought variable is a column or am I missing something?

    Regards,
    Alex

    2011/10/03 11:01:33 - ReadingLogGettingDate - Dispatching started for transformation [ReadingLogGettingDate]
    2011/10/03 11:01:33 - Transformation metadata - Natural sort of steps executed in 0 ms (2 time previous steps calculated)
    2011/10/03 11:01:33 - Text file input.0 - Opening file: N:\Daily Positions\State Street\Pentaho\DailyProcess\UpdatingDataBase\DailyUpdate\LogForMainJob.txt
    2011/10/03 11:01:33 - Text file input.0 - Finished processing (I=7, O=0, R=0, W=7, U=1, E=0)
    2011/10/03 11:01:33 - Set Variables.0 - Setting environment variables...
    2011/10/03 11:01:33 - Set Variables.0 - Set variable DATERAN to value [2011/10/03 10:42:59]
    2011/10/03 11:01:33 - Set Variables.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unexpected error
    2011/10/03 11:01:33 - Set Variables.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
    2011/10/03 11:01:33 - Set Variables.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Only 1 input row was expected to set the variables and at least 2 were received.
    2011/10/03 11:01:33 - Set Variables.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :
    2011/10/03 11:01:33 - Set Variables.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.setvariable.SetVariable.processRow(SetVariable.java:90)
    2011/10/03 11:01:33 - Set Variables.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/10/03 11:01:33 - Set Variables.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Unknown Source)
    2011/10/03 11:01:33 - Set Variables.0 - Finished processing (I=0, O=0, R=2, W=1, U=0, E=1)
    2011/10/03 11:01:33 - ReadingLogGettingDate - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected!
    2011/10/03 11:01:33 - ReadingLogGettingDate - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected!
    2011/10/03 11:01:33 - ReadingLogGettingDate - ReadingLogGettingDate
    2011/10/03 11:01:33 - ReadingLogGettingDate - ReadingLogGettingDate
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2008
    Posts
    271

    Default

    "It accepts one (and only one) row of data to set the value of a variable" as per wiki

    Regards
    Andrea Torre
    twitter: @andtorg

    join the community on ##pentaho - a freenode irc channel

  3. #3
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you, Andrea!

    I guess it will take me some time to get used to parallel nature of PDI.

    Regards,
    Alex

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.