Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error connecting to MySQL database from scheduled Kettle job

  1. #1
    Join Date
    Jun 2014
    Posts
    13

    Default Error connecting to MySQL database from scheduled Kettle job

    Hello,
    I cannot run scheduled Kettle job, after switching from Pentaho 5.0.1 to Pentaho 5.2. On Pentaho 5.0.1 everything worked fine.
    I use xaction files to schedule Kettle jobs in Pentaho. Inside the Kettle job I use MySQL connection over JNDI. The DB's JNDI name in Kettle job is same as a DB name defined in Pentaho "Database Connection". When I run "Test" connection on Pentaho it is succeeds. I use same connection in CDA, where it works fine.

    This happens when I execute the job in Pentaho:

    Code:
    2014-10-27 12:07:55,446 INFO  [org.pentaho.di] 2014/10/27 12:07:55 - load_dwh_job - Start of job execution
    2014-10-27 12:07:55,464 INFO  [org.pentaho.di] 2014/10/27 12:07:55 - load_dwh_job - Starting entry [Check Db connections]
    2014-10-27 12:07:55,617 ERROR [org.pentaho.di] 2014/10/27 12:07:55 - Check Db connections - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Cannot connect to database [target_lms_dwh] (connection [target_lms_dwh]). Exception : [org.pentaho.di.core.exception.KettleDatabaseException: 
      2014/10/27 12:07:55 - Check Db connections - Error occured while trying to connect to the database
    2014/10/27 12:07:55 - Check Db connections - 
    2014/10/27 12:07:55 - Check Db connections - Error connecting to database: (using class org.gjt.mm.mysql.Driver)
    2014/10/27 12:07:55 - Check Db connections - The active Hadoop configuration does not contain a Impala JDBC driver
    2014/10/27 12:07:55 - Check Db connections - 
    2014/10/27 12:07:55 - Check Db connections - ]
    2014-10-27 12:07:55,618 INFO  [org.pentaho.di] 2014/10/27 12:07:55 - load_dwh_job - Starting entry [Write To Log]
    ...
    2014-10-27 12:07:55,751 INFO  [org.pentaho.di] 2014/10/27 12:07:55 - load_dwh_job - Job execution finished
    2014-10-27 12:07:55,752 ERROR [org.pentaho.platform.plugin.action.kettle.KettleComponent] Error Start: Pentaho Pentaho Open Source BA Server 5.2.0.0-209
    2014-10-27 12:07:55,755 ERROR [org.pentaho.platform.plugin.action.kettle.KettleComponent] 805b8acb-5dc9-11e4-9939-001cc034f5c6:COMPONENT:context-26066308-1414408075163:load_dwh_action.xactionKettle.ERROR_0008 - An unexpected error occurred running the transformation org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - Error occurred during transformation execution
    org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - Error occurred during transformation execution
        at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeJob(KettleComponent.java:1027)
        at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeAction(KettleComponent.java:603)
        at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:465)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1186)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1151)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1063)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1013)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:895)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:797)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:352)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:282)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:179)
        at org.pentaho.platform.plugin.action.builtin.ActionSequenceAction.execute(ActionSequenceAction.java:81)
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:241)
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:181)
        at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:168)
        at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:157)
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:267)
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:140)
        at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:39)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
    Caused by: org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - Error occurred during transformation execution
        at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeJob(KettleComponent.java:1023)
        ... 21 more
    2014-10-27 12:07:55,755 ERROR [org.pentaho.platform.plugin.action.kettle.KettleComponent] Error end:
    2014-10-27 12:07:55,758 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 805b8acb-5dc9-11e4-9939-001cc034f5c6:SOLUTION-ENGINE:/home/lms_etl/load_dwh_action.xaction: Action Sequence execution failed, see details below
    | Error Time: Monday, October 27, 2014 12:07:55 PM CET
    | Session ID: admin
    | Instance Id: 805b8acb-5dc9-11e4-9939-001cc034f5c6
    | Action Sequence: load_dwh_action.xaction
    | Execution Stack:
    EXECUTING ACTION: Pentaho Data Integration Job (KettleComponent)
    | Action Class: KettleComponent
    | Action Desc: Pentaho Data Integration Job
    | Loop Index: 0
    Stack Trace:org.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - Action failed to execute
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1211)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1151)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1063)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1013)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:895)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:797)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:352)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:282)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:179)
        at org.pentaho.platform.plugin.action.builtin.ActionSequenceAction.execute(ActionSequenceAction.java:81)
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:241)
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:181)
        at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:168)
        at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:157)
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:267)
        at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:140)
        at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:39)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
    I have already tried to replace MySQL connector from mysql-connector-java-5.1.17 to mysql-connector-java-5.1.33-bin. Without success.
    Is there anybody who knows how to solve this issue?

    Martin
    Last edited by mzahrada; 10-27-2014 at 08:29 AM.

  2. #2
    Join Date
    Nov 2014
    Posts
    2

    Default

    i'm having the same problem. hope someone can help. thanks!

  3. #3
    Join Date
    Nov 2014
    Posts
    2

    Default

    im facing the same problem. hope someone can help. thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.