Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Execution of Job Issue - Issue with logic Drives

  1. #1
    Join Date
    Apr 2014
    Posts
    4

    Default Execution of Job Issue - Issue with logic Drives

    Hi guys,

    I have biuld a simple job that moves files from one place to another. The issue with this another place is that is a logic drive, a shared folder on another computer. The kettle job works fine. When I execute the job from a .bat file or command line everything runs smooth. The issue comes when I want to schedule it to run from The windows task scheduler or from an SQL Job. With both scheduler tools the kettle job log results says fail.

    I am attaching the .kjb.

    Can ne1 here help with this problem.

    Regards,

    Benjamin
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Hi.
    Maybe I'm wrong but it could be caused by user permission.
    It could be that the shared folder does not allows the User running the .bat file to create files, while when you log in and use Spoon, your user has enough permissions to do that.

    Michele
    -- Mick --

  3. #3
    Join Date
    Apr 2014
    Posts
    4

    Default

    Thanks Michele, I checked the folder permissions and set it to everyone (read and write). This is the log I am getting: As you can see it says it doesn't find the logic drive!

    DEBUG: Using JAVA_HOME
    DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files (x86)\Java\jre7
    DEBUG: _PENTAHO_JAVA=C:\Program Files (x86)\Java\jre7\bin\java.exe
    2014/05/02 11:27:05 - Kitchen - Logging is at level : Basic logging
    2014/05/02 11:27:05 - Kitchen - Start of run.
    2014/05/02 11:27:05 - RepositoriesMeta - Reading repositories XML file: D:\FEXT_Produccion\.kettle\repositories.xml
    2014/05/02 11:27:14 - j_SincronizarSunat - Start of job execution
    2014/05/02 11:27:14 - j_SincronizarSunat - Starting entry [Check if a folder is empty]
    2014/05/02 11:27:14 - Check if a folder is empty - we can not find [X:\Sunat\Padron] !
    2014/05/02 11:27:14 - j_SincronizarSunat - Starting entry [Padron]
    2014/05/02 11:27:14 - Check if a folder is empty - Starting ...
    2014/05/02 11:27:14 - Check if a folder is empty - Processing row source File/folder source : [D:\FEXT_Produccion\Fuentes\Fuentes\Sunat\Padron] ... destination file/folder : [X:\Sunat\Padron]... wildcard : [.*\.exe]
    2014/05/02 11:27:14 - j_SincronizarSunat - Finished job entry [Padron] (result=[false])
    2014/05/02 11:27:14 - j_SincronizarSunat - Finished job entry [Check if a folder is empty] (result=[false])
    2014/05/02 11:27:14 - j_SincronizarSunat - Job execution finished
    2014/05/02 11:27:14 - Kitchen - Finished!
    2014/05/02 11:27:14 - Kitchen - Start=2014/05/02 11:27:05.649, Stop=2014/05/02 11:27:14.583
    2014/05/02 11:27:14 - Kitchen - Processing ended after 8 seconds.

  4. #4
    Join Date
    Apr 2008
    Posts
    4,684

    Default

    Is a user logged in when the scheduled task executes?

    If not, then the logical drive isn't mapped...

  5. #5
    Join Date
    Nov 2008
    Posts
    777

    Default

    Quote Originally Posted by gutlez View Post
    Is a user logged in when the scheduled task executes?

    If not, then the logical drive isn't mapped...
    I concur with that diagnosis. What I do to get around that is "lock" my computer instead of logging off. That keeps the drives mapped for scheduled tasks.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  6. #6
    Join Date
    Apr 2014
    Posts
    4

    Default

    For some reason when the Windows Scheduled Task runs with "run with the highest privilidges" un-checked it works. I still can not make it run from a SQL Job. Thanks a lot for your advices.

    Regards,

    Benjamin

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.