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

Search Forums:

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

Page 1 of 58 1 2 3 4

Search Forums: Search took 0.22 seconds.

  1. Yes, you have to at least create the table first....

    Yes, you have to at least create the table first.
    In your table output, turn off Batch Updates -- you will get better error messages that way. Once you have everything working, you can turn it back...
  2. Replies
    3
    Views
    98

    Why is it a shame? You can run PDI Transforms...

    Why is it a shame?
    You can run PDI Transforms with a batch file, or a PDI Job with a batch file, and if you need to, there is a shell script step to run a batch within PDI.

    But what you've asked...
  3. Replies
    4
    Views
    114

    Powershell and Windows Command Line are not the...

    Powershell and Windows Command Line are not the same thing.

    If you write a bat file to execute your transformations, you can do the "/param:foo=testfilename" method.

    Do you have a clearer...
  4. Replies
    3
    Views
    112

    On Point 3, according to the logs of the Jira,...

    On Point 3, according to the logs of the Jira, they were calling it a regression that was fixed in 5.1, so it should have the old behavior back in 5.1+
  5. kitchen.sh -listrep will just tell you if you...

    kitchen.sh -listrep
    will just tell you if you have in fact defined what the repository is, not whether or not the credentials in the repositories.xml file are valid.

    kitchen.sh...
  6. Try walking me through the steps as listed in...

    Try walking me through the steps as listed in this other thread...

    Also, try it with the Repository # rather than the name... Sometimes things don't work the way we expect them to...
  7. Replies
    4
    Views
    114

    The documentation...

    The documentation says the same...
  8. Post a quick screenshot of your transform (or...

    Post a quick screenshot of your transform (or even better, the transform itself) and we might be able to point out what's going on.

    Also, please be careful with language: Job and Transform are...
  9. If you read the error message, the cause is...

    If you read the error message, the cause is pretty clear - you have your machine in offline mode, meaning that it cannot create any network connections.
  10. Replies
    3
    Views
    126

    The point is that the email client doesn't have...

    The point is that the email client doesn't have to honor the request.
    I have requests from people within my business that have read-requests on. My client has the default action set to IGNORE. So...
  11. Replies
    3
    Views
    126

    Your second link includes the reasons that "Read...

    Your second link includes the reasons that "Read Receipts" are pointless.
  12. So why not use the Access Input step, and a Table...

    So why not use the Access Input step, and a Table Output?
  13. Replies
    1
    Views
    145

    In which version of PDI? For most of the last...

    In which version of PDI?

    For most of the last few PDI versions (like 4+ ), you can set the Use Stream Date field to use a date different than the current time.
  14. Replies
    1
    Views
    165

    Usually this means that you have posted from the...

    Usually this means that you have posted from the same IP address as a spam poster, and the Moderators have not yet had a chance to clear the flags to reveal your post.
  15. Replies
    1
    Views
    146

    Why not use the URLEncoder built into Java,...

    Why not use the URLEncoder built into Java, instead of rolling your own?
  16. Replies
    2
    Views
    131

    Try setting your times to UTC, rather than...

    Try setting your times to UTC, rather than GMT/BST
    Those times will exist, and should resolve to the correct BST time
  17. Replies
    4
    Views
    102

    I went: 1. Data Grid (Input your Source Data)...

    I went:
    1. Data Grid (Input your Source Data)
    2. Add Sequence
    3. Row Normalizer (Col2, Col3, Col4 -> Out, TypeField = ColNo)
    4. Filter Rows (Out contains Col1) True -> 5 ; False -> 10
    5. Clone...
  18. Replies
    4
    Views
    102

    Should your example read as below? col1...

    Should your example read as below?


    col1
    col2
    col3
    col4


    aa
  19. Replies
    2
    Views
    129

    More than likely, you are setting the variables...

    More than likely, you are setting the variables with one transformation in a job, and use them in another.

    When you run the transformation in Spoon for testing, the variables haven't been set.
    ...
  20. Sounds like:...

    Sounds like:
    http://jira.pentaho.com/browse/BISERVER-11918

    Which is fixed in BIServer 5.3... So upgrade.
  21. Replies
    2
    Views
    112

    Please make sure to read the logs before you post...

    Please make sure to read the logs before you post them.
    The recommended solution is listed in the error log.

    Make sure the DB2 JDBC Driver is installed in the Pentaho Install Directory, in the...
  22. This line tells you pretty clearly that it didn't...

    This line tells you pretty clearly that it didn't like the MDX that you sent to Mondrian.
    So, take that MDX, and try to run it NOT in the CDA.
  23. Wait... Your dashboard calls for a new thread on...

    Wait... Your dashboard calls for a new thread on the forums page each time its run?!
  24. 1. Filter Rows: If A < B (True, Send to #3 ;...

    1. Filter Rows: If A < B (True, Send to #3 ; False, Send to #2)
    2. Select Values (Swap Columns A and B and Rename them to the appropriate)
    3. Sort Rows A Asc, B Asc
    4. Unique Rows

    Done!
  25. Replies
    3
    Views
    126

    In the other columns (same place as you set the...

    In the other columns (same place as you set the format) are columns called "Decimal" and "Group". These would need to be set as "," and "." respectively for your number format. The format string...
  26. It might have something to do with the parallel...

    It might have something to do with the parallel output of Simple Evaluation.

    Try rebuilding it (Turn off the parallel at Simple Evaluation) and put a dummy step between the simple eval and the...
  27. Replies
    3
    Views
    166

    Variables are a specific concept in PDI. How are...

    Variables are a specific concept in PDI.
    How are you intending to use the field values?

    Perhaps if you explain what you are trying to do, rather than how you are trying to achieve it...
  28. There is an option on PDI steps: "Number of...

    There is an option on PDI steps: "Number of copies to start" that you can change to change how many steps are running in parallel **FOR EACH STEP**

    PDI works best if you keep the number of copies...
  29. Bhanu, Vince is talking about the Modified...

    Bhanu, Vince is talking about the Modified Javascript Values step, not the User Defined Java Expression.

    Vince - Bhanu is talking about a different step, which uses Java expressions, not...
  30. Tomcat is complaining about not being able to...

    Tomcat is complaining about not being able to allocate enough memory.
    The maximum amount of memory that you can allocate in Windows 32 bit is 1500 MB. (give or take a few)

    If there is not enough...
  31. Did you change the MX parameters?

    Did you change the MX parameters?
  32. Why do things the hard way? Use the Microsoft...

    Why do things the hard way?
    Use the Microsoft Excel Writer step, and set the values to protect the sheet.
  33. Replies
    1
    Views
    118

    Could be. Your PROD server might have a...

    Could be. Your PROD server might have a different configuration that requires a password check, where DEV does not.

    Could be.

    Could also be that you're using a dynamic password setting on your...
  34. Replies
    1
    Views
    122

    I think few people use DB repository - there are...

    I think few people use DB repository - there are quite a few limitations with it.
    That said, try user admin password admin
  35. Replies
    4
    Views
    275

    Have you looked in the samples directory? Most...

    Have you looked in the samples directory? Most of these things are in there.
  36. Replies
    4
    Views
    718

    Remember: A Date is a Date is a Date. Formatting...

    Remember: A Date is a Date is a Date. Formatting doesn't change it.

    The common answer on Google is "Make sure your MySQL connector is the same version as your MySQL DB"
  37. Have a good look at the "Get Variables" step.

    Have a good look at the "Get Variables" step.
  38. Reading the requirements, I would actually...

    Reading the requirements, I would actually suggest you restructure your flow.

    Source -> Merge Rows -> Synchronize after Merge
    Destination -^
  39. Replies
    2
    Views
    217

    That appears to be an Oracle Configuration issue:...

    That appears to be an Oracle Configuration issue:
    https://community.oracle.com/thread/2547624
  40. Replies
    4
    Views
    260

    With Windows, when you configure Proxy settings...

    With Windows, when you configure Proxy settings in IE, you are configuring it *FOR ALL APPLICATIONS*

    In the Advanced settings for the Proxy, add your SQL server to the Exceptions list, and then...
  41. Why use Modified JavaScript Value? There's a...

    Why use Modified JavaScript Value?
    There's a Replace in String step, a String Operations step, and a Null If step. One of those will accomplish what you are looking for.
  42. I did a quick test: Generate Rows (10) ->...

    I did a quick test:
    Generate Rows (10) -> Modified Javascript Value

    The Modified Javascript Value step has your exact script.
    My output shows two elements in each row.

    So can you elaborate on...
  43. Replies
    2
    Views
    145

    Why are you doing this with a Modified JavaScript...

    Why are you doing this with a Modified JavaScript Values step?
    It's not showing that it works in one directory and not in another directory.
  44. Or use fixed fields :P

    Or use fixed fields :P
  45. Replies
    3
    Views
    125

    Have a look in your PDI Directory:...

    Have a look in your PDI Directory:
    %PDI%/samples/transformations/Merge Join - Join 2 sorted data sets.ktr
    %PDI%/samples/transformations/Merge rows - mergs 2 streams of data and add a flag.ktr...
  46. It's ugly, but you could do: Text Input -> Add...

    It's ugly, but you could do:
    Text Input -> Add Constant -> Text Output

    Configure the Text Input to bring in 1 column as String(Max)
    Add your new column, and then write out the new file.
  47. Replies
    4
    Views
    182

    Are one of your columns strings? Could that...

    Are one of your columns strings?
    Could that string contain " ?
    If so, the Bulk Loader may be looking for the other half of a string, and waiting forever, since it's not actually there.
  48. You might peek at Sparkl...

    You might peek at Sparkl http://community.pentaho.com/projects/sparkl/
    I have NO idea if it would meet your needs, but it's a place to start.
  49. How do you know that it doesn't insert any rows?...

    How do you know that it doesn't insert any rows?
    How much have you looked at the execution logs?

    Table Output *IS* the step you are looking for.
  50. ? replacement should take care of quoting for...

    ? replacement should take care of quoting for you, as long as the types are defined correctly.

    Please note that Execute SQL isn't intended for SELECT statements - that is what Table Input is for....
Results 1 to 50 of 2878
Page 1 of 58 1 2 3 4