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.16 seconds.

  1. Replies
    8
    Views
    86

    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...
  2. Replies
    8
    Views
    86

    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...
  3. Replies
    1
    Views
    48

    I usually recommend people start by reviewing the...

    I usually recommend people start by reviewing the step documentation.
    Specifically, in your case: This page
  4. 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...
  5. Also, have a look in the "Run All" in the samples...

    Also, have a look in the "Run All" in the samples directory.
  6. Replies
    4
    Views
    124

    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...
  7. 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/ )
  8. Thread: Lead/lag series

    by gutlez
    Replies
    3
    Views
    91

    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!
  9. 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)
  10. 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...
  11. Replies
    1
    Views
    76

    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...
  12. 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.
  13. 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.
  14. Replies
    2
    Views
    120

    Well, tell us about your situation, not just "It...

    Well, tell us about your situation, not just "It doesn't work" or "it seems a problem with..."

    There should be some sort of error message that gets displayed....

    Note: The forum will help those...
  15. Replies
    2
    Views
    97

    Try a wildcard (RegEx) of...

    Try a wildcard (RegEx) of productiondb_out_f_monthly_.*\.csv
  16. Thread: automatic Job

    by gutlez
    Replies
    13
    Views
    341

    Ok, so that shows that there are no directories...

    Ok, so that shows that there are no directories in the "SRG - MyFactory" directory.
    So what about the "BS - MyFactory" directory?

    Are you ABSOLUTELY sure that you are using the same repository...
  17. Replies
    11
    Views
    640

    You need to change the DB driver from MS SQL...

    You need to change the DB driver from MS SQL (JDBC) to MS SQL (JDBC-Native)
  18. Replies
    11
    Views
    640

    Paul, When they mention "Native" driver, they...

    Paul,

    When they mention "Native" driver, they mean the MS Driver, not the jTDS driver.
    Link works (at least today)

    It is not Open Source, so it cannot be distributed with Pentaho. It is...
  19. Put another select values step directly after...

    Put another select values step directly after your Table Input.
    On the MetaData tab, change the "Format" for the offending column to "000000000.000" (Leave the decimal as "," and the group as ".")
    ...
  20. Thread: automatic Job

    by gutlez
    Replies
    13
    Views
    341

    Based on the second half of your response, the...

    Based on the second half of your response, the questions about the JARs for the Repository's DB are now irrelevant. :D

    Note that your "CMP - MyFactory" directory cannot be found in the...
  21. Thread: automatic Job

    by gutlez
    Replies
    13
    Views
    341

    What version of PDI are you using? What DB is...

    What version of PDI are you using?
    What DB is the repository held in?
    Do you have the appropriate JAR files for connecting to the repository's DB in the appropriate lib directory?

    Also, can you...
  22. Thread: automatic Job

    by gutlez
    Replies
    13
    Views
    341

    Post the output of the first step from the other...

    Post the output of the first step from the other post:

    kitchen /listrep
  23. Assuming that your KTR is the one in the sample,...

    Assuming that your KTR is the one in the sample, what happens if you replace the generated row with:

    select 1 as num, TO_DATE(null, 'YYYY-MM-DD')


    Also...

    If you are selected a column that...
  24. The Reporting Output Step will be run once for...

    The Reporting Output Step will be run once for each row sent to it - it is not intended to supply the report with the data that the report will need.

    Could you post the transformation, and we can...
  25. If you require urgent assistance with an issue, I...

    If you require urgent assistance with an issue, I would recommend you contact Pentaho ( http://www.pentaho.com/services ) and get a support contract.
  26. Replies
    9
    Views
    237

    Try the Mail Job Entry...

    Try the Mail Job Entry
  27. Thread: automatic Job

    by gutlez
    Replies
    13
    Views
    341

    You have spaces in your names... Did you...

    You have spaces in your names... Did you remember to enclose them in quotes?

    kitchen.bat /rep:Kettle /job:PAs aelter als 2 Wochen /dir:/CMP - MyFactory/MyFactory/ /user:admin /pass:Passwort1
    vs...
  28. I don't know that there's an easy way to do that,...

    I don't know that there's an easy way to do that, short of joining on just the phone number, and then filtering out the records that don't meet your time window. You could do a calculation...
  29. Replies
    5
    Views
    250

    Usual answer on this: Start back at the...

    Usual answer on this:
    Start back at the beginning to figure out what's going on.

    Excel Input -> Text File Output. If that runs, then add the next step from your transform, and repeat.

    Note...
  30. Replies
    2
    Views
    167

    Each Job Entry has the option of allowing you to...

    Each Job Entry has the option of allowing you to execute the next step based on success or on fail.
    You can use this functionality to send mail on steps that fail to execute completely.

    You also...
  31. Replies
    4
    Views
    585

    You can configure Firefox to pass NTLM...

    You can configure Firefox to pass NTLM information to the server. (See here)
    I'm not sure how you configure the server to understand it.

    Short answer: I can get you one step closer, but not all...
  32. Replies
    10
    Views
    224

    Two ways I can think of: 1) Your calling Job...

    Two ways I can think of:

    1) Your calling Job would specify the carte server as an "Execute on remote server" for an additional job that would collect the file, and process it.
    2) Your calling Job...
  33. Replies
    10
    Views
    224

    Another option is to have a Carte server running...

    Another option is to have a Carte server running "near" the database, which will grab that text file, and process it into the DB... Thus your network roundtrip times are a lot shorter.
  34. Replies
    10
    Views
    224

    After you swap the Insert / Update with an Update...

    After you swap the Insert / Update with an Update step, you still have to select the "Don't perform lookup" box, or it will still do a lookup first. Don't ask - I don't know why it does that.
  35. Replies
    10
    Views
    224

    You might be able to squeeze a little bit more...

    You might be able to squeeze a little bit more out of it by using an Update step, and disabling the lookup. But that shouldn't improve the speed much. Do you have cache turned on on the Combination...
  36. Have a good look at:...

    Have a good look at:
    http://wiki.pentaho.com/display/EAI/Dimension+Lookup-Update
  37. Replies
    1
    Views
    109

    Something like:...

    Something like:...
  38. Replies
    1
    Views
    112

    You'll get a better response if you either fill...

    You'll get a better response if you either fill out the form at http://www.pentaho.com/contact
    or call one of the numbers found on that page.
  39. You could define error handling for the step that...

    You could define error handling for the step that is having issues, and then redirect the "error" rows to a text file to review.
  40. Thread: Update Step

    by gutlez
    Replies
    2
    Views
    117

    Are you using the Update step, or the Insert /...

    Are you using the Update step, or the Insert / Update step?

    Insert / Update has to do a query first to determine if the row exists, and then do an Insert if it doesn't.
  41. Replies
    4
    Views
    240

    But if you have to edit the entry anyway to...

    But if you have to edit the entry anyway to update the filename that you are calling, then you can edit the log file at the same time.
  42. Replies
    5
    Views
    173

    Usual answer - make it work in Spoon first. Then...

    Usual answer - make it work in Spoon first. Then get it to work in API.
  43. "Group By...

    "Group By", OrderNo, Concatenate strings with , ?
  44. Replies
    2
    Views
    112

    So in theory, you should be doing at most 22M...

    So in theory, you should be doing at most 22M roundtrips to the DB... (Ouch, but can't be helped much)

    Did you turn on the "Enable Cache" in Database Lookup?
    What is the round-trip time from the...
  45. Walk us through it very slowly... (and maybe even...

    Walk us through it very slowly... (and maybe even post your transform - be sure to clean your DB connection information first!)

    What is your incoming stream?
    What are you trying to accomplish...
  46. Replies
    4
    Views
    240

    I find that ${Internal.Transformation.Name} is...

    I find that ${Internal.Transformation.Name} is not set at the Job level (others claim to see differently). However, ${Internal.Job.Name} is. That however will not help you, since you want the log...
  47. Your generate rows step is generating 10 rows,...

    Your generate rows step is generating 10 rows, not 1.
    So your Execute All Stored Procedures step is being called 10 times, so each of the SP that it calls will be called 10 times...

    So, if that...
  48. Have a look at the Group By...

    Have a look at the Group By steps.
    One of the grouping options is "Concatenate strings separated by , (comma)"
  49. Replies
    16
    Views
    473

    Yes, I used to do it with 3.6 regularly.

    Yes, I used to do it with 3.6 regularly.
  50. Replies
    16
    Views
    473

    Try 3.8 and see if it plays nicer

    Try 3.8 and see if it plays nicer
Results 1 to 50 of 2660
Page 1 of 54 1 2 3 4