: 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