Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Execute a .KJB in an xaction

  1. #1
    Join Date
    Oct 2006
    Posts
    219

    Default Execute a .KJB in an xaction

    When i try to run my .kjb in a kettle process action i get nothing. Ive tested .ktrs and these are fine but the kjb files never seem to run.
    The output for the catalina.out is:

    INFO 28-04 11:39:36,341 - SharedObjects - Reading the shared objects file [file:///home/hazamonzo/.kettle/shared.xml]
    INFO 28-04 11:39:36,342 - org.pentaho.di.trans.TransMeta - The shared object fie [null] is empty!
    DEBUG 28-04 11:39:36,342 - org.pentaho.di.trans.TransMeta - We have 0 connections...
    DEBUG 28-04 11:39:36,343 - org.pentaho.di.trans.TransMeta - Reading 0 steps...
    DEBUG 28-04 11:39:36,343 - org.pentaho.di.trans.TransMeta - We have 0 hops...
    DEBUG 28-04 11:39:36,343 - org.pentaho.di.trans.TransMeta - nr of steps read : 0
    DEBUG 28-04 11:39:36,343 - org.pentaho.di.trans.TransMeta - nr of hops read : 0
    INFO 28-04 11:39:36,344 - Trans - Transformation is pre-loaded.
    DEBUG 28-04 11:39:36,344 - Trans - nr of steps to run : 0 , nr of hops : 0
    INFO 28-04 11:39:36,344 - Trans - Dispatching started for filename [/home/hazamonzo/bi-projects/project-hotel/solution//hotel/test_job.kjb]
    INFO 28-04 11:39:36,344 - Trans - Nr of arguments detected:0
    INFO 28-04 11:39:36,345 - Trans - This is not a replay transformation
    INFO 28-04 11:39:36,345 - Trans - I found 0 different steps to launch.
    INFO 28-04 11:39:36,345 - Trans - Allocating rowsets...
    INFO 28-04 11:39:36,345 - Trans - Allocating Steps & StepData...
    INFO 28-04 11:39:36,345 - Trans - This transformation can be replayed with replay date: 2010/04/28 11:39:36
    INFO 28-04 11:39:36,346 - Trans - Initialising 0 steps...
    INFO 28-04 11:39:36,346 - Trans - Transformation has allocated 0 threads and 0 rowsets.

    Has ANYONE out there been able to execute a .KJB in a xaction? And if so what hacks did you use to get it to work?

    If you're interested the pastebin for the transformation and xacion can be found here:

    http://pastebin.com/Uf5jWdvF
    http://pastebin.com/PzKkcE0j
    www.ivy-is.co.uk - Ivy Information Systems

    Come join the non official Pentaho IRC chat room on irc.freenode.net in the ##pentaho channel

  2. #2
    Join Date
    Dec 2005
    Posts
    531

    Default

    Hi Hazamonzo,

    I did...no hacks just used the PDI job action...I'll try to get in touch with you in ##Pentaho or post an example here.

    Take care.

  3. #3
    Join Date
    Oct 2006
    Posts
    219

    Default

    I found the solution. Its down to some cock up with PDS (surprise surprise). Looks like when you add the process action Get Data from PDI or whatever, you only get the execute transformation gui. to force the job gui into existence you have to edit the XML and replace a couple of the transformation XML tags with job ones. I can't remember off the top of my head which ones but i'll post it later.
    www.ivy-is.co.uk - Ivy Information Systems

    Come join the non official Pentaho IRC chat room on irc.freenode.net in the ##pentaho channel

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.