org.pentaho.di.core.exception.KettleException: Error parsing string [java.lang.NullPointerException]!

Pentaho BI Platform Tracking | Meelan Laxman | 1 year ago
  1. 0

    When passing JSon Input step a Null value, the following Null Pointer Exception is thrown: {noformat} 2015/08/20 16:29:01 - Json Input.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Unexpected Error : org.pentaho.di.core.exception.KettleException: 2015/08/20 16:29:01 - Json Input.0 - Error parsing string [java.lang.NullPointerException]! 2015/08/20 16:29:01 - Json Input.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleException: 2015/08/20 16:29:01 - Json Input.0 - Error parsing string [java.lang.NullPointerException]! 2015/08/20 16:29:01 - Json Input.0 - 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonReader.readString(JsonReader.java:147) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.parseJson(JsonInput.java:272) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.readFileOrString(JsonInput.java:258) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.ReadNextString(JsonInput.java:165) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.getOneRow(JsonInput.java:396) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.processRow(JsonInput.java:344) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/08/20 16:29:01 - Json Input.0 - at java.lang.Thread.run(Thread.java:745) {noformat}

    Pentaho BI Platform Tracking | 1 year ago | Meelan Laxman
    org.pentaho.di.core.exception.KettleException: Error parsing string [java.lang.NullPointerException]!
  2. 0

    When passing JSon Input step a Null value, the following Null Pointer Exception is thrown: {noformat} 2015/08/20 16:29:01 - Json Input.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Unexpected Error : org.pentaho.di.core.exception.KettleException: 2015/08/20 16:29:01 - Json Input.0 - Error parsing string [java.lang.NullPointerException]! 2015/08/20 16:29:01 - Json Input.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleException: 2015/08/20 16:29:01 - Json Input.0 - Error parsing string [java.lang.NullPointerException]! 2015/08/20 16:29:01 - Json Input.0 - 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonReader.readString(JsonReader.java:147) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.parseJson(JsonInput.java:272) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.readFileOrString(JsonInput.java:258) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.ReadNextString(JsonInput.java:165) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.getOneRow(JsonInput.java:396) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.processRow(JsonInput.java:344) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/08/20 16:29:01 - Json Input.0 - at java.lang.Thread.run(Thread.java:745) {noformat}

    Pentaho BI Platform Tracking | 1 year ago | Meelan Laxman
    org.pentaho.di.core.exception.KettleException: Error parsing string [java.lang.NullPointerException]!
  3. 0

    Elastic to Postgres data migration fails in kettle

    Stack Overflow | 2 years ago | Marlon Abeykoon
    org.pentaho.di.core.exception.KettleException: The data structure is not the same inside the resource! We found 1000 values for json path [$..LoginSessionId], which is different that the number retourned for path [$.ResourceChangeInfo..ResourceCode] (9325 values). We MUST have the same number of values for all paths.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Spoon PDI Data Validator Error

    Stack Overflow | 2 years ago | Paul
    org.pentaho.di.core.exception.KettleException: Correct Group/Dashboard Assignment Correct Group/Dashboard Assignment
  6. 0

    Error al realizar una transformacion con postgresql - Open Business Intelligence

    redopenbi.com | 1 year ago
    org.pentaho.di.core.exception.KettleException: 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Error batch inserting rows into table [ejecmensual]. 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Errors encountered (first 10): 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Batch entry 0 INSERT INTO transformationpentaho.ejecmensual (ano_eje, sec_ejec, pliego, ejecutora, sec_func, programa, prod_pry, act_ai_obra, funcion, division_func, grupo_func, meta, finalidad, unidad_medida, cantidad, departamento, provincia, distrito, origen, fuente_financ_agregada, fuente_financ, tipo_recurso, categ_gasto, tipo_transaccion, generica, subgenerica, subgenerica_det, especifica, especifica_det, presupuesto, modificacion, pim, m01, m02, m03, m04, m05, m06, m07, m08, m09, m10, m11, m12, total_prog, saldo, porcentaje) VALUES ( '2014',  '001309',  '050',  '001',  '0001',  '0035',  '3000603',  '5004399',  '17',  '054',  '0119',  '00001',  '0107477',  '00194',  '9.0',  '01',  '02',  '99',  NULL,  '1',  NULL,  NULL,  '5',  '2',  '3',  NULL,  NULL,  NULL,  NULL,  '3754.0',  '0.0',  '3754.0',  '190.0',  '600.0',  '0.0',  '630.0',  '77.5',  '658.5',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '2156.0',  '1598.0',  '57.43') was aborted.  Call getNextException to see the cause. 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - ERROR: column "sec_ejec" of relation "ejecmensual" does not exist 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 -   Position: 57 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Error updating batch 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Batch entry 0 INSERT INTO transformationpentaho.ejecmensual (ano_eje, sec_ejec, pliego, ejecutora, sec_func, programa, prod_pry, act_ai_obra, funcion, division_func, grupo_func, meta, finalidad, unidad_medida, cantidad, departamento, provincia, distrito, origen, fuente_financ_agregada, fuente_financ, tipo_recurso, categ_gasto, tipo_transaccion, generica, subgenerica, subgenerica_det, especifica, especifica_det, presupuesto, modificacion, pim, m01, m02, m03, m04, m05, m06, m07, m08, m09, m10, m11, m12, total_prog, saldo, porcentaje) VALUES ( '2014',  '001309',  '050',  '001',  '0001',  '0035',  '3000603',  '5004399',  '17',  '054',  '0119',  '00001',  '0107477',  '00194',  '9.0',  '01',  '02',  '99',  NULL,  '1',  NULL,  NULL,  '5',  '2',  '3',  NULL,  NULL,  NULL,  NULL,  '3754.0',  '0.0',  '3754.0',  '190.0',  '600.0',  '0.0',  '630.0',  '77.5',  '658.5',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '2156.0',  '1598.0',  '57.43') was aborted.  Call getNextException to see the cause. 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 -

    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. org.pentaho.di.core.exception.KettleException

      Error parsing string [java.lang.NullPointerException]!

      at org.pentaho.di.trans.steps.jsoninput.JsonReader.readString()
    2. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.trans.steps.jsoninput.JsonReader.readString(JsonReader.java:147)
      2. org.pentaho.di.trans.steps.jsoninput.JsonInput.parseJson(JsonInput.java:272)
      3. org.pentaho.di.trans.steps.jsoninput.JsonInput.readFileOrString(JsonInput.java:258)
      4. org.pentaho.di.trans.steps.jsoninput.JsonInput.ReadNextString(JsonInput.java:165)
      5. org.pentaho.di.trans.steps.jsoninput.JsonInput.getOneRow(JsonInput.java:396)
      6. org.pentaho.di.trans.steps.jsoninput.JsonInput.processRow(JsonInput.java:344)
      7. org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      7 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame