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

Search Forums:

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

Page 1 of 50 1 2 3 4

Search Forums: Search took 0.19 seconds; generated 59 minute(s) ago.

  1. 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}
    ...
  2. Replies
    11
    Views
    422

    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.
  3. 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...
  4. 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...
  5. It's correct -- you can create a folder that...

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

    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)
  7. Replies
    19
    Views
    207

    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
  8. Replies
    19
    Views
    207

    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
  9. Replies
    19
    Views
    207

    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...
  10. Replies
    19
    Views
    207

    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...
  11. Replies
    19
    Views
    207

    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...
  12. 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.
  13. 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...
  14. 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...
  15. 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)
  16. 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.
  17. 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.
  18. Try not using the date as part of the key.

    Try not using the date as part of the key.
  19. 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...
  20. Try using the Modified Java Script Value step...

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

    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.
  22. 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.
  23. 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...
  24. Replies
    7
    Views
    1,442

    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...
  25. Replies
    7
    Views
    1,442

    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" )
  26. 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...
  27. 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...
  28. Replies
    5
    Views
    666

    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...
  29. Replies
    7
    Views
    1,442

    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.
  30. Replies
    5
    Views
    905

    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...
  31. Replies
    6
    Views
    829

    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.
  32. Replies
    6
    Views
    829

    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?
  33. 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.
    ...
  34. Replies
    5
    Views
    932

    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.
  35. Replies
    5
    Views
    932

    This is because your group is mis-defined. ...

    This is because your group is mis-defined.

    What period do you want the Cumulative sum for?
    Note: If you want the Cumulative Sum for the day, and there are no transactions that day, then the...
  36. Replies
    5
    Views
    905

    Should just need the Text File Input and the...

    Should just need the Text File Input and the Oracle Bulk Loader...
  37. Replies
    5
    Views
    905

    You've done a lot of good work here! ...

    You've done a lot of good work here!

    Transforms are a little finicky, in that they have to have an Input step as well as an output step... So you need to have a step defined to read the file that...
  38. Ramireddy, If you had posted your actual file,...

    Ramireddy,

    If you had posted your actual file, instead of a one-line "this is what it's supposed to look like" we would have been able to tell you the problem almost right away.
  39. So... You're injecting Unix line ends into a...

    So... You're injecting Unix line ends into a field, and then wondering why saving that to a file and loading it doesn't work correctly?
  40. Your original post was about having problems with...

    Your original post was about having problems with Text File Input and line endings.

    The only way we can analyze this is by posting a simple version of your transform and your actual text file, but...
  41. Did you try that test file from your Claim2.ktr ?...

    Did you try that test file from your Claim2.ktr ?

    Your text file input (when corrected to point to text.txt ) can't even read the file correctly.
    That will be the first step to getting this...
  42. Replies
    2
    Views
    603

    Have a look at the Row Normalizer. ...

    Have a look at the Row Normalizer.

    http://wiki.pentaho.com/display/EAI/Row+Normaliser

    Try it out, and let us know how you make out.
  43. Somehow in something you are doing in your...

    Somehow in something you are doing in your transform, either in the input data, or through one of the manipulations you do, a null value is getting through to the table output. Oracle won't lie to...
  44. This one I haven't seen before, but I'm betting...

    This one I haven't seen before, but I'm betting that the function doesn't like one of the parameters.

    This means that you have two different elements on the report that are touching. Think about...
  45. It sounds like your file isn't actually a DOS...

    It sounds like your file isn't actually a DOS file. Try the Unix line endings, or the mixed setting.
  46. Honestly, that sounds like a webserver...

    Honestly, that sounds like a webserver configuration issue - instead of executing the PRPT, it is trying to send it to the browser. Since the browser doesn't know what to do with it, it gives the...
  47. The http://community.pentaho.com link? Your...

    The http://community.pentaho.com link?

    Your thread says 5.0.1, but the link downloads 5.1.0 ...
    You can find 5.0.1 on Sourceforge (...
  48. Replies
    2
    Views
    1,371

    The PRPT in the sample is embedded to connect to...

    The PRPT in the sample is embedded to connect to the SampleData dataset, which is stored in the Hypersonic DB.
    You can use the Reporting Step with a report that is designed to connect directly to...
  49. :) All good! You're really getting the...

    :)

    All good!
    You're really getting the details of the software though :D
  50. You should really use the report designer...

    You should really use the report designer designed for your server version.

    That would be PRD5.0
Results 1 to 50 of 2496
Page 1 of 50 1 2 3 4