Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Variables defined in kettle.properties are not recognized with Pan/Kitchen in Redhat

  1. #1

    Default Variables defined in kettle.properties are not recognized with Pan/Kitchen in Redhat

    Hi Guys,

    We have a problem in execute pan command-line to run one transformation.

    Our environment is:

    OS: Redhat Enterprise Linux
    PDI: 4.2.1-Stable Community Edition

    We are using the kettle.properties located in pentaho_new/data-integration/.kettle and have a environment KETTLE_HOME declarated point to pentaho_new/data-integration

    When run the shell script the follow message appear:

    Error occured while trying to connect to the database

    javax.naming.NamingException: Invalid data source:'${dw}'
    Invalid data source:'${dw}'

    The ${dw} is point to des_dw, jndi connection exists in jndi.properties.

    Not much else to do, someone would have any idea?

    Thanks a lot,

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    not sure, try a few things:

    1. Make sure the variable is properly exported i.e. echo $KETTLE_HOME gives the correct path
    2. Check for typos in the path
    3. If you run this from cron, it may or may not pick up the .profile of the user you run as, thus the KETTLE_HOME var may be missing
    4. include an echo $KETTLE_HOME at the top of pan.sh/kitchen.sh to make sure the path is really there

    please get back to us with the results

    Cheers
    Slawo

  3. #3

    Default

    Hi,

    The problem was resolved.

    The problem was a incorrect path declareted for $KETTLE_HOME.

    Thank you!

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.