Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Mark.James.Cloud2Land; Keyword(s):

Page 1 of 3 1 2 3

Search Forums: Search took 0.02 seconds.

  1. Hi, Well it's a pk/unique field violation, 19...

    Hi,

    Well it's a pk/unique field violation, 19 seems low for a key value, I'd check your source data first.
  2. Hi, Have a look at this...

    Hi,

    Have a look at this http://www.cloud2land.com/2011/06/pentaho-data-integration-how-to-process-multiple-files/
  3. Replies
    2
    Views
    1,228

    ok, i googled it, something like this should do:...

    ok, i googled it, something like this should do:



    #!/bin/sh
    lockfile="/var/lock/mytask"
    if [ ! -e $lockfile ]; then
    trap "rm -f $lockfile; exit" INT TERM EXIT
    touch $lockfile
  4. Replies
    2
    Views
    1,228

    Hi, Cron will spawn another process which you...

    Hi,

    Cron will spawn another process which you probably don't want, you could either extend the interval or add a simple shell script to check if an existing process is still running, google "cron...
  5. Hi, Try setting Fields -> OrderID -> attribute...

    Hi,

    Try setting Fields -> OrderID -> attribute = Y in your <order> step
  6. Hi, The "target" step need to be exactly one...

    Hi,

    The "target" step need to be exactly one row containing a String field containing your xml doc.
  7. Hi, OrderID will be an attribute (or tag?) of...

    Hi,

    OrderID will be an attribute (or tag?) of an Order element in your target String field (xmlOrders in your example) and OrderLines will be an empty element into which the source contents will...
  8. Hi, The xpath is specifiying the node/s you...

    Hi,

    The xpath is specifiying the node/s you wish to add to in the xml target field, so in your example it will be something like //Order[@OrderId=?]/OrderLines, what you had could be fine but you...
  9. Hi, You need to load the xml orders document...

    Hi,

    You need to load the xml orders document into a single row-field and the xml join will then add the rows from the source step to it.
  10. Just click "Go advanced" then the "Wrap HTML"...

    Just click "Go advanced" then the "Wrap HTML" option (looks like <>) or just type the tags: HTML] [/HTML]
  11. Replies
    20
    Views
    5,068

    Hi, Which version of PDI? this is possibly...

    Hi,

    Which version of PDI? this is possibly relevant http://jira.pentaho.com/browse/PDI-2386

    You could always split it into two transformations and use a job to run them, that would definitely...
  12. Hi, The errors saying it's the...

    Hi,

    The errors saying it's the apache...Document class it can't find, weird about the IO classes. Try dropping the jar in your JRE's .../jre/lib/ext folder.
  13. Hi, I'm not exactly clear on the problem, can...

    Hi,

    I'm not exactly clear on the problem, can you post the output you want to generate from sample input data, also wrapping code in the html tags (looks like <>) make it much easier to read. eg....
  14. Hi, Wow that's a bit grim! is there anything...

    Hi,

    Wow that's a bit grim! is there anything that could be throttling your db access? any clues in the oracle log? and what's mem usage like over when it drops to snails pace?
  15. Hi, Just got a general troubleshooting...

    Hi,

    Just got a general troubleshooting suggestion, use a process of elimination to find out where the bottleneck is, eg. if you remove last few steps and stop at sort is it still very slow? and...
  16. Hi, You can change a field's meta data easily...

    Hi,

    You can change a field's meta data easily enough, just modify/replace the appropriate ValueMeta in the output row meta. The book by Matt Casters (on his sig) is def worth a read, and you can...
  17. Hi, This is for a PDI stream? Not sure if you...

    Hi,

    This is for a PDI stream? Not sure if you could do it with standard steps but it's certainly possible with a "User Defined Java Class", just add your header comments in the "if (first)..."...
  18. Hi, You need to make sure the data Objects in...

    Hi,

    You need to make sure the data Objects in the output row correspond to the types set in the output row's meta (ValueMeta.TYPE_XYZ) but I think a ValueMeta.TYPE_INTEGER is actually a Long so...
  19. Hi, Checkout a build from...

    Hi,

    Checkout a build from svn://source.pentaho.org/svnkettleroot/ and grab the jars from <kettle directory>/lib, there'll be 5 of them: kettle-core/db/engine/test/swt (and there's arch' specific...
  20. Replies
    2
    Views
    4,747

    Hi, Try a "Replace in String" step as follows:...

    Hi,

    Try a "Replace in String" step as follows:

    In stream: filename
    Out Stream: mask
    Use Regex: Y
    Search ^.*_(NT\d{10})$
    Replace with: $1
  21. Replies
    5
    Views
    2,053

    Hi, I think it's an in-built java Collections...

    Hi,

    I think it's an in-built java Collections method that does the actual sorting so not something you can configure. You could just replace the nulls with an appropriately high value before...
  22. Hi, That's saving them ok, but you're not...

    Hi,

    That's saving them ok, but you're not "using" them in the main step class. In PhoneticStep's if (first) block you need to add the new fields meta to data.outputRowMeta. e.g...
  23. Hi, I'm guessing you're adding the new fields...

    Hi,

    I'm guessing you're adding the new fields to the step's output data but not to the output row's meta, you have to add the new field definitions to that. (name, type, format...)
  24. Replies
    10
    Views
    1,516

    Just a PS. you can use a calculator step to...

    Just a PS. you can use a calculator step to create copy fields
  25. Replies
    10
    Views
    1,516

    Hi, The "replace in string" lets you add new...

    Hi,

    The "replace in string" lets you add new field, just enter the new field name in "out stream field"
  26. Replies
    10
    Views
    1,516

    Hi, There's probably a simpler way but try a...

    Hi,

    There's probably a simpler way but try a "Replace in string" step as follows:

    instream: yourdatefield
    outstream: hours
    use regex: Y
    search: ^.*(\d\d):\d\d:\d\d.*$
    replace: $1
  27. Hi, You don't need a sub job for the "Copy...

    Hi,

    You don't need a sub job for the "Copy Files" step, just tick "Dest is a file" and "copy previous results" and make sure your transformation outputs 3 columns, (source,dest,wildcard in that...
  28. Replies
    2
    Views
    1,448

    Hi, Have a look at...

    Hi,

    Have a look at http://wiki.bizcubed.com.au/xwiki/bin/view/Pentaho+Tutorial/Java
  29. Hi, You could try echo'ing that command to a...

    Hi,

    You could try echo'ing that command to a file (echo "$JAVA_BIN $3 $4 $OPT org.pentaho.di.kitchen.Kitchen \"${1+$@}\"" >> kit.log) and see what it actually is when you run kitchen.sh?

    Also...
  30. Hi, I think I see the problem, you're using ?...

    Hi,

    I think I see the problem, you're using ? params in your sql, which will expect 2 parameters as input but you're only supplying one, try "select ArtNr, ArtNr..." in the first step
  31. Replies
    3
    Views
    836

    Hi, Have to ask, i'm curious why you want to...

    Hi,

    Have to ask, i'm curious why you want to delete an error from the log? but you could use another PDI transformation and a filter rows to drop it.
  32. Hi, This is a bit of a stab-in-the-dark but...

    Hi,

    This is a bit of a stab-in-the-dark but how are you packaging your app, I'm assuming you're signing it, have you tied an unsigned jar into it somehow, and if so could you try including the...
  33. Replies
    1
    Views
    772

    Hi, Have a look at the transformation step:...

    Hi,

    Have a look at the transformation step: Input -> Get System Info, and make sure you set an appropriate "Variable Scope" when you Set Vars.
  34. Hi, It was a bug,...

    Hi,

    It was a bug, http://jira.pentaho.com/browse/PDI-4440 fixed in 4.0.2+
  35. Hi, Which version of PDI is it? and where did...

    Hi,

    Which version of PDI is it? and where did you download it from?
  36. Hi, I'm guessing your JVM has access to more...

    Hi,

    I'm guessing your JVM has access to more than one Log related jar, have you got multiple versions of kettle jars installed "anywhere" the class loader might be looking.
  37. Hi, You can use variables to create any sql,...

    Hi,

    You can use variables to create any sql, you'll just have to split the task into two transformations, one to set the variables and the second to get them and create the query (table...
  38. Hi, As a work around you could add a Utility...

    Hi,

    As a work around you could add a Utility -> "If field value is null" step to set a default for them.
  39. Hi, Have a look at this, in essence almost...

    Hi,

    Have a look at this, in essence almost same as gutlez suggestion:

    * filter depts -> insert them and add returned pk field
    * resort the rows back to initial order
    * javascript to keep...
  40. Hi, That's good news, but annoying when you...

    Hi,

    That's good news, but annoying when you waste time trying to "solve" such problems, another case of windows voodoo I expect, rebooting always worth a go with weird problems!
  41. Hi, Yep windows here too, I've attached a...

    Hi,

    Yep windows here too, I've attached a test ktr, this works for me on 4.1.0 and 4.2
  42. Hi,

    That's strange, I tried it on 4.1.0 stable here and get the following, hopefully 4.2 will work though, let us know...

    7433
  43. Hi, There was a bug with that plugin which i...

    Hi,

    There was a bug with that plugin which i believe is fixed in the latest version. with 4.1 you can use the following though: in stream: abc, out stream: xyz, user regex: y, search: /, replace...
  44. Replies
    6
    Views
    1,993

    Hi, It's designed to be run as one instance,...

    Hi,

    It's designed to be run as one instance, and as multiple instances would be accessing the same resources (eg.repository) I don't think it's a good idea, though it is possible. Why do you...
  45. Hi, You're welcome, I did notice the above...

    Hi,

    You're welcome, I did notice the above misses if the M1106 is at the end of the string though, if that's possible you just need to make the last bit optional, so



    var dir="";
    if...
  46. Hi, Well I'm not sure why preview works but I...

    Hi,

    Well I'm not sure why preview works but I see why execute doesn't, it's reading from the saved version of your meta data (eg. a repository entry) and your meta class isn't saving all the data...
  47. Hi, You don't need ${file} in the "Variable...

    Hi,

    You don't need ${file} in the "Variable name" fields of Set Vars, just "file", and to grab just the yymm bits:



    var dir="";
    if (/^.*_(M\d{4})_.*$/.test(filename)){
    ...
  48. Have you implemented preview in your dialog? if...

    Have you implemented preview in your dialog? if so can you attach that too. also can you export your trans as a ktr and attach that, possibly something's not saving correctly in the meta. it is a...
  49. I've had a read of your step code and I can't see...

    I've had a read of your step code and I can't see where you're adding the new ValueMetas to data.outputRowMeta?? if you add the following before putRow(...) what do you get?


    ...
  50. Hi, I'm guessing you have your plugin...

    Hi,

    I'm guessing you have your plugin connected direct to a text output step? that step will need to know which fields to expect if you right click it and "show input fields" is it correct?...
Results 1 to 50 of 121
Page 1 of 3 1 2 3
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.