Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: cboyden; Keyword(s):

Page 1 of 3 1 2 3

Search Forums: Search took 0.02 seconds.

  1. Thread: PDI e drools

    by cboyden
    Replies
    16
    Views
    3,853

    You'll have to edit the spoon.bat file (back it...

    You'll have to edit the spoon.bat file (back it up) and change 'javaw' to 'java' so the console will show up. Then it will show there.
  2. Thread: PDI e drools

    by cboyden
    Replies
    16
    Views
    3,853

    You'll have to add the other two columns as well....

    You'll have to add the other two columns as well. I don't know if it overwrites them, or not. If not, create new columns and use another step (Select Values) to drop the originals and replace them.
  3. Thread: PDI e drools

    by cboyden
    Replies
    16
    Views
    3,853

    It looks like the only mention to how to get the...

    It looks like the only mention to how to get the data out from the wiki doc is "The step is configured to pick up these generated objects by name.".

    This is referring to the Results tab of the...
  4. Thread: PDI e drools

    by cboyden
    Replies
    16
    Views
    3,853

    Yes, the Modified Javascript Value step is a fine...

    Yes, the Modified Javascript Value step is a fine step to use.
  5. Thread: PDI e drools

    by cboyden
    Replies
    16
    Views
    3,853

    1) In PDI-EE-4.4.3.4 looking at the...

    1) In PDI-EE-4.4.3.4 looking at the pdi-ee\data-integration\libext\rules folder I see drools 5.0.1 is being used
    2) Everything starts out in the experimental folder until it has had time to be used...
  6. Thread: PDI e drools

    by cboyden
    Replies
    16
    Views
    3,853

    The steps are no longer in experimental, they now...

    The steps are no longer in experimental, they now reside in Scripting.

    There are two steps now, one works on a row-by-row basis while the other collects all rows and executes on them.
    ...
  7. Replies
    6
    Views
    2,618

    The Linkage error occurs because there is another...

    The Linkage error occurs because there is another copy of commons-httpclient*.jar somewhere.

    Probably in plugins/big-data-plugin/lib

    Delete that one and things should move forward.
  8. Replies
    15
    Views
    2,640

    When you do a preview you typically limit the...

    When you do a preview you typically limit the rows to be previewed. I think the default is 1000. If you get back more than 1000 the transformation will keep running even after you close the preview...
  9. Replies
    1
    Views
    1,154

    I tried to reproduce this locally, and while I...

    I tried to reproduce this locally, and while I cannot get the same error message that you get I was unable to pass in filenames from a previous job entry. I have created a Jira case for this....
  10. You're not exceeding your heap space, you're...

    You're not exceeding your heap space, you're getting a GC Overhead Limit Exceeded message. As I understand it the garbage collector is taking up too much processing time, so increasing Heap Space...
  11. Replies
    1
    Views
    2,539

    Make sure there is a javaw.exe in your jre/bin...

    Make sure there is a javaw.exe in your jre/bin directory. If not change 'javaw' to 'java' in the spoon.bat file. If this is the problem you'll have a console lingering in the background but...
  12. Thread: Autosave?

    by cboyden
    Replies
    4
    Views
    1,031

    Add some data to the Jira case as to when you...

    Add some data to the Jira case as to when you think the autosave should take place (timer, action, idle, etc...) maybe even an example app that could be mimicked please.
  13. Replies
    5
    Views
    3,329

    Just in case anyone else is curious, the relevant...

    Just in case anyone else is curious, the relevant regex appears to be: (\w+\s+\w+\s*)(.*)\s\-\s(\d{4})

    Marabu, that is pretty awesome!

    - Curtis


    -- Edit:
    For my own education I picked it...
  14. I found this and at a glance it looks pretty...

    I found this and at a glance it looks pretty good. http://open-bi.blogspot.com/2009/11/hi-all-i-would-like-to-start-serie-of.html

    The PDI CE component that you want to use is Carte.
  15. Replies
    6
    Views
    1,394

    In your spoon.sh file you can try adding...

    In your spoon.sh file you can try adding -Dfile.encoding="UTF-8" to the OPT= definition, changing the encoding type from UTF-8 to the one your Windows / MySQL system use.

    My guess is the default...
  16. Replies
    11
    Views
    1,181

    After sharing, you must re-open your jobs / trans...

    After sharing, you must re-open your jobs / trans for the connections to show up.
  17. Replies
    2
    Views
    732

    You can use error handling to route it (possibly...

    You can use error handling to route it (possibly to another file) where users can take action and re-run the errors only. Does that help?

    EDIT:
    Come to think of it, if you see a lot of the same...
  18. Replies
    2
    Views
    1,195

    Is your Job in a DB repository? Make sure the...

    Is your Job in a DB repository?

    Make sure the 'admin' repository exists in the user's ~/.kettle/repositories.xml file.

    Edit:
    The user who is executing carte, that is.
  19. Replies
    6
    Views
    889

    Just a thought given the step and error: The...

    Just a thought given the step and error:
    The transformation may not have been able to access the key fields in the table for any number of reasons and checking that information might be part of...
  20. Replies
    10
    Views
    1,765

    From the Linux machine, connect to the DB and do...

    From the Linux machine, connect to the DB and do a 'select * from r_user' on the repository database, the user should be there with the password: 2be98afc86aa7f2e4cb79ce71da9fa6d4 (admin)

    You...
  21. Replies
    10
    Views
    1,765

    Is the database accessible to your Linux box or...

    Is the database accessible to your Linux box or is it on your Windows machine and not permitting outside access?
  22. Replies
    10
    Views
    1,765

    Are you trying to connect to the DB repository...

    Are you trying to connect to the DB repository from Spoon on both machines or different tools?

    What version of PDI do you have installed on your Windows machine and what version on your Linux...
  23. Replies
    10
    Views
    1,765

    Are the licenses installed on the...

    Are the licenses installed on the Slackware64-current machine?
  24. Replies
    3
    Views
    1,314

    You may have to specify the "-dir" option as...

    You may have to specify the "-dir" option as well. I don't know as though I have ever tried to run a job through kitchen without it.
  25. Replies
    3
    Views
    1,314

    First thing that comes to mind is that the...

    First thing that comes to mind is that the repository "01" must be in the ~/.kettle/repositories.xml file of the user executing the kitchen command.

    Can you run spoon as the same user on the same...
  26. Replies
    2
    Views
    619

    If you open the settings window for the "Start"...

    If you open the settings window for the "Start" job entry, do you have an interval set?
  27. You can setup logging for various things to a...

    You can setup logging for various things to a database. You can track information about the transformation including the log from the run.

    More info can be found here...
  28. Replies
    8
    Views
    1,265

    Maybe use an XML step (not sure if they support...

    Maybe use an XML step (not sure if they support URLs, I think they do) or fetch with an HTTP step and process it. You can always create a transformation to fix the format if you really want to use...
  29. Thread: Pdi

    by cboyden
    Replies
    15
    Views
    1,966

    A understand Mick_data and agree that his...

    A understand Mick_data and agree that his response answers your question perfectly.

    What format is your text file in (CSV, Fixed Width, non-formatted)?
    What do you want to do with the contents of...
  30. Replies
    5
    Views
    3,342

    9148 So there were some error handling hops at...

    9148

    So there were some error handling hops at the end with a source, but no destination. I removed them and can now open the transformation.

    -- EDIT --
    Your transformation may be missing...
  31. Replies
    7
    Views
    4,885

    There is a "workaround" section here:...

    There is a "workaround" section here: http://wiki.pentaho.com/display/EAI/Web+services+lookup
    Both involve using other steps, that may give you more of what you want. (I haven't investigated looked...
  32. Replies
    5
    Views
    3,342

    Can you paste the error you are getting? (If you...

    Can you paste the error you are getting? (If you need to edit the spoon.bat file and change javaw to java. This will give you a console)
  33. Replies
    7
    Views
    4,885

    Does the "Check if webservice is available" step...

    Does the "Check if webservice is available" step work for you? You can specify a timeout there.
  34. Replies
    2
    Views
    762

    Sample: 9144 If I understand this correctly,...

    Sample: 9144

    If I understand this correctly, the issue is that there are an unknown number of "CommunicatoinNumber records, and even worse, multiple types (Type/Value, Qualifier/Identifer).
    The...
  35. Replies
    2
    Views
    1,014

    You can try the "Block this step until steps...

    You can try the "Block this step until steps finish" step under the Flow section, if you put it before Contact_Info, that may have the desired effect.

    Otherwise put each in their own...
  36. Have you installed the Big Data Plugin into PRD...

    Have you installed the Big Data Plugin into PRD (and your project?)

    If I recall correctly the HBaseInput step is in the Big Data Plugin, this needs to be in any project that you run that...
  37. Be mindful of the parallel nature of...

    Be mindful of the parallel nature of transformation steps. If someone sets the step to run multiple copies you may have to take synchronization and data scope into account. (Not a beginner's subject...
  38. Replies
    4
    Views
    1,291

    Okay, that is a little different. Kettle 4.3 has...

    Okay, that is a little different. Kettle 4.3 has a lot of plugin features that 3.2 does not (repositories, UI perspectives, etc...), however 4.3 still supports the plugin features that 3.2 did.
    So...
  39. I swear I had seen it in 4.3 but I must have been...

    I swear I had seen it in 4.3 but I must have been mistaken. I just checked and it is definitely in our next release. You can get the latest build here:...
  40. Replies
    4
    Views
    1,291

    Not directly (by firing up PDI 3.2.0 and trying...

    Not directly (by firing up PDI 3.2.0 and trying to connect to the 4.3.0 repository). But you may be able to export the 4.3.0 repository and import it into a 3.2.0 repository.
    Why are you...
  41. Replies
    4
    Views
    858

    Group using row number and generate file name

    9106

    Does something like the attached help you at all?

    The "Generate group id" step groups row numbers into ranges and creates a file name for each range.
    Note that if you add strings with A+B...
  42. Replies
    1
    Views
    785

    It is most often an oversight in resource...

    It is most often an oversight in resource management in code. Please file a jira case with as good of a reproduction path as you can get.
    The reproduction is very important as these are tricky to...
  43. Replies
    2
    Views
    850

    I have never seen this before, but it doesn't...

    I have never seen this before, but it doesn't look like an error. Is anything failing?

    Can you describe or attach the simplest example you can get to re-create this please?
  44. Replies
    2
    Views
    966

    Not in the same database. The table names are...

    Not in the same database. The table names are static and would not allow this.

    What is your goal in doing so?
  45. Replies
    4
    Views
    3,535

    Can you create a Jira case and attach a sample...

    Can you create a Jira case and attach a sample with a reproduction path please?
  46. Replies
    4
    Views
    3,535

    8480 I was able to access the child properties...

    8480

    I was able to access the child properties of Address by using a path like "$.Address.City".
    There is an example attached to my comment.

    I did however have to remove the ObjectId() wrapper...
  47. Replies
    2
    Views
    1,395

    You could always put a try/catch around the...

    You could always put a try/catch around the get(Fields.In, "stop") and get it as a string in the catch{} to see what value it is having a problem with.
  48. Replies
    3
    Views
    3,615

    I am attaching a sample: 8448 You can use a...

    I am attaching a sample: 8448

    You can use a field name as a file name in the "Text file output" step. Therefore you can use your I_CODE as your filename or create a new field containing the name...
  49. Replies
    8
    Views
    2,863

    Could you run some SQL to fetch then compare the...

    Could you run some SQL to fetch then compare the table's schemas?
  50. You haven't said which step you are using...

    You haven't said which step you are using specifically, but most wildcards are regex not windows directory style.
    Therefore .*\.csv would be all csv files.
Results 1 to 50 of 142
Page 1 of 3 1 2 3
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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