Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Executing PDI JOb from within SQL 2008

  1. #1

    Default Executing PDI JOb from within SQL 2008

    Hi guys,

    I have an issue.

    I have a Job that executes perfect from within PDI. It also runs ok when I execute it from Windows task scheduentler, but for some reason when I execute it from within SQL Agent (jobs) it throws an error.

    I am using PDI CE 5.0. I am using the kettle_home to redirect the .kettle dir to d:.

    I am using a .bat file E:cd E:\Pentaho\data-integration\
    kitchen.bat /rep:"01" /dir:"Fuentes/BEXLOGICA/SUNAT/GJ01_ACTSUNAT" /job:"GJ01_ACTSUNAT" /level:detailed



    This is the error it shows on SQL Agent: The SQL job only executes the .bat file.


    Executed as user: SRVSQL01\Administrator. ...iles\Java\jdk1.7.0_07\ DEBUG: _PENTAHO_JAVA=C:\Program Files\Java\jdk1.7.0_07\\bin\java.exe2013/12/19 23:20:29 - Kitchen - Logging is at level : Basic logging 2013/12/19 23:20:29 - Kitchen - Start of run. 2013/12/19 23:20:29 - RepositoriesMeta - Reading repositories XML file: C:\Users\Administrator\.kettle\repositories.xml2013/12/19 23:20:30 - GJ01_ACTSUNAT - Start of job execution 2013/12/19 23:20:30 - GJ01_ACTSUNAT - Starting entry [DescargaFuentes]2013/12/19 23:20:31 - JP01_DescargaFuentes - Starting entry [J_Control]2013/12/19 23:20:31 - J_Control - exec(4, 0, START.0) 2013/12/19 23:20:31 - START - Starting job entry 2013/12/19 23:20:31 - J_Control - Starting entry [Set variables] 2013/12/19 23:20:31 - J_Control - exec(5, 0, Set variables.0) 2013/12/19 23:20:31 - Set variables - Starting job entry 2013/12/19 23:20:31 - Set variables - Set variable IDPROCESO to value [8] 2013/12/19 23:20:31 - J_Control - Starting entry [getIDEjecucion] 2013/12/19 23:20:31 - J_Control - exec(6, 0, getIDEjecucion.0) 2013/12/19 23:20:31 - getIDEjecucion - Starting job entry 2013/12/19 23:20:31 - getIDEjecucion - Opening transformation: [null] in directory [/Fuentes/BEXLogica/SUNAT/JP01_DescargaFuentes/J_Control] 2013/12/19 23:20:31 - getIDEjecucion - Loading transformation from repository [t_getIDEjecucion] in directory [/Fuentes/BEXLogica/SUNAT/JP01_DescargaFuentes/J_Control]2013/12/19 23:20:31 - getIDEjecucion - Starting transformation...(file=null, name=getIDEjecucion, repinfo=Transformation) 2013/12/19 23:20:31 - t_getIDEjecucion - Transformation is pre-loaded. 2013/12/19 23:20:31 - t_getIDEjecucion - Dispatching started for transformation [t_getIDEjecucion] 2013/12/19 23:20:31 - t_getIDEjecucion - Nr of arguments detected:0 2013/12/19 23:20:31 - t_getIDEjecucion - This is not a replay transformation 2013/12/19 23:20:31 - t_getIDEjecucion - I found 3 different steps to launch. 2013/12/19 23:20:31 - t_getIDEjecucion - Allocating rowsets... 2013/12/19 23:20:31 - t_getIDEjecucion - Allocating rowsets for step 0 --> get IDEjecucion 2013/12/19 23:20:31 - t_getIDEjecucion - prevcopies = 1, nextcopies=1 2013/12/19 23:20:31 - t_getIDEjecucion - Transformation allocated new rowset [get IDEjecucion.0 - Set IDEjecucion.0] 2013/12/19 23:20:31 - t_getIDEjecucion - Allocated 1 rowsets for step 0 --> get IDEjecucion 2013/12/19 23:20:31 - t_getIDEjecucion - Allocating rowsets for step 1 --> Set IDEjecucion 2013/12/19 23:20:31 - t_getIDEjecucion - prevcopies = 1, nextcopies=1 2013/12/19 23:20:31 - t_getIDEjecucion - Transformation allocated new rowset [Set IDEjecucion.0 - Copy rows to result.0] 2013/12/19 23:20:31 - t_getIDEjecucion - Allocated 2 rowsets for step 1 --> Set IDEjecucion 2013/12/19 23:20:31 - t_getIDEjecucion - Allocating rowsets for step 2 --> Copy rows to result 2013/12/19 23:20:31 - t_getIDEjecucion - Allocated 2 rowsets for step 2 --> Copy rows to result 2013/12/19 23:20:31 - t_getIDEjecucion - Allocating Steps & StepData... 2013/12/19 23:20:31 - t_getIDEjecucion - Transformation is about to allocate step [get IDEjecucion] of type [TableInput] 2013/12/19 23:20:31 - get IDEjecucion.0 - distribution activated 2013/12/19 23:20:31 - get IDEjecucion.0 - Starting allocation of buffers & new threads... 2013/12/19 23:20:31 - get IDEjecucion.0 - Step info: nrinput=0 nroutput=1 2013/12/19 23:20:31 - get IDEjecucion.0 - output rel. is 1:1 2013/12/19 23:20:31 - get IDEjecucion.0 - Found output rowset [get IDEjecucion.0 - Set IDEjecucion.0] 2013/12/19 23:20:31 - get IDEjecucion.0 - Finished dispatching 2013/12/19 23:20:31 - t_getIDEjecucion - Transformation has allocated a new step: [get IDEjecucion].0 2013/12/19 23:20:31 - t_getIDEjecucion - Transformation is about to allocate step [Set IDEjecucion] of type [SetVariable] 2013/12/19 23:20:31 - Set IDEjecucion.0 - distribution activated 2013/12/19 23:2... Process Exit Code 1. The step failed.

    Any advice.

    Regards,

    Benjamin

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

    Default

    Use kitchen with the -log=filepathname parameter to get all log lines.
    You'll spot the ERROR lines with ease, then.
    So long, and thanks for all the fish.

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.