java.lang.RuntimeException: Unexpected error evaluation condition [( LO_STATUS IN LIST [3;4] ) ]

Pentaho BI Platform Tracking | Paul Burger | 8 years ago
  1. 0

    When using streamVar IN LIST ["3";"4"] to filter rows I get the following error when a null arrives. The expected result was that null and other values should have been directed to the dummy step I assigned. 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unexpected error found in evaluation function : 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Error occurred for row: [34], [C01600000000000400153], [C], [016], [0000], [00000004], [00153], [null], [MELK POST 4], [null], [null], [2], [null], [11829], [null], [null], [0], [null], [null], [null], [CHRISTOPHER STARKE STREET], [null], [null], [null], [null], [null], [null], [ATLANTIS], [2009-04-24], [4] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : java.lang.RuntimeException: Unexpected error evaluation condition [( 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : LO_STATUS IN LIST [3;4] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.Condition.evaluate(Condition.java:533) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.filterrows.FilterRows.keepRow(FilterRows.java:45) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.filterrows.FilterRows.processRow(FilterRows.java:96) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2861) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.filterrows.FilterRows.run(FilterRows.java:154) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Caused by: java.lang.RuntimeException: Unexpected error evaluation condition [ LO_STATUS IN LIST [3;4] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.Condition.evaluate(Condition.java:533) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.Condition.evaluate(Condition.java:506) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ... 4 more 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Caused by: java.lang.NullPointerException 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.String.compareTo(Unknown Source) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.String.compareTo(Unknown Source) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.util.Arrays.binarySearch0(Unknown Source) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.util.Arrays.binarySearch(Unknown Source) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.Condition.evaluate(Condition.java:466) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ... 5 more 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unexpected error : 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : org.pentaho.di.core.exception.KettleException: 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unexpected error found in evaluation function : 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unexpected error evaluation condition [( 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : LO_STATUS IN LIST [3;4] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ] Changing the condition to to test for streamVar = "3" OR streamVar = "4" works fine. IN LIST was just easier to use especially as I'm expecting the list of values to grow further down the line.

    Pentaho BI Platform Tracking | 8 years ago | Paul Burger
    java.lang.RuntimeException: Unexpected error evaluation condition [( LO_STATUS IN LIST [3;4] ) ]
  2. 0

    When using streamVar IN LIST ["3";"4"] to filter rows I get the following error when a null arrives. The expected result was that null and other values should have been directed to the dummy step I assigned. 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unexpected error found in evaluation function : 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Error occurred for row: [34], [C01600000000000400153], [C], [016], [0000], [00000004], [00153], [null], [MELK POST 4], [null], [null], [2], [null], [11829], [null], [null], [0], [null], [null], [null], [CHRISTOPHER STARKE STREET], [null], [null], [null], [null], [null], [null], [ATLANTIS], [2009-04-24], [4] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : java.lang.RuntimeException: Unexpected error evaluation condition [( 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : LO_STATUS IN LIST [3;4] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.Condition.evaluate(Condition.java:533) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.filterrows.FilterRows.keepRow(FilterRows.java:45) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.filterrows.FilterRows.processRow(FilterRows.java:96) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2861) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.trans.steps.filterrows.FilterRows.run(FilterRows.java:154) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Caused by: java.lang.RuntimeException: Unexpected error evaluation condition [ LO_STATUS IN LIST [3;4] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.Condition.evaluate(Condition.java:533) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.Condition.evaluate(Condition.java:506) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ... 4 more 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Caused by: java.lang.NullPointerException 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.String.compareTo(Unknown Source) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.lang.String.compareTo(Unknown Source) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.util.Arrays.binarySearch0(Unknown Source) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at java.util.Arrays.binarySearch(Unknown Source) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : at org.pentaho.di.core.Condition.evaluate(Condition.java:466) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ... 5 more 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unexpected error : 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : org.pentaho.di.core.exception.KettleException: 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unexpected error found in evaluation function : 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : Unexpected error evaluation condition [( 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : LO_STATUS IN LIST [3;4] 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ) 2009/05/14 09:45:30 - SG Approved and Registered 2.0 - ERROR (version 3.2.0-RC1, build 10435 from 2009-03-20 09.51.14 by buildguy) : ] Changing the condition to to test for streamVar = "3" OR streamVar = "4" works fine. IN LIST was just easier to use especially as I'm expecting the list of values to grow further down the line.

    Pentaho BI Platform Tracking | 8 years ago | Paul Burger
    java.lang.RuntimeException: Unexpected error evaluation condition [( LO_STATUS IN LIST [3;4] ) ]
  3. 0

    Finding elements in array with binary search

    Stack Overflow | 3 years ago | Nick
    java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Beginners Corner « WebLogic

    middlewaremagic.com | 4 months ago
    java.lang.NullPointerException

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.NullPointerException

      No message provided

      at java.lang.String.compareTo()
    2. Java RT
      Arrays.binarySearch
      1. java.lang.String.compareTo(Unknown Source)
      2. java.lang.String.compareTo(Unknown Source)
      3. java.util.Arrays.binarySearch0(Unknown Source)
      4. java.util.Arrays.binarySearch(Unknown Source)
      4 frames
    3. org.pentaho.di
      FilterRows.run
      1. org.pentaho.di.core.Condition.evaluate(Condition.java:466)
      2. org.pentaho.di.core.Condition.evaluate(Condition.java:506)
      3. org.pentaho.di.trans.steps.filterrows.FilterRows.keepRow(FilterRows.java:45)
      4. org.pentaho.di.trans.steps.filterrows.FilterRows.processRow(FilterRows.java:96)
      5. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2861)
      6. org.pentaho.di.trans.steps.filterrows.FilterRows.run(FilterRows.java:154)
      6 frames