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

Search Forums:

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

Page 1 of 54 1 2 3 4

Search Forums: Search took 0.23 seconds.

  1. Replies
    3
    Views
    86

    Do you have a repository clause in your Carte...

    Do you have a repository clause in your Carte Configuration XML?
    http://wiki.pentaho.com/display/EAI/Carte+Configuration
  2. Replies
    4
    Views
    94

    What character set are you starting PDI with?

    What character set are you starting PDI with?
  3. Replies
    4
    Views
    94

    It sounds like your version of MySQL doesn't...

    It sounds like your version of MySQL doesn't support UTF8MB4. Try using just UTF8
  4. Replies
    3
    Views
    82

    You missed attaching the FULL error message. The...

    You missed attaching the FULL error message. The stacktrace is cut off in your screenshot. Screenshots are not the most useful way of posting error messages.
  5. Replies
    3
    Views
    86

    Do you have a .kettle folder in KETTLE_HOME? Do...

    Do you have a .kettle folder in KETTLE_HOME?
    Do you have a repositories.xml file in the .kettle folder of KETTLE_HOME?
  6. Replies
    3
    Views
    82

    Which input (Text File Input or CSV Input) are...

    Which input (Text File Input or CSV Input) are you using?
  7. Replies
    4
    Views
    103

    Can I guess that column 23 is a NVARCHAR column?

    Can I guess that column 23 is a NVARCHAR column?
  8. What type of number? If it's an Int, then 4 is...

    What type of number? If it's an Int, then 4 is the right answer.
    If it's a number, then check the format mask... It might be as a # rather than #.###
  9. Replies
    5
    Views
    146

    I'm going to assume you mean Child...

    I'm going to assume you mean Child Transformation, not child job. Note: You CANNOT set and use a Variable in the same transformation, as **ALL** steps initialize at the beginning. Thus, your...
  10. Replies
    1
    Views
    52

    There are a LOT of posts that are spam that are...

    There are a LOT of posts that are spam that are posted to this forum.

    Unfortunately for you, a number of them come from your IP address range. This likely means that someone on the same Internet...
  11. Since Analyzer is an EE feature, why don't you...

    Since Analyzer is an EE feature, why don't you talk to your support rep?
  12. But what if I have data coming from two different...

    But what if I have data coming from two different databases (Table Input steps) that I know are sorted correctly (because I used a "order by" clause) ... Why should I pay a performance penalty to...
  13. Mattia, Because PDI is designed to run steps...

    Mattia,

    Because PDI is designed to run steps in parallel, you cannot set and use variables within one transform. You have to either declare it as a parameter, or use a job.
  14. You can do that sort of thing, *IF* all of the...

    You can do that sort of thing, *IF* all of the "Dimension" types are the same (eg. all _code columns are Integer)

    Please note that this forum is a place for all users to discuss how to use and...
  15. Thread: time dimension

    by gutlez
    Replies
    3
    Views
    157

    It seems to be in the other thread...

    It seems to be in the other thread
  16. Replies
    2
    Views
    136

    Check your proxy server. Something seems not...

    Check your proxy server. Something seems not happy there.
  17. Replies
    10
    Views
    209

    The problem is possibly related to your internet...

    The problem is possibly related to your internet provider... There is active spam filtering that happens on this forum, (keeping call girl posts and invitations for unrelated training at a...
  18. Replies
    6
    Views
    164

    I bet you have multiple hops somewhere set to...

    I bet you have multiple hops somewhere set to "Distribute" rather than "Copy"

    But as marabu said, post your transform, the community can help you sort out what's going on with it.
  19. Replies
    3
    Views
    169

    Then perhaps you should try calling it in a Table...

    Then perhaps you should try calling it in a Table Input step instead...
  20. Replies
    3
    Views
    169

    Call DB Procedure is not an Input step, so you...

    Call DB Procedure is not an Input step, so you can't start a Transformation with it.
    Put a Generate Rows, or a Data Grid in front of the DB Procedure step, and let us know how that works for you.
  21. Have a look at "Copy Rows to Results...

    Have a look at "Copy Rows to Results" and "Get Rows from Results"

    Let us know how you make out with it.
  22. Replies
    3
    Views
    173

    Be very careful here... If you are getting String...

    Be very careful here... If you are getting String data, it might not test out the way you expect it to.
    Since I'm not sure quite what you're trying to tell us the issue is, it's hard to troubleshoot.
  23. Replies
    3
    Views
    173

    I feel like something is getting lost in...

    I feel like something is getting lost in translation.

    The "How do you want to handle two outputs" is a basic logic piece - you have to tell PDI if you want to split the rows between the following...
  24. Which OS? Unix: You could schedule something...

    Which OS?

    Unix: You could schedule something in your startup scripts, or in cron.
    Windows: You could schedule something in autoexec.bat (I'm not sure if Windows Task Scheduler has "On Boot")
  25. Replies
    18
    Views
    255

    I'm getting the same, but not just on the Zip,...

    I'm getting the same, but not just on the Zip, the BZ2 as well.

    When I manually uncompressed them, and rebuilt it as described (bzip2 in zip file), I was able to do a GetFileNames on the zip:file...
  26. Replies
    18
    Views
    255

    Got it.

    Got it.
  27. Your question is actually very similar to this...

    Your question is actually very similar to this thread
    It's just that your "New Record" flag is "C400"
  28. Thread: sql Join

    by gutlez
    Replies
    1
    Views
    74

    Try setting the "Error on Multiple Rows" on your...

    Try setting the "Error on Multiple Rows" on your lookups.
  29. Replies
    18
    Views
    255

    Can you attach a really simple example file (of...

    Can you attach a really simple example file (of the Zip containing BZip files)?
  30. Find the file %USERPROFILE%/.kettle/.spoonrc...

    Find the file %USERPROFILE%/.kettle/.spoonrc
    Find the line OpenLastFile=Y
    Change it to OpenLastFile=N
    Save the file, and try it again.
  31. Replies
    18
    Views
    255

    Just a thought.... What about a Get File Names...

    Just a thought....

    What about a Get File Names step: zip:file://path/to/zip wildcard .*\.bz2
    Then the file input would be bz2:zip:file://path/to/zip/!bz2/file.txt ?
  32. By definition, all variables are strings... Do...

    By definition, all variables are strings... Do as njain suggested, and then convert it to an int.
  33. Replies
    2
    Views
    86

    This page...

    This page?
  34. Replies
    4
    Views
    179

    EE indicates that you have a support contract. ...

    EE indicates that you have a support contract. You might want to ask your Pentaho contact about this.
  35. Replies
    3
    Views
    110

    You know... This really screams "Build a cube"...

    You know... This really screams "Build a cube" to me.
    I'm not 100% sure how you would do "Last 12 months" and "Last 6 months", but there are a bunch of wizards over in the Mondrian forum that could...
  36. Replies
    8
    Views
    158

    And this is why I like marabu's solutions! I...

    And this is why I like marabu's solutions!
    I don't like the Javascript step - I consider it a last-resort step...
  37. Replies
    8
    Views
    158

    This request seems to come up often, and I'd love...

    This request seems to come up often, and I'd love to learn how to code a plug in just to solve it.

    In the mean-time, the usual solution:
    Text File Input - Read in each line of your file as a...
  38. Now that you got your type mismatch fixed, turn...

    Now that you got your type mismatch fixed, turn it back ON!
    It requires a little bit less chatty round-trips to the DB with Batch Mode ON, so you'll get slightly better performance with it. You can...
  39. Replies
    1
    Views
    70

    I usually recommend people start by reviewing the...

    I usually recommend people start by reviewing the step documentation.
    Specifically, in your case: This page
  40. Turn off batch updates, and you'll get a better...

    Turn off batch updates, and you'll get a better response from PostgreSQL

    Right now, it's telling you to "Call getNextException to see the cause."

    It may be something as simple as a type...
  41. Also, have a look in the "Run All" in the samples...

    Also, have a look in the "Run All" in the samples directory.
  42. Replies
    3
    Views
    113

    mailserver_table is complaining about an error,...

    mailserver_table is complaining about an error, and is throwing an error to the error handling (as defined)
    Abort step will abort a transform as soon as it gets a row... So it is aborting.
    ...
  43. Replies
    4
    Views
    186

    Depending on the PL/SQL code, you can sometimes...

    Depending on the PL/SQL code, you can sometimes do it in a Table Input step, which would make sense if you are trying to return a data set.

    Execute SQL is mostly for updating data within a...
  44. You would likely have to use the MS JDBC driver,...

    You would likely have to use the MS JDBC driver, rather than jtds ( http://sourceforge.net/p/jtds/feature-requests/73/ )
  45. Thread: Lead/lag series

    by gutlez
    Replies
    5
    Views
    137

    But don't forget to set the group on the Analytic...

    But don't forget to set the group on the Analytic Query to be your product!
  46. Did you declare the parameter in Transform 2? ...

    Did you declare the parameter in Transform 2? (Hint: Open Transform 2 and press Ctrl-T and then go to the Parameters tab)
  47. Transform 1 ends with "Copy Rows to Results"...

    Transform 1 ends with "Copy Rows to Results"
    Transform 2 declares Parameter "xxVALUE" (used in the Table Input as "select ... where xx=${xxVALUE}" quoting may be required!)
    In the Job, on the step...
  48. Replies
    1
    Views
    102

    Pentaho Report Output is a step designed to RUN a...

    Pentaho Report Output is a step designed to RUN a report file, not push data into a report that already exists.
    You cannot circularly reference the Transformation and the Report.

    Have a good look...
  49. First thing I would suggest is using the MS...

    First thing I would suggest is using the MS Access input rather than Table Input over ODBC.
  50. And njain provided you one way to do that. Not...

    And njain provided you one way to do that. Not the only way, but one way.
Results 1 to 50 of 2695
Page 1 of 54 1 2 3 4