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

    

Thursday, May 12, 2022

Local Task Bar appear when Remote Machine done in FULL Screen

You may appear the local machine Task Bar overlap on Remote machine task bar when operating remote desktop in full screen mode (mstsc).

To avoid this Problem just restart the services of Explorer of local machine will fix your problem.

Open you task manager from local machine

Locate the "windows explorer" under Process tab.

Right click and Restart services

web stats