Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Not able to execute ETL job from cmd prompt windows 10

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Not able to execute ETL job from cmd prompt windows 10

    Hi All,

    I have a designed a etl job which is to be executed using batch file.
    But when I try it fails. I tried executing job from cmd prompt. I get access denied message in cmd prompt.
    I am using windows 10 machine, Pentaho 7.1 ce and jre1.8.0_171
    When I execute the etl job from spoon.bat UI it works well but not from cmd prompt.
    The logged in user on windows 10 machine is a admin user.

    Please help!


    Thanks
    Ajinkya

  2. #2
    Join Date
    Aug 2016
    Posts
    290

    Default

    Have you tried replacing the line that executes the kettle script with a simple echo debug output? How about putting an echo debug script in same location as kettle script, and run that from your batch script instead? Is cmd started as administrator? Is the path you're trying to execute scripts or subscripts somewhere near those defeault folders which windows likes to deny access to?

    Try these things to determine if this is a batch problem or a pentaho kettle problem.
    Last edited by Sparkles; 06-20-2018 at 03:14 AM.

  3. #3

    Default

    Thanks,
    Issue was in command. Command was breaking due to space. I was having space in folder name which was pointing to kitchen.bat file.
    It worked after using "_" in place of space.

  4. #4

    Default if spaces present trying using quotes

    Even quotes alone can work instead of underscore too. Just try and let us know.


    Quote Originally Posted by Ajinkya View Post
    Thanks,
    Issue was in command. Command was breaking due to space. I was having space in folder name which was pointing to kitchen.bat file.
    It worked after using "_" in place of space.
    Regards,
    Dileep
    Mail ID

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.