Pentaho Job Scheduler SQl connection Error
I am new to the pentaho software and researching it for use in my company.
WHEN i run the transformation that connects to my database ON the DATA
integration design VIEW it runs alright.
Yet when the same transformation is scheduled, I see the error below in
the DI logs
I have put the following Mysql connector FILE
mysql-connector-java-5.1.26-bin.jar INTO the folders below AS indicated IN
the forum.
C:\Program Files\pentaho\design-tools\DATA-integration\lib C:\Program
Files\pentaho\design-tools\DATA-integration\libtext
I have restarted the pc several times but error keeps showing.
are you able TO make a suggestion AS TO how this issue can be resolved?
2013-09-11 13:20:01,356 INFO [org.pentaho.di] RepositoriesMeta - Reading
repositoriesXML FILE: FromInputStream
2013-09-11 13:20:02,699 INFO [org.pentaho.di] Carte - Installing timer TO
PURGE stale objects AFTER 240 minutes.
2013-09-11 13:20:02,747 INFO [org.pentaho.di] Transformation 1 -
Dispatching started FOR transformation [Transformation 1]
2013-09-11 13:20:02,774 ERROR [org.pentaho.di] SET NEW processed id Tags -
An error occurred, processing will be stopped:
Error occured WHILE trying TO connect TO the DATABASE
Exception WHILE loading class
org.gjt.mm.mysql.Driver
2013-09-11 13:20:02,776 ERROR [org.pentaho.di] Clear Previous Processed
Tags - An error occurred, processing will be stopped:
Error occured WHILE trying TO connect TO the DATABASE
Exception WHILE loading class
org.gjt.mm.mysql.Driver
2013-09-11 13:20:02,777 ERROR [org.pentaho.di] SET NEW processed id Tags -
Error initializing step [SET NEW processed id Tags]
2013-09-11 13:20:02,777 ERROR [org.pentaho.di] Clear Previous Processed
Tags - Error initializing step [Clear Previous Processed Tags]
2013-09-11 13:20:02,778 ERROR [org.pentaho.di] Transformation 1 - Step
[Clear Previous Processed Tags.0] failed TO initialize!
2013-09-11 13:20:02,778 ERROR [org.pentaho.di] Transformation 1 - Step
[SET NEW processed id Tags.0] failed TO initialize!
2013-09-11 13:20:02,778 INFO [org.pentaho.di] Clear Previous Processed
Tags - Finished reading QUERY, closing connection.
2013-09-11 13:20:02,779 INFO [org.pentaho.di] SET NEW processed id Tags -
Finished reading QUERY, closing connection.
2013-09-11 13:20:02,790 ERROR
[org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob]
ActionAdapterQuartzJob.ERROR_0004 - ACTION
"org.pentaho.platform.plugin.action.kettle.PdiAction" failed TO run AS a
quartz job
org.pentaho.platform.api.engine.ActionExecutionException:
Kettle.ERROR_0011 - Could NOT PREPARE transformation FOR execution
AT
org.pentaho.platform.plugin.action.kettle.PdiAction.executeTransformation(SourceFile:398)
AT
org.pentaho.platform.plugin.action.kettle.PdiAction.execute(SourceFile:222)
AT
org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:129)
AT
org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:178)
AT
org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:139)
AT
org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:97)
AT org.quartz.core.JobRunShell.run(JobRunShell.java:199)
AT
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
Caused BY: org.pentaho.di.core.exception.KettleException:
We failed TO initialize AT LEAST ONE step. Execution can NOT BEGIN!
AT org.pentaho.di.trans.Trans.prepareExecution(Trans.java:932)
AT
org.pentaho.platform.plugin.action.kettle.PdiAction.executeTransformation(SourceFile:396)
... 7 more
No comments:
Post a Comment