Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

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

  1. #1
    Join Date
    Mar 2014
    Posts
    181

    Default org.pentaho.di.core.exception.KettleDatabaseException:

    Hello all,

    I have a Kettle transformation that connects to the Postgresql Amazon RDS instance.

    When I established the connection, the test ran successful but when I run the job, it fails to connect.

    Below is the log with the errors:

    2014/03/20 12:04:59 - Save to Landing.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : An error occurred intialising this step:
    2014/03/20 12:04:59 - Save to Landing.0 - Error occured while trying to connect to the database
    2014/03/20 12:04:59 - Save to Landing.0 -
    2014/03/20 12:04:59 - Save to Landing.0 - Error occured while trying to connect to the database
    2014/03/20 12:04:59 - Save to Landing.0 -
    2014/03/20 12:04:59 - Save to Landing.0 - Unable to pre-load connection to the connection pool
    2014/03/20 12:04:59 - Save to Landing.0 - FATAL: password authentication failed for user "sidw_dev"
    2014/03/20 12:04:59 - Save to Landing.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Error initializing step [Save to Landing]
    2014/03/20 12:04:59 - Load_Data_FRM_SRC_To_Landing - Step [Trim Operation.0] initialized flawlessly.
    2014/03/20 12:04:59 - Load_Data_FRM_SRC_To_Landing - Step [Data Conversion.0] initialized flawlessly.
    2014/03/20 12:04:59 - Load_Data_FRM_SRC_To_Landing - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Step [Save to Landing.0] failed to initialize!
    2014/03/20 12:04:59 - Load_Data_FRM_SRC_To_Landing - Step [Generate Rows.0] initialized flawlessly.
    2014/03/20 12:04:59 - Load_Data_FRM_SRC_To_Landing - Step [GetYesterday.0] initialized flawlessly.
    2014/03/20 12:04:59 - Load_Data_FRM_SRC_To_Landing - Step [filename.0] initialized flawlessly.
    2014/03/20 12:04:59 - Load_Data_FRM_SRC_To_Landing - Step [ReadCSV.0] initialized flawlessly.
    2014/03/20 12:04:59 - Save to Landing.0 - Signaling 'output done' to 0 output rowsets.
    2014/03/20 12:04:59 - Save to Landing.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error rolling back the database connection.
    2014/03/20 12:04:59 - Save to Landing.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
    2014/03/20 12:04:59 - Save to Landing.0 - Unable to get database metadata from this database connection
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.job.Job.run (Job.java:407)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.job.Job.execute (Job.java:500)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.job.Job.execute (Job.java:815)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.job.Job.execute (Job.java:815)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.job.Job.execute (Job.java:815)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.job.Job.execute (Job.java:678)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.job.entries.trans.JobEntryTrans.execute (JobEntryTrans.java:1037)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.trans.Trans.execute (Trans.java:578)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:1043)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:708)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.core.database.Database.rollback (Database.java:739)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.core.database.Database.rollback (Database.java:747)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2653)
    2014/03/20 12:04:59 - Save to Landing.0 -
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2655)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.core.database.Database.rollback(Database.java:747)
    2014/03/20 12:04:59 - Save to Landing.0 - at org.pentaho.di.core.database.Database.rollback(Database.java:739)

    Thanks,

    Ron

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

    Default

    Did you turn on connection pooling by any chance or something of that nature?

  3. #3
    Join Date
    Mar 2014
    Posts
    181

    Default

    Matt,

    I did turn on the connection pooling.

    Thanks,

    Ron

  4. #4
    Join Date
    Mar 2014
    Posts
    181

    Default

    Attachment 12921

    That is what I did.

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

    Default

    Best to turn it off as RDS seems to have an issue with it.

  6. #6
    Join Date
    Mar 2014
    Posts
    181

    Default

    Matt, I disabled connection pooling.

    I found out something something interesting too that I had done.

    I was using the wrong user name and password. When I supplied the right credentials, my data source connection ran just fine.

    Thank you for the good tip about connection pooling.

    Thanks,

    Ron

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.