Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Table input failed

  1. #1
    Join Date
    Aug 2017
    Posts
    6

    Post Table input failed

    Hi Guys,

    Can you help me please ?
    I have installed PDI 7.1 and downloaded mysql connector to the lib directory.
    I have a table input step in transformation and I get the below error when I run the job.

    ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : An error occurred, processing will be stopped:
    2017/10/30 10:40:54 - Table input.0 - Error occurred while trying to connect to the database
    2017/10/30 10:40:54 - Table input.0 -
    2017/10/30 10:40:54 - Table input.0 - Error connecting to database: (using class org.gjt.mm.mysql.Driver)
    2017/10/30 10:40:54 - Table input.0 - Communications link failure
    2017/10/30 10:40:54 - Table input.0 -
    2017/10/30 10:40:54 - Table input.0 - The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    2017/10/30 10:40:54 - Table input.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Error initializing step [Table input]
    2017/10/30 10:40:54 - spike_trans - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Step [Table input.0] failed to initialize!
    2017/10/30 10:40:54 - Table input.0 - Finished reading query, closing connection.
    2017/10/30 10:40:54 - Transformation - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unable to prepare for execution of the transformation
    2017/10/30 10:40:54 - Transformation - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2017/10/30 10:40:54 - Transformation - We failed to initialize at least one step. Execution can not begin!
    2017/10/30 10:40:54 - Transformation -

    BR
    Pali

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Make sure remote connections are enabled if Kettle and MySQL don't run on the same machine.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Aug 2017
    Posts
    6

    Default

    Thanks for your help!

Tags for this Thread

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.