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

Search Forums:

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

Page 1 of 51 1 2 3 4

Search Forums: Search took 0.21 seconds.

  1. Honestly, your Tomcat should be supplying a JNDI,...

    Honestly, your Tomcat should be supplying a JNDI, rather than using simple-jndi.
  2. PDF supports having Hyperlinks in it, so Pentaho...

    PDF supports having Hyperlinks in it, so Pentaho puts the links in.

    Since you don't want the links, you could wrap your Hyperlink function with an IF statement to check the output type.

    If it...
  3. For ease of understanding, you *COULD* (note, I'm...

    For ease of understanding, you *COULD* (note, I'm not saying SHOULD...) use a switch case for pricing_quote and redirect to three select values steps. One that copies discount_line ->...
  4. Lal is close... If I remember correctly,...

    Lal is close...

    If I remember correctly, Oracle doesn't let you access datetimes directly - it converts them to Strings (Remember: "August 29, 2014 9:15 AM PST" is a string, not a datetime)
  5. Replies
    5
    Views
    110

    That's what I'm suggesting :D

    That's what I'm suggesting :D
  6. Replies
    5
    Views
    128

    Java time is only resolved to milliseconds....

    Java time is only resolved to milliseconds.
    There's not a lot out there that can measure microseconds accurately.

    You could TRY getting Oracle to change the Java standard to support microseconds,...
  7. yes. Execute SQL row script....

    yes.
    Execute SQL row script.
    http://wiki.pentaho.com/display/EAI/Execute+row+SQL+script
  8. Replies
    5
    Views
    128

    What are the other 4 digits for? millisecond =...

    What are the other 4 digits for?
    millisecond = 1/1000th of a second, so there should only be 2012-01-19 15:10:02.123
    with .123 it works.

    so... What are the other 4 digits?
  9. Have a peek at the "Execute Row SQL script" step.

    Have a peek at the "Execute Row SQL script" step.
  10. Replies
    5
    Views
    128

    Try adding .S to the end (ie. yyyy-mm-dd...

    Try adding .S to the end (ie. yyyy-mm-dd hh:mm:ss.SSS)
    http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html
  11. Actually, it more likely means that people found...

    Actually, it more likely means that people found the other posts on the forum that state clearly that the code is on Github

    https://github.com/pentaho
  12. Usual practice with CE is to put the files into...

    Usual practice with CE is to put the files into place on your production system using Version Control (git, svn, etc) and schedule the job/transform using the native OS tools (cron, Windows Scheduled...
  13. Replies
    5
    Views
    110

    Most SQL Server variants are supported by the...

    Most SQL Server variants are supported by the jTDS Driver. Anything else can be accessed with MS's version. They use completely different JDBC URLS, so you should be able to work around the issue...
  14. Replies
    3
    Views
    144

    If you have a database, why would you not use the...

    If you have a database, why would you not use the DB lookup, the Dimension lookup, or Combination lookup steps?
  15. Replies
    8
    Views
    119

    Sorry, I meant JARs (MySQL JDBC Jar, etc) which...

    Sorry, I meant JARs (MySQL JDBC Jar, etc) which are stored in <PDI Install Directory>/lib

    Are you using hostnames in the LOGDB configuration, or simple-jndi, or shared configs, or ... ?...
  16. Check all your JARs - you may have a JAR that is...

    Check all your JARs - you may have a JAR that is being called in the Transform that you don't have in PRD.

    That's about all I can come up with off the top of my head. :(
  17. Replies
    8
    Views
    119

    If your PDI versions are the same, and you have...

    If your PDI versions are the same, and you have the same libraries install on each machine (watch out for MySQL, it's odd!), then spoon and pan behave the same.
  18. Replies
    8
    Views
    119

    Always use the same version of PDI. Files...

    Always use the same version of PDI.

    Files created in a lower version of PDI can be run on higher versions of PDI, but files created with a newer version of PDI are not promised to work on older...
  19. As far as I understand, this is not supported as...

    As far as I understand, this is not supported as yet. Install Java 7.


    I would recommend you start with the Pre-configured Install, and get used to Pentaho first, THEN try to customize for your...
  20. The link I posted was for PRD 5.1 PDI is at a...

    The link I posted was for PRD 5.1
    PDI is at a similar link.

    PRD 3.7.0 is *NOT* the latest.
  21. Have a look a the Transformation Executor and Job...

    Have a look a the Transformation Executor and Job Executor steps... But I'm still having a hard time understanding your use case.
  22. Replies
    2
    Views
    75

    Have a look at the Clone Rows step. It's in...

    Have a look at the Clone Rows step.

    It's in the Utility folder.
  23. Then you want to have PRD execute the transform,...

    Then you want to have PRD execute the transform, and only feed 1 row to the Pentaho Reporting File Output step.
    You will have no way to see the Rows / second of the transform that PRD executes.
    ...
  24. This is not 100% accurate, but it will do for...

    This is not 100% accurate, but it will do for what you need to understand to solve your current problem.

    Parameters are PDI variables (NOT environment variables) that you can specifically set when...
  25. http://sourceforge.net/projects/pentaho/files/Repo...

    http://sourceforge.net/projects/pentaho/files/Report%20Designer/5.1/
  26. You want 2000 different copies of the report?...

    You want 2000 different copies of the report?
    How long does the report take to run? Decreasing at 2 - 3 records per second means that you are 500 ms / copy of the report... That's pretty darn...
  27. Within PRD, using PDI as a Data Source will...

    Within PRD, using PDI as a Data Source will stream the data into a Report.
    Yes, this is the scenario above.


    Within PDI, calling PRD will run the report for each row of input.

    This allows...
  28. My initial comment would be: Make sure the...

    My initial comment would be:
    Make sure the libraries are all the same version.

    If you create the KTR in PDI 5.1 and try to use PRD 5.0 to execute it, it might not work.

    So...
    What version(s)...
  29. Are you trying to push your data from PDI into...

    Are you trying to push your data from PDI into the report?
    That's not what the Pentaho Reporting File Output is intended to do.

    What I think you want to do:
    Transform
    - Data Grid (Configure...
  30. Ok, so I'm no code expert, but... I would think...

    Ok, so I'm no code expert, but...
    I would think that you could clone the Text File Input step, and make a plugin that never fires the "Input Complete" marker.

    Transformations will continue to run...
  31. Replies
    2
    Views
    71

    A couple of options: 1) Don't set the...

    A couple of options:
    1) Don't set the KETTLE_HOME environment directory
    -or-
    2) Create $KETTLE_HOME/.kettle and run PDI once as a user that can write there. Then allow the users to read this...
  32. I'm going to assume that you are a programmer -...

    I'm going to assume that you are a programmer - this is usually the case when I see people complaining about PDI not doing what they want it to do. In the end, it often comes back to the user not...
  33. Replies
    4
    Views
    133

    Since the issue appears to be in your shared.xml ...

    Since the issue appears to be in your shared.xml

    Try renaming your ${UserHome}/.kettle/shared.xml file to something else (maybe shared.xml.bad ), and restarting spoon.

    Also, make sure that...
  34. Replies
    7
    Views
    177

    MySQL is notorious for timeouts and not really...

    MySQL is notorious for timeouts and not really behaving consistently.

    Being that a commit size of 20 works suggests to me that you are in fact running into timeouts (basically, instead of waiting...
  35. Multiline Calculator Option: New field ...

    Multiline Calculator Option:


    New field Calculation Field A Field B Field C Value type Length Precision Remove Conversion mask Decimal symbol Grouping symbol ...
  36. Replies
    7
    Views
    177

    Is it possible that your MySQL is timing out...

    Is it possible that your MySQL is timing out waiting for the data from HBase?
    Remember that the MySQL step initializes when the transform is first started, and then waits until the data is there to...
  37. So you're doing: Table Input (DWH) -> Table...

    So you're doing:
    Table Input (DWH) -> Table Input (Source) -> Table Output (DWH)

    In the "Table Input (DWH)", you have something like "select max(timestamp) from table"

    Question though... When...
  38. Did you create a partition scheme first?

    Did you create a partition scheme first?
  39. No worries! I have made some really simple...

    No worries!
    I have made some really simple mistakes working with PDI, that other people have had to patiently walk me through too, so I look at it as paying it forward.
  40. Winsock 10061 means connection refused

    Winsock 10061 means connection refused
  41. Switch/Case does not work like a standard case...

    Switch/Case does not work like a standard case statement - any steps after it that do not take input will execute at start-up (as they should!)

    Ranjan - Work through all your logic (Pentaho works...
  42. Replies
    3
    Views
    116

    Personally, at over 1K rows, I'd be looking for a...

    Personally, at over 1K rows, I'd be looking for a DB of some sort.
    Just because your source data is in a flat file, doesn't mean that you can't use a DB.

    You can load the data to a HSQL table in...
  43. Replies
    2
    Views
    106

    Where are you getting "imagem" from? Do you have...

    Where are you getting "imagem" from?
    Do you have Lazy conversion on?
  44. So let's start walking through it VERY slowly. ...

    So let's start walking through it VERY slowly.

    Start with:
    kitchen /listrep
    This should come back and tell you that it knows about Elucidata

    Next try:
    kitchen /rep:Elucidata /user:system...
  45. Replies
    16
    Views
    653

    But not "-XX:MaxPermSize=???m" ? Why not attempt...

    But not "-XX:MaxPermSize=???m" ?
    Why not attempt to increase the Perm size too?
  46. Replies
    16
    Views
    653

    What exactly did you set?

    What exactly did you set?
  47. 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}
    ...
  48. Replies
    16
    Views
    653

    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.
  49. 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...
  50. 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...
Results 1 to 50 of 2548
Page 1 of 51 1 2 3 4