Friday, May 27, 2022

Kettle There was a data type error: the data type of java.lang.Long object [5061] does not correspond to value meta [BigNumber(15)]

: Errors detected!
: Because of an error, this step can't continue:
: org.pentaho.di.core.exception.KettleValueException:
********** BigNumber(15) : There was a data type error: the data type of java.lang.Long object [5061] does not correspond to value meta [BigNumber(15)]

at org.pentaho.di.core.row.value.ValueMetaBase.getString(ValueMetaBase.java:1927)
at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:328)
at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:860)
at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:384)
at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:125)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Unknown Source)


This Error is causing in one of the transformation where components is being used Table Input, Select Value, File Output, and Database lookup

Situation

  •    Field1 is of Number type size 15
  •    Field1 is used in "Values to return from the lookup table" in Component Database Lookup
  •    Checkbox "Enable Cache" was Checked 
  •    Checkbox "Load all data from table" was Checked 


    
Solution

  •     Uncheck Checkbox  "Load all data from table" was Checked

    

No comments:

Post a Comment

web stats