Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: org.pentaho.di.core.exception.KettleTransException

  1. #1

    Default org.pentaho.di.core.exception.KettleTransException

    Hello Everyone, I'm using the Kettle 3.2 data integration with Netezza based repository.

    I'm running into a issue which i'm not able to understand. Please see below

    INFO 13-08 18:31:11,985 - Copy rows to result.0 - Finished processing (I=0, O=0, R=148, W=148, U=0, E=0)
    INFO 13-08 18:31:12,082 - Newofflinefilesload2NZjob - Starting entry [SingleofflinefileprocessingJob]
    INFO 13-08 18:31:19,738 - SingleofflinefileprocessingJob - Starting job, loaded from repository : [/ : SingleofflinefileprocessingJob]
    INFO 13-08 18:31:19,740 - SingleofflinefileprocessingJob - Starting entry [Define file variable]
    INFO 13-08 18:31:19,744 - Define file variable - Loading transformation from repository [Define file variable] in directory [/]
    INFO 13-08 18:31:21,004 - Define file variable - Dispatching started for transformation [Define file variable]
    INFO 13-08 18:31:21,006 - Define file variable - This transformation can be replayed with replay date: 2012/08/13 18:31:21
    ERROR 13-08 18:31:21,131 - Define file variable - Unable to prepare for execution of the transformation
    ERROR 13-08 18:31:21,131 - Define file variable - org.pentaho.di.core.exception.KettleTransException:
    Unable to begin processing transformation

    Error writing log record to table [Trans_log]

    Error occured while trying to connect to the database

    Error connecting to database: (using class org.gjt.mm.mysql.Driver)
    Unknown Response Type




    at org.pentaho.di.trans.Trans.beginProcessing(Trans.java:1464)
    at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:523)
    at org.pentaho.di.trans.Trans.execute(Trans.java:275)
    at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:897)
    at org.pentaho.di.job.Job.execute(Job.java:446)
    at org.pentaho.di.job.Job.execute(Job.java:547)
    at org.pentaho.di.job.Job.execute(Job.java:377)
    at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:60)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.pentaho.di.core.exception.KettleTransException:
    Error writing log record to table [Trans_log]

    Error occured while trying to connect to the database

    Error connecting to database: (using class org.gjt.mm.mysql.Driver)
    Unknown Response Type



    at org.pentaho.di.trans.Trans.beginProcessing(Trans.java:1439)
    ... 8 more
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    ==========================================================

    first of all why it's looking for mysql java driver. I already have Netezza java driver at following location:

    ls -ltr /home/mysql/data-integration/libext/JDBC/

    -rwxr-xr-x 1 mysql mysqldba 225319 Jun 29 2011 nzjdbc3.jar

    My Java release is:

    java -version
    java version "1.6.0_32"
    Java(TM) SE Runtime Environment (build 1.6.0_32-b05)
    Java HotSpot(TM) Server VM (build 20.7-b02, mixed mode)

    Could some one advise me that what's going wrong and or how can i debug this?

    Appreciate your help.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Using Netezza as a repository database seems like a bad idea, YMMV.

  3. #3

    Default

    Quote Originally Posted by MattCasters View Post
    Using Netezza as a repository database seems like a bad idea, YMMV.
    Thanks Matt !

    I think I found out my issue. Somewhere long time back, i've enabled the auditing by using the Trans_log. Job was failing because it can not connect to other mysql db to insert record in that. I moved the repository to netezza but not the audit tables.

    I was not able to find where did i mention that so that I can take the auditing off. i was not able to find out that. I checked my all the jobs and transfromation.

    Is there any serach feature which can serach in the repostiory and find out where i'm using the Trans log for auditing? Will help a lot.

    I really appreciate your time and efforts.

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.