Running kitchen.sh from xml file

[pkaib]

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?

[sboden]

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

[pkaib]

Thanks Sven! I'll give that a whirl.

- Paul