Hello,

I am using Pentaho CE - 5.4 with java 1.7. I am using mysql-connector-java-5.1.28.jar for mysql connector on my Ubuntu 14.04 machine. I have created a ktr file with spoon, which runs perfectly spoon, but gives error when I runs it through pan.

To execute the ktr file from pan i am executing
Code:
./pan.sh -file=/home/kaushik/Documents/test/showDataInBI.ktr -level=Rowlevel

Please look below for the error which I am getting while executing ktr file from pan.

2016/03/10 14:00:41 - Table input.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : An error occurred, processing will be stopped:
2016/03/10 14:00:41 - Table input.0 - Error occured while trying to connect to the database
2016/03/10 14:00:41 - Table input.0 -
2016/03/10 14:00:41 - Table input.0 - Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.
2016/03/10 14:00:41 - Table input.0 - org.gjt.mm.mysql.Driver
2016/03/10 14:00:41 - showDataInBI - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException:
2016/03/10 14:00:41 - showDataInBI - Unable to get database metadata from this database connection
2016/03/10 14:00:41 - showDataInBI - at java.lang.Thread.run (Thread.java:745)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:69)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.steps.tableinput.TableInput.init (TableInput.java:344)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.step.BaseStep.stopAll (BaseStep.java:2834)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.Trans.stopAll (Trans.java:1880)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning (TableInput.java:287)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.core.database.Database.cancelQuery (Database.java:673)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2762)
2016/03/10 14:00:41 - showDataInBI - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2016/03/10 14:00:41 - showDataInBI - Unable to get database metadata from this database connection
2016/03/10 14:00:41 - showDataInBI - at java.lang.Thread.run (Thread.java:745)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:69)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.steps.tableinput.TableInput.init (TableInput.java:344)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.step.BaseStep.stopAll (BaseStep.java:2834)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.Trans.stopAll (Trans.java:1880)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning (TableInput.java:287)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.core.database.Database.cancelQuery (Database.java:673)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2762)
2016/03/10 14:00:41 - showDataInBI -
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2765)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.core.database.Database.cancelQuery(Database.java:673)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:287)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.Trans.stopAll(Trans.java:1880)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2834)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.steps.tableinput.TableInput.init(TableInput.java:344)
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
2016/03/10 14:00:41 - showDataInBI - at java.lang.Thread.run(Thread.java:745)
2016/03/10 14:00:41 - showDataInBI - Caused by: java.lang.NullPointerException
2016/03/10 14:00:41 - showDataInBI - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2762)
2016/03/10 14:00:41 - showDataInBI - ... 7 more
2016/03/10 14:00:41 - Table input.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Error initializing step [Table input]
2016/03/10 14:00:41 - showDataInBI - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Step [Table input.0] failed to initialize!


I have copied "mysql-connector-java-5.1.28.jar" in /../data-integration/lib/ folder.

Please let me know whether I am doing it correctly or am I missing something.
Thankyou in advance.

Kaushik Karan