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

Search Forums:

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

Page 1 of 63 1 2 3 4

Search Forums: Search took 1.36 seconds.

  1. Replies
    9
    Views
    73

    So how about a Nested Job? Job 1 - Start -...

    So how about a Nested Job?

    Job 1
    - Start
    - Transform A (As Described before)
    - Job 2 (Execute once for each row)
    - - Start
    - - Transform B (As described before)
    - - Transform C (As described...
  2. Replies
    9
    Views
    73

    If you had: TA: Data Grid (Column: Garbage,...

    If you had:
    TA: Data Grid (Column: Garbage, String) -> Copy Rows to Results
    TB: Get Rows -> Select Values (Rename Garbage -> Trash) -> Copy Rows to Results, Execute for each Row, Clear Results...
  3. Replies
    1
    Views
    37

    Try to always run PDI from its path, not from the...

    Try to always run PDI from its path, not from the Job path.

    from:
    C:\Users\solvian\.jenkins\workspace\Job 2> F:
    F:> cd V
    F:\V>Kitchen.bat /file:F:/[PATH]/jobs/job1.kjb
  4. Replies
    9
    Views
    73

    One additional note: Get rows from results...

    One additional note:
    Get rows from results consumes the rows.
    If you have a "Get rows from results" in TB, then TC cannot "Get rows from results" to get the same rows.
  5. Replies
    1
    Views
    35

    Within a particular level of a report, you can...

    Within a particular level of a report, you can only use 1 Data Source connection at a time.

    In nested levels, you might be able to cross databases.
    If you really need the data at one level from...
  6. In T2 Put a detect empty stream step between...

    In T2 Put a detect empty stream step between "Select Values" and "Copy Rows to Results"
    T3 will no longer fail, and will create a file with your headers and 1 blank row.

    T3 is failing because NO...
  7. Replies
    6
    Views
    104

    Changing the data about the data shouldn't change...

    Changing the data about the data shouldn't change the data itself.
  8. Replies
    6
    Views
    104

    I think what marabu was saying is that you can do...

    I think what marabu was saying is that you can do a lot of this in your SQL statement...

    Something along the lines of:
    SELECT TO_CHAR(date1, 'YYYY-MM-DD'), SUM((date2-date1)*24) from mytable...
  9. Replies
    4
    Views
    60

    http://wiki.pentaho.com/signup.action Fill in...

    http://wiki.pentaho.com/signup.action

    Fill in the form, and someone should likely get back to you.

    As for Jira, YES! they totally do. That's THE place to report a bug that you find anywhere...
  10. Replies
    2
    Views
    63

    Bug Fix list:...

    Bug Fix list:...
  11. Replies
    4
    Views
    60

    Just for amusement, try signing up at...

    Just for amusement, try signing up at http://jira.pentaho.com/login.jsp
    Then try those credentials on the Wiki page.
  12. Replies
    4
    Views
    122

    My immediate guess is that Cassandra is...

    My immediate guess is that Cassandra is configured to "listen" to only localhost (127.0.0.1), not the 10.0.2.5 address.

    Unfortunately, I'm not a Cassandra expert, so I can't tell you how to change...
  13. What if instead you were to put Table Input ->...

    What if instead you were to put Table Input -> Group By
    In the Group field you put the Business Key
    Then use the "Concatenate strings separated by" option
  14. Thread: Installation

    by gutlez
    Replies
    2
    Views
    77

    Make sure that your JAVA_HOME environment...

    Make sure that your JAVA_HOME environment variable is set correctly.

    Then run either spoon.bat or spoon.sh as appropriate for your system.
  15. I think he is being told to become a Pentaho...

    I think he is being told to become a Pentaho Specialist.
    I could be considered to be a Pentaho Specialist, and I've NEVER had EE available to me.
  16. No, using those settings on a server that's...

    No, using those settings on a server that's already in en_US doesn't make sense...
    However using:
    -Duser.language=pt -Duser.country=BR -Duser.variant=BR

    might make a lot of sense :)
  17. Mostly just a few plugins. However, EE comes...

    Mostly just a few plugins.
    However, EE comes with a support contract, meaning you can ask these questions directly to Pentaho and get complete answers.



    Yes! You can use the CE version to...
  18. You could use stream lookup to find out what the...

    You could use stream lookup to find out what the Right Status is based on the long status. This will give you the advantage that you can add new Long Status values when you want to by modifying the...
  19. Have a look at the Unique rows steps, and at the...

    Have a look at the Unique rows steps, and at the Group By steps.

    Between the two steps, you should be able to get the output you are looking for.
    If you want help, you should be prepared to show...
  20. What about setting the locale in a Spoon.bat (eg....

    What about setting the locale in a Spoon.bat (eg. spoon-us.bat ) that would then convince it that it was running on a en_US based workstation?

    Add parameters:
    -Duser.language=en -Duser.country=US...
  21. The only way to pull the time from the DB server...

    The only way to pull the time from the DB server would be to use a table input with something along the lines of:

    SELECT GETDATE() as CurrentTime

    However, if your DB server and your AppServer...
  22. Replies
    4
    Views
    103

    Something like...

    Something like http://wiki.pentaho.com/display/EAI/Add+value+fields+changing+sequence
  23. Replies
    2
    Views
    77

    I can't promise that this will work (it's a step...

    I can't promise that this will work (it's a step I've never used), but perhaps try the Transformation Executor step
    You would include it in the Transformation after the SQS reader.
  24. Enable what option? If you want to make sure...

    Enable what option?

    If you want to make sure that C does not get data from A, then make sure that B has a "Get Rows from Results"
  25. Replies
    8
    Views
    305

    That has nothing to do with the exit codes.

    That has nothing to do with the exit codes.
  26. Replies
    8
    Views
    305

    Pan & Kitchen both call spoon, so if you fix the...

    Pan & Kitchen both call spoon, so if you fix the spoon.bat, then it should fix it for them too.
  27. I can't understand what you are asking for help...

    I can't understand what you are asking for help doing...

    You talk about merging Rows, but then show data that only has one row.
    You seem to be doing something with merging columns, but then your...
  28. I'm not clear in what you are hypothesizing, but...

    I'm not clear in what you are hypothesizing, but if your theory is that "Get Rows From Result" removes the row from results, then yes, you are correct.

    You cannot carry the results from A through...
  29. Have you read the documentation on the Single...

    Have you read the documentation on the Single Threader and the Transformation Executor steps?

    The docs clearly say:
    Single Threader step uses the single threaded engine to execute the sub...
  30. Replies
    4
    Views
    122

    Connection refused means that your server (or a...

    Connection refused means that your server (or a firewall in between) won't allow you to connect from the location you are connecting from.
  31. Transformation Properties, Miscellaneous tab. ...

    Transformation Properties, Miscellaneous tab. Checkbox: "Make the transformation Database Transactional"
  32. Replies
    3
    Views
    114

    Since that's an EE step, wouldn't it make sense...

    Since that's an EE step, wouldn't it make sense to use your support contract to get the information from Pentaho rather than asking other users?
  33. Try turning the Transformation Transactional on....

    Try turning the Transformation Transactional on.
    In theory, this should make all connections to the DB in one transaction. Since they are within a transaction, the Page (or Table) Locks will allow...
  34. Replies
    3
    Views
    151

    Perhaps the JSON Input...

    Perhaps the JSON Input step?
  35. Replies
    5
    Views
    159

    My turn to apologise - I was reading your request...

    My turn to apologise - I was reading your request as looking for info on how to import the data from such a log file.

    You might want to use the "Get Step Statistics" step, which will tell you...
  36. When I put your previous code into a KTR file,...

    When I put your previous code into a KTR file, and open it in PDI 5.4 it doesn't show the hop.
    I have not had any issues with uploading files to this forum.

    Honestly, I don't know. I don't have...
  37. Replies
    3
    Views
    109

    I'm assuming that you have something along the...

    I'm assuming that you have something along the lines of:

    Master Job
    - Start
    - Transformation (Generate List of Files)
    - Job (Process Files; Run for each row)
    - - Start
    - - Transform (Check to...
  38. When I pasted your transform into a file (it...

    When I pasted your transform into a file (it would be so much easier if you had attached the KTR to the post), it shows that there is no hop between Get Individual Pairs and Cassandra Input. This...
  39. Replies
    5
    Views
    159

    What? No you wouldn't! Read each line from...

    What?
    No you wouldn't!

    Read each line from the log file with the filename included. You could use Fixed length to delineate the initial columns.
    You would now have:

    sample.log|10/25/2013...
  40. Replies
    2
    Views
    915

    Wrap your Repository connection with C3P0. ...

    Wrap your Repository connection with C3P0.

    Mysql doesn't exactly play nice with long connections, and C3P0 will help with that.
  41. All I can suggest at this point is for you to...

    All I can suggest at this point is for you to post your transform.
    We can do more detailed diagnosis with the transform in hand.
  42. That's my first guess, based on the fact that you...

    That's my first guess, based on the fact that you said you're upgrading, and http://forums.pentaho.com/showthread.php?188224-MS-SQL-Repository-Not-Supported

    There might be something else that's...
  43. Try port 465.

    Try port 465.
  44. Upgrade your repository to 5.2 first. Then...

    Upgrade your repository to 5.2 first.
    Then upgrade the repository to 5.3
  45. Which same error? You have provided several...

    Which same error?
    You have provided several error messages.

    Post your transform (the actual KTR files, not a screenshot!). That is the easiest way to diagnose what is going on.
  46. If you set your template SQL as: SELECT COUNT(*)...

    If you set your template SQL as:
    SELECT COUNT(*) from SYSTABLES

    And then you have a column in your incoming datastream
    SELECT COUNT(*) from ac_mstr
    SELECT COUNT(*) from ac_mstr2
    SELECT...
  47. This is a really old thread. Why not start a new...

    This is a really old thread. Why not start a new thread explaining what you want to accomplish?
  48. In your final screenshot, you have output from...

    In your final screenshot, you have output from Get Individual Pairs coming back as:

    ID1
    792
    792
    792

    You *NEED* to have the exact same number of columns coming out of Get Individual Pairs as...
  49. The error is telling you very clearly that your...

    The error is telling you very clearly that your server is not allowed to go out to the internet to talk to the gmail host you configured, or that the gmail host has declined to accept traffic from...
  50. Replies
    4
    Views
    199

    I honestly haven't seen a Wiki article saying to...

    I honestly haven't seen a Wiki article saying to go to http://yoursevername/kettle/status
    My best guess would be that the Wiki article is for the DIServer, which is different from PDI.

    PDI is a...
Results 1 to 50 of 3103
Page 1 of 63 1 2 3 4