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

Search Forums:

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

Page 1 of 59 1 2 3 4

Search Forums: Search took 0.18 seconds.

  1. Took me much too long to figure out why things...

    Took me much too long to figure out why things didn't work...

    I usually don't post solutions, because they don't really help anyone learn, and encourages "Give me teh codez!" type posts.
    See if...
  2. In your example file, you are looking for a file...

    In your example file, you are looking for a file called: C:\Users\hemavathi_j.ITLINFOSYS\Downloads\inputXML.xml
    You should be looking for : ${Internal.Transformation.Filename.Directory}\inputXML.xml...
  3. Replies
    4
    Views
    80

    OK, so show us what you have, and a sample (not...

    OK, so show us what you have, and a sample (not real, just realistic) dataset.
    Walk us through the problem.
  4. Replies
    7
    Views
    92

    Awesome, Thanks!

    Awesome, Thanks!
  5. Replies
    7
    Views
    92

    http://wiki.pentaho.com/display/EAI/Analytic+Query...

    http://wiki.pentaho.com/display/EAI/Analytic+Query

    It's a Wiki, so create an account and update it!
  6. Thread: Data type error

    by gutlez
    Replies
    1
    Views
    39

    You really shouldn't trust that a 5.x transform...

    You really shouldn't trust that a 5.x transform file will run in PDI 3.x

    Comparison: Try opening a DOCX file in MS Word 2.0 and let me know how well it works...
  7. Are you using EE, or are you using CE? You're...

    Are you using EE, or are you using CE?

    You're reading EE documentation...
    If you have EE, you are entitled to support from Pentaho directly.
  8. Please fix your KTR file to be runable on any...

    Please fix your KTR file to be runable on any machine...
    You currently have hardcoded values for the XML file, which name a file completely different than the attached XML.

    Also any time you have...
  9. There's a thread ...

    There's a thread that already answers what is going on...
  10. The ODBC JDBC bridge has been depreciated for...

    The ODBC JDBC bridge has been depreciated for several versions of Java, and was removed in Java8.
    Sage suggests upgrading to Sage100 Pro, as it uses a MSSQL back-end, where you can then use jTDS or...
  11. Perhaps the Output Steps Metrics can help....

    Perhaps the Output Steps Metrics can help.
    However, I think that it only shows # Writes to DB, rather than # Inserts & # Updates.
  12. Cross-Reference:...

    Cross-Reference: http://forums.pentaho.com/showthread.php?187491-PDI-memory-leak-when-job-workflow-is-quot-too-long-quot&p=408653&posted=1#post408653

    cool_runnings : It may be worthwhile asking...
  13. Cross Ref:...

    Cross Ref: http://forums.pentaho.com/showthread.php?187448-Pentaho-Still-has-memory-problems-running-loops

    Bernd - it may be worthwhile asking the Mods to merge the threads for a single discussion.
  14. Replies
    8
    Views
    118

    The first change I would make is to swap the...

    The first change I would make is to swap the Javascript steps for Calculator steps. Javascript step should be considered a last resort step (use it when nothing else works), at least when you're...
  15. Considering the Jira entry reads: Status Open,...

    Considering the Jira entry reads: Status Open, and last modified "05/May/2015", I would have to interpret that as "The bug is still open"

    I personally have not experienced this issue (with -- in...
  16. http://jira.pentaho.com/browse/PDI-9805

    http://jira.pentaho.com/browse/PDI-9805
  17. Replies
    1
    Views
    77

    Yes, you're reading EE documentation. DI...

    Yes, you're reading EE documentation.

    DI Server is an EE feature.
    The embeded H2 DB is installed with either the EE DI Server, or with the CE BA Server.

    You can read, transform, and write to...
  18. Sadakar, I was more indicating to *ADD* an...

    Sadakar,

    I was more indicating to *ADD* an extra row of data, not modify the existing row.
    You solution will fail with multiple "Buy" or "Sell" records in the data set.

    Using the flow layout I...
  19. Sadakar, I think you might have missed the...

    Sadakar,

    I think you might have missed the use-case.
    Add in one more transaction, to show how your data-flow still works:



    10004
    Brokerage Fund
    Buy
  20. Replies
    1
    Views
    95

    Do you have the "Only save used connections"...

    Do you have the "Only save used connections" turned on?

    Tools -> Options
    about 1/2 way down the list: "Only save used connections to XML?"


    If you don't have a shared objects file, I'm not...
  21. Can you show us this scenario?

    Can you show us this scenario?
  22. Are your transforms actually failing, or are they...

    Are your transforms actually failing, or are they just not doing any work?

    It should populate up correctly based on the jobs you posted (but your post isn't actually runnable... make sure you use...
  23. Make sure your transforms send to Abort job entry...

    Make sure your transforms send to Abort job entry when they fail...
    And as always, post a sample set to illustrate the problem.
  24. Replies
    4
    Views
    144

    I'm still not seeing what you're trying to...

    I'm still not seeing what you're trying to accomplish. If it's data outbound to a user, then implementing the PRD libraries makes much more sense (and they can call KTR files as a data-source)

    If...
  25. Replies
    4
    Views
    144

    I see this type of request come up quite...

    I see this type of request come up quite regularly, and I can never understand the use-case.

    Data Integration is for routine data movement (system to system), not really for user-event.
    Could you...
  26. Normalize it to: id type_num type 1 1 CON 1...

    Normalize it to:

    id type_num type
    1 1 CON
    1 2 CON
    1 3 NOC

    and then it should be pretty easy to tell how often each type code is repeated within an id
  27. Replies
    9
    Views
    107

    Don't apologise! Stick around and show us what...

    Don't apologise!
    Stick around and show us what you've been able to do - the fact that you found us, and were willing to ask for help is actually a good thing!

    I was just commenting that the...
  28. Replies
    9
    Views
    107

    If PDI is being assigned in a course, the...

    If PDI is being assigned in a course, the instructor should be one of the first places to ask for support
    I'm not saying that the forum shouldn't be a support channel... just that details like this...
  29. Replies
    9
    Views
    107

    Then I think we'd have to see the files to...

    Then I think we'd have to see the files to understand what is going on.

    There may be some other thing going on, like having enclosures within the string, but the files will make it easiest to...
  30. Replies
    9
    Views
    107

    One of the prompts with the "Get Fields" process...

    One of the prompts with the "Get Fields" process asks how many lines to sample.
    If the longest value of these sampled lines for the field is only 270 characters, then PDI will assume that the field...
  31. I'm trying to remember the steps... CSVTEXT is...

    I'm trying to remember the steps...

    CSVTEXT is part of the magic... Your multiselect is an array, and when you do a ToString on it, you get the object reference, rather than the values in the...
  32. Open the CSV in a text editor. Go to line 13780...

    Open the CSV in a text editor.
    Go to line 13780
    Review the data in that row. You are likely missing a value, or you have missing enclosures that are pushing the data over by one field.
  33. Replies
    14
    Views
    276

    You don't have your grouping set correctly.

    You don't have your grouping set correctly.
  34. Is your need different than in...

    Is your need different than in http://forums.pentaho.com/showthread.php?186816-Create-html-Table-using-javascript
  35. Replies
    5
    Views
    128

    Open an command window, and try: help exit

    Open an command window, and try:

    help exit
  36. Try doing it in a Job SQL Step instead of a...

    Try doing it in a Job SQL Step instead of a Transform.

    Transforms are intended for things where you will be executing once per row... and you wouldn't want to execute the trigger create once per...
  37. Common answer is usually to do something similar...

    Common answer is usually to do something similar to what Vinodkumar suggested, but use a key parameter value that is in the correct type...

    Then in your overall query:
    Select desired,columns,etc...
  38. Replies
    11
    Views
    226

    Javascript is a LAST RESORT step. There are...

    Javascript is a LAST RESORT step.
    There are usually other ways in PDI to do the same thing.
  39. Replies
    5
    Views
    128

    make sure your batch file ends with a non-zero...

    make sure your batch file ends with a non-zero exit code if the transform fails.
  40. My understanding is that ALL the connections open...

    My understanding is that ALL the connections open at the start, and then close as each step completes, so you need to have the connection max high enough to support all the steps in your transform.
  41. If your DB Lookup is looking for ACTION_KEY, then...

    If your DB Lookup is looking for ACTION_KEY, then it may be hitting that step before the Insert/Update is committed, therefore the lookup will fail, and will provide a null as the response.

    So...
  42. According to the error message, the cause is that...

    According to the error message, the cause is that you have a null value in your 'ACTION_KEY' column, and the DB is set up with that column to disallow nulls. Review your source data, and make sure...
  43. Using the "schedule" option in the Start Job...

    Using the "schedule" option in the Start Job Entry is only truly functional in Enterprise Edition, specifically in the Pentaho Data Integration Server.

    If you are not using DIServer, I would not...
  44. My guess is that you're still missing a JAR in...

    My guess is that you're still missing a JAR in the classpath.


    Looking at your link, it looks like the files are not named well.

    "No dependencies" means to me that the download doesn't include...
  45. Have a good look at C3P0...

    Have a good look at C3P0.
    I'm pretty sure you can specify the maximum number of connections in the pool.
  46. You are mistranslating what that is saying. That...

    You are mistranslating what that is saying.
    That is not enabling Bulk Loading, but rather to allow you to change multiple hops at the same time.
  47. Thought: Don't do it. Use cron on the Linux...

    Thought: Don't do it.

    Use cron on the Linux box to call kitchen to run the job directly out of the repository. There are a bunch of examples around the forum on how to do this.
  48. Thread: add new field

    by gutlez
    Replies
    1
    Views
    93

    You are not likely to receive a lot of help if...

    You are not likely to receive a lot of help if you don't show that you have tried to figure out the answer yourself.
    There are several steps that can do parts of what you are suggesting, including...
  49. I know this isn't a good solution, but try Java 7

    I know this isn't a good solution, but try Java 7
  50. Replies
    14
    Views
    245

    Please try the value suggested by marabu:...

    Please try the value suggested by marabu:
    yyyy-MM-dd'T'HH:mm:ss.SSSZ
Results 1 to 50 of 2947
Page 1 of 59 1 2 3 4