Hitachi Vantara Pentaho Community Forums
Results 1 to 14 of 14

Thread: Calling Through XAction, Running on Foreign Machine

  1. #1

    Default Calling Through XAction, Running on Foreign Machine

    I've seen the boxes allowing you to setup slave/clustered machines etc, is it possible to call a Kettle Job XML from an XAction using the PDI process and have it run on another box, I don't know how it goes about executing stuff within the server itself(I'm guessing if you define a slave server in the job it will run fine) but I need to use the lousy Progress drivers on the windows box and I'm calling the xaction from a linux machine.

    Cheers

    Tom

    Edit: Title Sucks, I wish I could spell
    Last edited by bugg_tb; 01-03-2008 at 12:26 PM.
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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

    Default

    Yes... but the more moving parts, the sooner something will break... Currently (3.0.1) you'd have to startup a carte server on the server on which you want to run the transformation e.g.

    Regards,
    Sven

  3. #3

    Default

    Well as I don't have a spare few $$$k I can't get the linux JDBC drivers, so we have to make do with what we've got
    Anyway I'll give it a whirl once Carte decides its not going to bail everytime I start it

    Cheers

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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

    Default

    For carte you really need 3.0/3.0.1 I think.

    Regards,
    Sven

  5. #5

    Default

    You don't want 3.0 as I just found, 3.1 seems a tad better
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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

    Default

    Lol ... if 3.1 would be worse than 3.0/3.0.1 I would be disappointed... but 3.1 is not yet officially out

    Regards,
    Sven

  7. #7

    Default

    yeah yeah, typos

    3.0.1!
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  8. #8

    Default

    Actually on a slightly different topic, can we access kettles's DB based repo's yet in the xaction call itself or are they still all filebased?

    cheers

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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

    Default

    No repository... 90% sure.

  10. #10

    Default

    Right back on topic,

    When I call the job in Spoon 3.0.1 on the linux box it directs back to the Windows machine fine and runs the job. When I call the xaction it sends me a stack trace with some MYSQL errors, whats the difference?

    Cheers

    Tom

    Code:
    java.net.NoRouteToHostException: No route to host
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
    at java.net.Socket.connect(Socket.java:519)
    at java.net.Socket.connect(Socket.java:469)
    at java.net.Socket.<init>(Socket.java:366)
    at java.net.Socket.<init>(Socket.java:209)
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:173)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:267)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2739)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at be.ibridge.kettle.core.database.Database.connectUsingClass(Database.java:395)
    at be.ibridge.kettle.core.database.Database.normalConnect(Database.java:281)
    at be.ibridge.kettle.core.database.Database.connect(Database.java:246)
    at be.ibridge.kettle.core.database.Database.connect(Database.java:208)
    at be.ibridge.kettle.core.database.Database.connect(Database.java:198)
    at be.ibridge.kettle.trans.Trans.beginProcessing(Trans.java::
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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

    Default

    Is your app server in a DMZ or so?

    Regards,
    Sven

  12. #12

    Default

    no, both boxes are sat next to each other, I assume that it should use the windows machine for both the ODBC connection and the MYSQL connection like it would if I ran the Job locally on the Windows box, is that not the case?
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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

    Default

    My understanding is that the complete job is offloaded to carte. For the moment no idea why it would complain with the error above.

    Sven

  14. #14

    Default

    well yeah as it runs in 3.0.1 on the linux box ok I assumed the same, I don't know how the system runs the jobs though when called through the server as obviously it doesn't call the bash scripts directly. I was wondering if its running an old 2.* version and is having a fit with the slave server setup?

    Cheers

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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.