org.pentaho.di.core.exception.KettleStepException: Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657]

Pentaho BI Platform Tracking | Chris Deptula | 3 years ago
  1. 0

    When trying to generate rows that include a Timestamp field the Generate Rows step fails with the following error. All other data types work with the generate rows field including Internet Address. java.lang.reflect.InvocationTargetException: Unable to get fields for step [Generate Rows] : org.pentaho.di.core.exception.KettleStepException: Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:78) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleStepException: org.pentaho.di.core.exception.KettleStepException: Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] at org.pentaho.di.trans.steps.rowgenerator.RowGeneratorMeta.getFields(RowGeneratorMeta.java:224) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:2200) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:2049) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1954) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:73) ... 1 more Caused by: org.pentaho.di.core.exception.KettleStepException: Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] at org.pentaho.di.trans.steps.rowgenerator.RowGeneratorMeta.getFields(RowGeneratorMeta.java:215) ... 5 more

    Pentaho BI Platform Tracking | 3 years ago | Chris Deptula
    org.pentaho.di.core.exception.KettleStepException: Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657]
  2. 0

    When trying to generate rows that include a Timestamp field the Generate Rows step fails with the following error. All other data types work with the generate rows field including Internet Address. java.lang.reflect.InvocationTargetException: Unable to get fields for step [Generate Rows] : org.pentaho.di.core.exception.KettleStepException: Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:78) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleStepException: org.pentaho.di.core.exception.KettleStepException: Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] at org.pentaho.di.trans.steps.rowgenerator.RowGeneratorMeta.getFields(RowGeneratorMeta.java:224) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:2200) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:2049) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1954) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:73) ... 1 more Caused by: org.pentaho.di.core.exception.KettleStepException: Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] at org.pentaho.di.trans.steps.rowgenerator.RowGeneratorMeta.getFields(RowGeneratorMeta.java:215) ... 5 more

    Pentaho BI Platform Tracking | 3 years ago | Chris Deptula
    org.pentaho.di.core.exception.KettleStepException: Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657] Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657]
  3. 0

    exact version pdi-ce-5.2.0.0-209 related to PDI-8738 My colleague wanted to use the user defined java class step in combination with an info data stream. He finds usefull information on http://type-exit.org/adventures-with-open-source-bi/2010/10/the-user-defined-java-class-step/ When you use the transformation info_steps.ktr (http://type-exit.org/adventures-with-open-source-bi/2010/10/the-user-defined-java-class-step/#downloads) from this website it works in pdi 5.2 But when you do (on that transformation) -select all (ctrl-a) -copy (ctrl-c) -open new transformation (ctrl-n) -paste (ctrl-v) -run you get an error: ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Unexpected error ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : org.pentaho.di.core.exception.KettleStepException: Unable to find In field helper for field name 'value' - at org.pentaho.di.trans.steps.userdefinedjavaclass.TransformClassBase.get(TransformClassBase.java:628) - at Processor.processRow(Processor.java:25) - at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1018) - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) - at java.lang.Thread.run(Thread.java:745) This can be solved in the new transformation file by alter the order of the hop elements. The hop from the data stream has to be the first.

    Pentaho BI Platform Tracking | 2 years ago | Rutger Deterd Oude Weme
    org.pentaho.di.core.exception.KettleStepException: Unable to find In field helper for field name 'value'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Issue when using the plugin embedded in java

    GitHub | 10 months ago | MilchUndHonig
    org.pentaho.di.core.exception.KettleStepException: Return value KEY_SEQ can't be found in the input row.
  6. 0

    Issue when using the plugin embedded in java

    GitHub | 10 months ago | MilchUndHonig
    org.pentaho.di.core.exception.KettleStepException: Return value KEY_SEQ can't be found in the input row. ```

    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.KettleStepException

      Error: Please specify the value type of field [timestamp_field] with value [2013/08/06 12:34:54.657]

      at org.pentaho.di.trans.steps.rowgenerator.RowGeneratorMeta.getFields()
    2. org.pentaho.di
      SearchFieldsProgressDialog.run
      1. org.pentaho.di.trans.steps.rowgenerator.RowGeneratorMeta.getFields(RowGeneratorMeta.java:215)
      2. org.pentaho.di.trans.steps.rowgenerator.RowGeneratorMeta.getFields(RowGeneratorMeta.java:224)
      3. org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:2200)
      4. org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:2049)
      5. org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1954)
      6. org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:73)
      6 frames