Driver class 'org.gjt.mm.mysql.Driver' could not be found

Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed. org.gjt.mm.mysql.Driver

Issue : Creating connection with MySQL with kettle, was using 

• Data Integration Kettle version 9.0
• Mysql Driver version 8.0.25

Error

Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed. org.gjt.mm.mysql.Driver

Solution

Get version 5 latest driver from url https://downloads.mysql.com/archives/c-j/  (it is 5.1.49)

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

    

Salesforce Connection Issue with pentaho Kettle

 If you are trying to connect salesforce with pentaho in order to fetch/insert/update data and you might can face the error 

Error:

Failed : API security token required

 

Problem :

You might be entering wrong token along with your password, or your you havn't generated token

Solution :

Generate Token at saleforce side, or change the security token if you forgot the previous token