US and Worldwide: +1 (866) 660-7555
Results 1 to 3 of 3

Thread: Running kitchen.sh from xml file

  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Default Running kitchen.sh from xml file

    I am trying to run kitchen.sh referencing a xml file and am having great difficulty.

    I have used Spoon to export all transformations and jobs to a directory. My primary job ("Phased ETL") has nested jobs, including one called "Extract from OLTP". When I try to execute Phased ETL with kitchen, I get the following errors:

    PK-Computer:/Applications/Kettle.app/Contents/Resources/Java pk$ ./kitchen.sh -file=/Users/pk/dev/config/test/jobs/etl2/Phased\ ETL.kjb
    INFO 28-01 11:07:49,002 (LogWriter.java println:403) -Kitchen - Start of run.
    2008/01/28 11:07:50:188 EST [INFO] DefaultFileReplicator - Using "/tmp/vfs_cache" as temporary files store.
    INFO 28-01 11:07:50,445 (LogWriter.java println:403) -Phased ETL (Phased ETL (Thread-1)) - Sleeping: 0 minutes
    INFO 28-01 11:07:50,446 (LogWriter.java println:403) -Phased ETL - Starting entry [Extract from OLTP]
    ERROR 28-01 11:07:50,447 (LogWriter.java println:400) -Extract from OLTP - Error running job entry 'job' : org.pentaho.di.core.exception.KettleException:
    Unable to load the job: please specify the name and repository directory OR a filename

    ERROR 28-01 11:07:50,447 (LogWriter.java println:400) -Extract from OLTP - org.pentaho.di.core.exception.KettleException:
    Unable to load the job: please specify the name and repository directory OR a filename

    at org.pentaho.di.job.entries.job.JobEntryJob.execute(JobEntryJob.java:396)
    at org.pentaho.di.job.Job.execute(Job.java:331)
    at org.pentaho.di.job.Job.execute(Job.java:389)
    at org.pentaho.di.job.Job.execute(Job.java:257)
    at org.pentaho.di.kitchen.Kitchen.main(Kitchen.java:331)

    INFO 28-01 11:07:50,450 (LogWriter.java println:403) -Phased ETL - Finished jobentry [Extract from OLTP] (result=false)
    INFO 28-01 11:07:50,451 (LogWriter.java println:403) -Kitchen - Finished!
    ERROR 28-01 11:07:50,451 (LogWriter.java println:400) -Kitchen - Finished with errors
    INFO 28-01 11:07:50,451 (LogWriter.java println:403) -Kitchen - Start=2008/01/28 11:07:50.316, Stop=2008/01/28 11:07:50.451
    INFO 28-01 11:07:50,452 (LogWriter.java println:403) -Kitchen - Processing ended after 0 seconds.

    I can, however, run the job successfully by referencing it via the repository. This is not an option for us in our production system.

    I have also tried to export all of the transformations and jobs into just one file via the repository browser without success.

    Am I attempting an unsupported operation?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    The references to the repository are not automatically deleted/replaced if you export the jobs. If you want to run eventually from XML files you should probably develop using XML files, look at e.g. the job/transformation job entry and you will probably see that it's still pointing to a repository.

    Regards,
    Sven

  3. #3
    Join Date
    Oct 2007
    Posts
    2

    Default

    Thanks Sven! I'll give that a whirl.

    - Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •