US and Worldwide: +1 (866) 660-7555

Search Forums:

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

Page 1 of 51 1 2 3 4

Search Forums: Search took 0.18 seconds.

  1. Replies
    2
    Views
    38

    A couple of options: 1) Don't set the...

    A couple of options:
    1) Don't set the KETTLE_HOME environment directory
    -or-
    2) Create $KETTLE_HOME/.kettle and run PDI once as a user that can write there. Then allow the users to read this...
  2. I'm going to assume that you are a programmer -...

    I'm going to assume that you are a programmer - this is usually the case when I see people complaining about PDI not doing what they want it to do. In the end, it often comes back to the user not...
  3. Replies
    4
    Views
    120

    Since the issue appears to be in your shared.xml ...

    Since the issue appears to be in your shared.xml

    Try renaming your ${UserHome}/.kettle/shared.xml file to something else (maybe shared.xml.bad ), and restarting spoon.

    Also, make sure that...
  4. Replies
    7
    Views
    162

    MySQL is notorious for timeouts and not really...

    MySQL is notorious for timeouts and not really behaving consistently.

    Being that a commit size of 20 works suggests to me that you are in fact running into timeouts (basically, instead of waiting...
  5. Multiline Calculator Option: New field ...

    Multiline Calculator Option:


    New field Calculation Field A Field B Field C Value type Length Precision Remove Conversion mask Decimal symbol Grouping symbol ...
  6. Replies
    7
    Views
    162

    Is it possible that your MySQL is timing out...

    Is it possible that your MySQL is timing out waiting for the data from HBase?
    Remember that the MySQL step initializes when the transform is first started, and then waits until the data is there to...
  7. So you're doing: Table Input (DWH) -> Table...

    So you're doing:
    Table Input (DWH) -> Table Input (Source) -> Table Output (DWH)

    In the "Table Input (DWH)", you have something like "select max(timestamp) from table"

    Question though... When...
  8. Did you create a partition scheme first?

    Did you create a partition scheme first?
  9. No worries! I have made some really simple...

    No worries!
    I have made some really simple mistakes working with PDI, that other people have had to patiently walk me through too, so I look at it as paying it forward.
  10. Winsock 10061 means connection refused

    Winsock 10061 means connection refused
  11. Switch/Case does not work like a standard case...

    Switch/Case does not work like a standard case statement - any steps after it that do not take input will execute at start-up (as they should!)

    Ranjan - Work through all your logic (Pentaho works...
  12. Replies
    3
    Views
    99

    Personally, at over 1K rows, I'd be looking for a...

    Personally, at over 1K rows, I'd be looking for a DB of some sort.
    Just because your source data is in a flat file, doesn't mean that you can't use a DB.

    You can load the data to a HSQL table in...
  13. Replies
    2
    Views
    96

    Where are you getting "imagem" from? Do you have...

    Where are you getting "imagem" from?
    Do you have Lazy conversion on?
  14. So let's start walking through it VERY slowly. ...

    So let's start walking through it VERY slowly.

    Start with:
    kitchen /listrep
    This should come back and tell you that it knows about Elucidata

    Next try:
    kitchen /rep:Elucidata /user:system...
  15. Replies
    16
    Views
    626

    But not "-XX:MaxPermSize=???m" ? Why not attempt...

    But not "-XX:MaxPermSize=???m" ?
    Why not attempt to increase the Perm size too?
  16. Replies
    16
    Views
    626

    What exactly did you set?

    What exactly did you set?
  17. Property Input is a Transformation Step, not a...

    Property Input is a Transformation Step, not a job step, so ${Internal.Job.Filename.Directory} should be expected to be null.
    You will want it to be ${Internal.Transformation.Filename.Directory}
    ...
  18. Replies
    16
    Views
    626

    Try the suggestions from...

    Try the suggestions from http://stackoverflow.com/questions/88235/dealing-with-java-lang-outofmemoryerror-permgen-space-error

    -Xms2096m -Xmx3048m does not impact PermGen space.
  19. I doubt it will work with Tomcat 7. It's not the...

    I doubt it will work with Tomcat 7. It's not the server configs that's the issue - it's the underlying Java language that is the issue.

    Enterprise (EE) is a little different than CE. They have...
  20. I found 5.0.1 in the usual download location......

    I found 5.0.1 in the usual download location...
    http://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/5.0.1-stable/biserver-manual-ce-5.0.1-stable.zip/download

    Also, just...
  21. It's correct -- you can create a folder that...

    It's correct -- you can create a folder that starts with a .
  22. Replies
    19
    Views
    247

    So you will want to put a Unique in there too....

    So you will want to put a Unique in there too.
    What makes the rows Unique? combination of cust_is and ord_id?

    So far:
    Text File -> Sort (cust_id, ord_id; unique rows only) -> Group By (cust_id)
  23. Replies
    19
    Views
    247

    So what is your expected outcome for two lines: ...

    So what is your expected outcome for two lines:



    ord_id
    cust_id
    cust_zip
    cust_first_ord_date
    cust_last_ord_date
    cust_life_ord_subtotal_amt
  24. Replies
    19
    Views
    247

    Where is the transform that goes with it? Also,...

    Where is the transform that goes with it?
    Also, did you notice that your data isn't valid? There is no date: 2011-03-79 or 2013-12-336
  25. Replies
    19
    Views
    247

    It's still not something that I can run from...

    It's still not something that I can run from here...

    SIMPLIFY the transformation just to what you want us to help with:
    Text File Input -> Group By -> Group By

    Build your sample data by...
  26. Replies
    19
    Views
    247

    Ok, so simplify your sample. Text File Input ->...

    Ok, so simplify your sample.
    Text File Input -> Group By 2

    Now remove everything in the Group By box except cust_id, leaving the Order Count as you have it.
    Now Preview the results.

    Does that...
  27. Replies
    19
    Views
    247

    So where does the Sample CSV fit into your...

    So where does the Sample CSV fit into your Transform?
    Which Group By do you think is not working right (Group By 2 or Group By 2 2 )?

    Did you follow the note in the Group By (Must have data...
  28. Or if you are using a very new PDI, you could...

    Or if you are using a very new PDI, you could look at the Transformation Executor step.
  29. What you describe is exactly what the combination...

    What you describe is exactly what the combination step is supposed to do:
    1) Look up the value in dimension table
    2) Insert the value in the dimension table if the value doesn't exist
    3) Return...
  30. You haven't given the Denormalizer any way to...

    You haven't given the Denormalizer any way to know what makes a new row, so it assumes that it is all the same row (look at your group configuration in the Denormalizer step) and only uses the last...
  31. Sounds like Network throughput latency. We...

    Sounds like Network throughput latency.

    We (the PDI community) usually recommend putting PDI as close to your database(s) as possible (in terms of network hops)
  32. I have heard of a few people getting it working,...

    I have heard of a few people getting it working, but I've never had it work correctly.
    Going to cron (or Windows Scheduled event) has had a 100% success rate.
  33. That is actually our usual suggestion. See Here...

    That is actually our usual suggestion. See Here for more info
    If however you have DI Server (Enterprise Feature), then contact Pentaho Support.
  34. Try not using the date as part of the key.

    Try not using the date as part of the key.
  35. You can't do it with that step - the simple rules...

    You can't do it with that step - the simple rules of prepared statements prevent it.
    This is why prepared statements are used to help prevent SQL Injection attacks.

    You would need to convert the...
  36. Try using the Modified Java Script Value step...

    Try using the Modified Java Script Value step rather than the Experimental "Script Value" step.
  37. Replies
    3
    Views
    406

    I'm not saying that it does work, but try putting...

    I'm not saying that it does work, but try putting the JAR into the <pdi-install>/lib directory instead of into the <pdi-install>/libext directory that you created.

    Let us know if that works.
  38. That's really not a good way to do it. Use the...

    That's really not a good way to do it.
    Use the "Create file when first row arrives" option.
  39. And I'll support you in that! There is always a...

    And I'll support you in that!
    There is always a balancing act in the system of long-term maintainability (what are you doing, and why are you doing it) vs. efficiency (what is the fastest way to do...
  40. Replies
    7
    Views
    1,554

    Well... That's just messy data at that point,...

    Well... That's just messy data at that point, but...

    You can use the Select Values step to rename the columns so that they are the same in both streams (Lookup succeeded, and Lookup Failed) and...
  41. Replies
    7
    Views
    1,554

    If they are strings, you can use the calculator...

    If they are strings, you can use the calculator step (even back in 3.2) to do String A + String B -> String AB (more specifically... "123" +"4567" becomes "1234567" )
  42. Is splice a variant of Pentaho BI Server? The...

    Is splice a variant of Pentaho BI Server? The Publish Schema function is expecting a full Pentaho BI Server 4 stack, including a Publisher password that has been set. If splice is not a Pentaho BI...
  43. Marabu, I agree with you about...

    Marabu,

    I agree with you about maintainability, but disagree with implementation. (Not like this is new to either of us :P )
    The Fliter Rows clearly shows the logic that is being applied...
  44. Replies
    5
    Views
    730

    Actually... Easiest thing to do is move your...

    Actually...

    Easiest thing to do is move your last two transforms into a wrapper job, and call that job for each row of the results.

    Remember that unlike Transformations, jobs run each step to...
  45. Replies
    7
    Views
    1,554

    What might actually be cleaner would be to define...

    What might actually be cleaner would be to define the lookup to fail if match isn't found, and then define error handling on the step to push those records to another stream to be dealt with.
  46. Replies
    5
    Views
    1,003

    It's not showing any fields in the Text File...

    It's not showing any fields in the Text File Input definition... You still have to tell PDI how to read the text file - it will then write it back out to a file that it will use in loading to...
  47. Replies
    6
    Views
    915

    You are using an experimental step, when there is...

    You are using an experimental step, when there is a perfectly good, well known script step that is not experimental.
  48. Replies
    6
    Views
    915

    This generally isn't a good sign. Why are you...

    This generally isn't a good sign.
    Why are you putting a script into your transformation if you aren't going to use any of the stream values?
  49. The root of this problem is that Text File Input...

    The root of this problem is that Text File Input is defined to end on a line end.
    As long as you continue to inject CHR(10) into your LISTAGG, Text File Input will not work the way you want it to.
    ...
  50. Replies
    5
    Views
    1,025

    So clear the group box completely. However, note...

    So clear the group box completely.
    However, note that this isn't really a repeatable transform - your data set would have to match EXACTLY for the outcome to be the same.
Results 1 to 50 of 2518
Page 1 of 51 1 2 3 4