Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error: "Second meta data (meta2) is null, please check one of the previous steps."

  1. #1

    Default Error: "Second meta data (meta2) is null, please check one of the previous steps."

    Hello Everyone,

    I have the following problem in Spoon. I think it is a bug but I am not sure. If anyone can see something I am doing wrong please let me know before I report it.

    I want to read all the files from a folder that were modified after a certain date.

    I have a transformation parameter being input to a Get Variables step.
    I am using a filter rows step after getting all the files in the folders.

    Some screenshots:
    The flow:
    Name:  spoon - Ierror1.png
Views: 75
Size:  12.1 KB
    The variable: (it is being input in the correct format)
    Name:  spoon - Ierror2.jpg
Views: 78
Size:  17.5 KB
    The filter condition.
    Name:  spoon - Ierror3.jpg
Views: 74
Size:  19.9 KB

    I am getting these log messages:
    2011/09/21 12:21:12 - Import_New_Assignors3 - Dispatching started for transformation [Import_New_Assignors3]
    2011/09/21 12:21:12 - Import_New_Assignors3 - This transformation can be replayed with replay date: 2011/09/21 12:21:12
    2011/09/21 12:21:12 - Table output.0 - Connected to database [Local CPCC] (commit=1000)
    2011/09/21 12:21:12 - Get Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : Unexpected error found in evaluation function :
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : Error occurred for row: [my values here]
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : java.lang.RuntimeException: Unexpected error evaluation condition [ lastmodifiedtime >= FLD_START_DATE
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : ]
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at org.pentaho.di.core.Condition.evaluate(Condition.java:536)
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at org.pentaho.di.trans.steps.filterrows.FilterRows.keepRow(FilterRows.java:51)
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at org.pentaho.di.trans.steps.filterrows.FilterRows.processRow(FilterRows.java:103)
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at java.lang.Thread.run(Unknown Source)
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : Caused by: org.pentaho.di.core.exception.KettleValueException:
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : Date : Second meta data (meta2) is null, please check one of the previous steps.
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) :
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2995)
    2011/09/21 12:21:12 - Filter rows.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at org.pentaho.di.core.Condition.evaluate(Condition.java:445)
    If anyone has any ideas how I could fix it myself that would be fabulous.

    Thanks for reading.

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    It seems to me that the variable has no value, as reported in the log.
    How do you set its value? Are you sure the variable has a value?

  3. #3

    Default

    Hi Maria,

    Thank you for the reply. because it made me recheck using "Write to Log".
    It seems that "Get File Names" was swallowing the variable - not passing it through.
    Even though my field showed up in "Get Input Fields" of the following filter step it was not really there.
    The Excel Input step also does this annoying trick.
    I changed the flow to use a Cartesian join.

    Name:  spoon - Ierror4.png
Views: 71
Size:  18.9 KB

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.