Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: AWS migration

  1. #1
    Join Date
    Nov 2017
    Posts
    1

    Default AWS migration

    I am in the process of test a migration to AWS. My current production linux server had the database and PDI installed on it. in my AWS environment I have an RDS database which is where the kettle database is at and a task instance which is where PDI is installed on. I can start a kitchen job which will complete step one (which is to drop the data in a table) but error on step two (run a query to add data to a table). After a week of trying to fix it i am out of options. Can someone please put me on the right path to correct this.
    # ./job_nortridge_data_migration.sh
    INFO 08-11 14:56:40,372 - Kitchen - Start of run.
    INFO 08-11 14:56:40,398 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml
    INFO 08-11 14:56:45,702 - job_nortridge_data_migration - Start of job execution
    INFO 08-11 14:56:45,705 - job_nortridge_data_migration - Starting entry [delete_loanacct_statistics]
    INFO 08-11 14:56:45,756 - job_nortridge_data_migration - Starting entry [trans_loanacct_statistics]
    INFO 08-11 14:56:45,761 - trans_loanacct_statistics - Loading transformation from repository [trans_loanacct_statistics] in directory [/nortridge]
    INFO 08-11 14:56:47,419 - trans_loanacct_statistics - Dispatching started for transformation [trans_loanacct_statistics]
    INFO 08-11 14:56:47,453 - loanacct_statistics_output - Connected to database [AWS_DataVault_Nortridge] (commit=2000)
    ERROR 08-11 14:58:54,857 - loanacct_statistics_input - An error occurred, processing will be stopped:
    Error occured while trying to connect to the database

    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Network error IOException: Connection timed out (Connection timed out)


    ERROR 08-11 14:58:54,858 - loanacct_statistics_input - Error initializing step [loanacct_statistics_input]
    ERROR 08-11 14:58:54,858 - trans_loanacct_statistics - Step [loanacct_statistics_input.0] failed to initialize!
    INFO 08-11 14:58:54,858 - loanacct_statistics_input - Finished reading query, closing connection.
    ERROR 08-11 14:58:54,861 - trans_loanacct_statistics - Unable to prepare for execution of the transformation
    ERROR 08-11 14:58:54,861 - trans_loanacct_statistics - 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:792)
    at org.pentaho.di.trans.Trans.execute(Trans.java:364)
    at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1024)
    at org.pentaho.di.job.Job.execute(Job.java:503)
    at org.pentaho.di.job.Job.execute(Job.java:642)
    at org.pentaho.di.job.Job.execute(Job.java:642)
    at org.pentaho.di.job.Job.execute(Job.java:368)
    at org.pentaho.di.job.Job.run(Job.java:288)

  2. #2
    Join Date
    May 2017
    Posts
    10

    Default

    I think there is a problem with your database connection .Before running the transformation test your database connection once .

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.