Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: Use paramater from Xaction

  1. #1
    Join Date
    Feb 2009
    Posts
    18

    Default Use paramater from Xaction

    Hello, I'm new with Kettle
    I want use a paramater from Xaction to a transformation
    i've tried get variable or get system info to put in filename of an xml output but it didn't work
    someone knows how to use a paramater please?

    Regards
    Last edited by cced; 03-13-2009 at 06:42 AM.

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

    Default

    arguments you can get via get system info step. Parameters (if you would be using a PDI v3.2 or higher) are as far as I know not yet in the Xaction thingies.

    Regards,
    Sven

  3. #3
    Join Date
    Feb 2009
    Posts
    18

    Default

    When i use a get system info and I add a hope
    I have that:
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Unexpected error :
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : org.pentaho.di.core.exception.KettleException:
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Error writing XML row rg.pentaho.di.core.exception.KettleException:
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Field [SYS_HeaderId] couldn't be found in the input stream!
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) :
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Row: [C:\]
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) :
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Field [SYS_HeaderId] couldn't be found in the input stream!
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) :
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) :
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.trans.steps.xmloutput.XMLOutput.writeRowToFile(XMLOutput.java:208)
    2009/03/13 12:35:01 - Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.trans.steps.xmloutput.XMLOutput.processRow(XMLOutput.java:110)
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
    2009/03/13 12:35:01 - Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.trans.steps.xmloutput.XMLOutput.run(XMLOutput.java:373)
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Caused by: org.pentaho.di.core.exception.KettleException:
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Field [SYS_HeaderId] couldn't be found in the input stream!
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) :
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.trans.steps.xmloutput.XMLOutput.writeRowToFile(XMLOutput.java:137)
    Header Transaction.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : ... 3 more

  4. #4
    Join Date
    Feb 2009
    Posts
    18

    Default

    any idea please?

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It means that you are using a field that doesn't exist. That's all.
    It's got nothing to do with xactions or anything like that.

  6. #6
    Join Date
    Feb 2009
    Posts
    18

    Default

    so how can I use a paramater from Xaction to a transformation please?

  7. #7
    Join Date
    Feb 2009
    Posts
    296

    Default

    You currently have no problem with the parameter. You're missing a field in your stream. Fix this problem and you might discover that your parameter does work.
    Fabian,
    doing ETL with his hands bound on his back

  8. #8
    Join Date
    Feb 2009
    Posts
    18

    Default

    Hello I have resolved my problem in Kettle
    but now when I have Create the xaction
    I have add the parameter ex:dir(string) | request dir
    but when I execute the xaction I have that error:
    Debug : [fr_21] Starting execute of bi-developers/etl/CommoditiesTransaction.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine)
    Debug : [fr_30] Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine)
    Debug : [fr_33] Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine)
    Erreur : SolutionEngine.ERROR_0007 - [fr_27] Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)

    in the transformation step should I put anything inside?
    Regards

  9. #9
    Join Date
    Feb 2009
    Posts
    18

    Default

    up no idea?

  10. #10
    Join Date
    Feb 2009
    Posts
    18

    Default

    someone has an xaction to share please?

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.