Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Exception processing filter expression

  1. #1

    Unhappy Exception processing filter expression

    Hi All,

    I get the below strange exception while running the graph. Can some one help me understand the issue. Attached are the complete log file and transformation file

    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Unexpected error found in evaluation function :
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Error occurred for row: [100414], [015556], [062028], [Monitor], [100414], [identical], []
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : java.lang.RuntimeException: Unexpected error evaluation condition [(
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : (
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : flagfield = []
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ]
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:521)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.trans.steps.filterrows.FilterRows.keepRow(FilterRows.java:49)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.trans.steps.filterrows.FilterRows.processRow(FilterRows.java:89)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.trans.steps.filterrows.FilterRows.run(FilterRows.java:146)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Caused by: java.lang.RuntimeException: Unexpected error evaluation condition [(
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : flagfield = []
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ]
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:521)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:494)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ... 3 more
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Caused by: java.lang.RuntimeException: Unexpected error evaluation condition [ flagfield = []
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ]
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:521)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:494)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ... 4 more
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Caused by: java.lang.NullPointerException
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2624)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:434)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ... 5 more
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Unexpected error :
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : org.pentaho.di.core.exception.KettleException:
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Unexpected error found in evaluation function :
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Unexpected error evaluation condition [(
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : (
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : flagfield = []
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ]
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) :
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.trans.steps.filterrows.FilterRows.keepRow(FilterRows.java:57)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.trans.steps.filterrows.FilterRows.processRow(FilterRows.java:89)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.trans.steps.filterrows.FilterRows.run(FilterRows.java:146)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Caused by: java.lang.RuntimeException: Unexpected error evaluation condition [(
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : (
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : flagfield = []
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ]
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:521)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.trans.steps.filterrows.FilterRows.keepRow(FilterRows.java:49)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ... 2 more
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Caused by: java.lang.RuntimeException: Unexpected error evaluation condition [(
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : flagfield = []
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ]
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:521)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:494)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ... 3 more
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Caused by: java.lang.RuntimeException: Unexpected error evaluation condition [ flagfield = []
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ]
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:521)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:494)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ... 4 more
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Caused by: java.lang.NullPointerException
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2624)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:434)
    2007/11/20 12:44:19 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ... 5 more
    2007/11/20 12:44:19 - SO Source - Statement canceled!
    2007/11/20 12:44:19 - SO Source - Statement canceled!
    2007/11/20 12:44:19 - SO Temp Staging - Statement canceled!
    2007/11/20 12:44:19 - SO Temp Staging - Statement canceled!
    2007/11/20 12:44:19 - Filter rows.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
    2007/11/20 12:44:19 - MJS.0 - No end Script found!




    Regards,
    Raju
    Attached Files Attached Files

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

    Default

    Use 3.0GA ... and try again.

    Regards,
    Sven

  3. #3

    Default

    upgraded to GA as said and also updated the repository version. Iam getting a problem in the sort step now. Below is the error

    2007/11/20 13:53:13 - MJS.0 - No tran_Status found. Transformation status checking not available.
    2007/11/20 13:53:13 - Sort rows.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : Unexpected error :
    2007/11/20 13:53:13 - Sort rows.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : java.lang.ClassCastException: java.lang.String
    2007/11/20 13:53:13 - Sort rows.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.trans.steps.sort.SortRows.addBuffer(SortRows.java:76)
    2007/11/20 13:53:13 - Sort rows.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.trans.steps.sort.SortRows.processRow(SortRows.java:360)
    2007/11/20 13:53:13 - Sort rows.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.trans.steps.sort.SortRows.run(SortRows.java:503)
    2007/11/20 13:53:13 - SO Source - Statement canceled!
    2007/11/20 13:53:13 - SO Source - Statement canceled!
    Attached Files Attached Files

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.