Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Kitchen Job that calls Transformation does not work

  1. #1
    Join Date
    Sep 2010
    Posts
    14

    Default Kitchen Job that calls Transformation does not work

    Hi,

    I hope somebody can help me with a strange problem I am facing. I have a job that is calling a transformation that gets data from a txt file and writes to db. If I run from spoon it runs ok. If I run it from kitchen the job starts ok, locates the transformation(I changed the name and I got an error) but it does not execute it and it does not give any errors.

    What I'm doing wrong? The following is how I call the transformation:

    kitchen.bat -file=balances.kjb -level=Basic

    Thanks,

    Christos.

  2. #2
    Join Date
    Sep 2011
    Posts
    190

    Default

    If you set your logging level to detailed or debug you may get the exact error that tells you what went wrong?

  3. #3
    Join Date
    Sep 2010
    Posts
    14

    Default

    I tried it but I get the same details in the log which does not show any errors:

    INFO 28-09 15:09:18,001 - Kitchen - Kitchen
    INFO 28-09 15:09:18,001 - Kitchen - Kitchen
    INFO 28-09 15:09:18,172 - LockTest - Start of job execution
    INFO 28-09 15:09:18,172 - LockTest - Starting entry [Check if procedure is runn
    ing...]
    INFO 28-09 15:09:18,631 - LockTest - Starting entry [obtainLock]
    INFO 28-09 15:09:18,713 - LockTest - Starting entry [load balances]
    INFO 28-09 15:09:18,715 - load balances - Loading transformation from XML file
    [file:///M:/BulkUploadCY/transformations/balanceUpdate.ktr]
    INFO 28-09 15:09:18,807 - balanceUpdate - Dispatching started for transformatio
    n [balanceUpdate]
    INFO 28-09 15:09:18,833 - balanceUpdate - This transformation can be replayed w
    ith replay date: 2011/09/28 15:09:18
    INFO 28-09 15:09:18,896 - LockTest - Starting entry [releaseLock]
    INFO 28-09 15:09:18,940 - LockTest - Finished job entry [releaseLock] (result=[
    true])
    INFO 28-09 15:09:18,942 - LockTest - Finished job entry [load balances] (result
    =[true])
    INFO 28-09 15:09:18,942 - LockTest - Finished job entry [obtainLock] (result=[t
    rue])
    INFO 28-09 15:09:18,943 - LockTest - Finished job entry [Check if procedure is
    running...] (result=[true])
    INFO 28-09 15:09:18,944 - LockTest - Job execution finished
    INFO 28-09 15:09:18,946 - Kitchen - Kitchen
    INFO 28-09 15:09:18,946 - Kitchen - Kitchen
    INFO 28-09 15:09:18,962 - Kitchen - Kitchen

  4. #4
    Join Date
    Sep 2010
    Posts
    14

    Default

    Ok. I found the error.

    In the transformation I open a text file that I have it set in the form of ${data.folder}\balpf.txt. When I run the job using kitchen for some reason it does not find the file and it does not give me an error. When I set the file with an absolute path it seems to be ok. Any ideas why this is happening?

    Christos.

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.