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

Search Forums:

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

Page 1 of 57 1 2 3 4

Search Forums: Search took 0.20 seconds.

  1. Using a Data Grid feeding the string you supplied...

    Using a Data Grid feeding the string you supplied into a Select Values, it wanted the format: yyyy-MM-dd'T'HH:mm:ss.SSSz
  2. Replies
    5
    Views
    101

    Why re-invent the wheel? Also, you will decrease...

    Why re-invent the wheel?
    Also, you will decrease the maintainability of the script, and decrease your performance.

    Modified Javascript Value should be treated as a **LAST** resort, not a primary...
  3. Since the format that you're using is telling it...

    Since the format that you're using is telling it to use local time, and your time jumped at 2AM to 3AM, then 02:00:55 doesn't exist.
    You could try a format of: [yyyy-MM-dd'T'HH:mm:ss.Sz]
  4. 1) Basic SQL issue. You MUST enclose strings in...

    1) Basic SQL issue.
    You MUST enclose strings in '
    from: and lower(comm_val) = email@utr.org
    to: and lower(comm_val) = 'email@utr.org'

    2) Execute SQL Commands is not the step you are looking...
  5. Replies
    5
    Views
    101

    Why not use a Select Values (Meta-Data tab) step,...

    Why not use a Select Values (Meta-Data tab) step, converting from String to Date, and use an Error Handling hop to handle it?
  6. Think of having two parallel streams... "Row...

    Think of having two parallel streams... "Row Results" and "File Results"

    Copy Files to results adds rows to the "File Results" stream.
    Execute for every input row runs the job for each entry in...
  7. Replies
    6
    Views
    113

    Maybe it has something to do with the fact that...

    Maybe it has something to do with the fact that you're trying to put 20 columns worth of data into 9 fields?

    An Array length error shouldn't be a problem that can be solved by changing the file...
  8. Replies
    6
    Views
    113

    Your screenshot cannot be read...

    Your screenshot cannot be read...
  9. Why create another thread?...

    Why create another thread?
    http://forums.pentaho.com/showthread.php?182565-Migration-from-DTS-to-PDI
  10. Remember: Update step still does a lookup first....

    Remember: Update step still does a lookup first.
    So without an index, if you are looking up Ticket_ID, it will do a full table-scan to figure out the RowID first.
    Short answer: YES, put an Index...
  11. Replies
    3
    Views
    223

    If it doesn't find any files (for any reason), it...

    If it doesn't find any files (for any reason), it will still say success and move on to the send email, with no file in the results.
  12. Try changing your logic a little bit... Wrap it...

    Try changing your logic a little bit... Wrap it in a job.
    Replace the Table Output from existing Transform with a Serialize to File
    New Transform follows it with a "De-serialize from File" ->...
  13. You might be able to do a select max(Ticket_ID)...

    You might be able to do a select max(Ticket_ID) from DestTable early in the process, and then filter rows so that any Source.Ticket_ID > Destination.Max(Ticket_ID) goes to an Insert Step, and and...
  14. Replies
    3
    Views
    120

    Maybe your office server doesn't support SSL...

    Maybe your office server doesn't support SSL POP3...
    Try it with SSL off and the port as 110
  15. Replies
    3
    Views
    120

    Mostly likely cause is your Proxy server.

    Mostly likely cause is your Proxy server.
  16. Do you know the name of your temp table in...

    Do you know the name of your temp table in advance?
    If so, use the Table Input step

    Does your Stored Proc return a dataset?
    If so, I seem to recall being able to use "Call" statements in the...
  17. Replies
    5
    Views
    286

    Which version of Windows? Which version of Java?

    Which version of Windows?
    Which version of Java?
  18. Looks like you can. Your lines look right, but...

    Looks like you can.

    Your lines look right, but you'll need to run kitchen with something like:

    kitchen.sh /path/to/prod/jndi -file...
  19. Yes, it is. and it's documented that way.

    Yes, it is. and it's documented that way.
  20. Replies
    15
    Views
    254

    Have a look at...

    Have a look at %KETTLE_HOME%\data-integration\samples\transformations\XML Join - Create a multilayer XML file.ktr


    I think the answer to your question (though I'm not fully understanding it) is...
  21. Replies
    15
    Views
    254

    So... could you not sort by Product Line, and...

    So... could you not sort by Product Line, and then use a Group By step to count the distinct values of Item giving you a set of rows that look like:

    Product Line | Number of Items
    1 | 16
    2 | 5...
  22. Replies
    15
    Views
    254

    Not that I know of. But be sure to also look...

    Not that I know of.

    But be sure to also look at:
    http://type-exit.org/adventures-with-open-source-bi/2010/06/squeezing-the-most-out-of-the-javascript-step-in-pentaho-kettle/

    Maybe try walking...
  23. Replies
    15
    Views
    254

    But that XML wouldn't meet the row requirements...

    But that XML wouldn't meet the row requirements for a standard row would it?

    Remember that all outgoing rows from a step need to have the same layout.
    Are you trying to do something that could be...
  24. Replies
    15
    Views
    254

    What did you want it to do?

    What did you want it to do?
  25. Is that the whole script? It seems to be...

    Is that the whole script?
    It seems to be suggesting that the error is on line 239.
  26. Next suggestion: Change table_name variable to...

    Next suggestion: Change table_name variable to something else. There seems to be an internal variable that uses the same name that it won't let you overwrite.
  27. First thing I would suggest: Turn OFF Lazy...

    First thing I would suggest: Turn OFF Lazy conversion in the CSV Input step. That has a very specific purpose, and will cause you a bunch of problems if you leave it on.
  28. In the top corner of this page, you will find the...

    In the top corner of this page, you will find the contact information for Pentaho.
    From there, you can order a support contract, and there will be turn-around times included in the support contract....
  29. Try: homestead_exemption_flag_1.equals("Y") ...

    Try:
    homestead_exemption_flag_1.equals("Y")

    I'm not confident that you can do "homestead_exemption_flag_".concat(i) and still refer to the column variable.
  30. Javascript seems to have followed the practice of...

    Javascript seems to have followed the practice of Java.
    No two strings are the same pointer.

    Try:
    homestead_exemption_flag_1.equals("Y")

    Also remember that:...
  31. My bet is that the length of the trim of the...

    My bet is that the length of the trim of the string "homestead_exemption_flag_1" will always > 0
  32. This is part of why you were advised to use Table...

    This is part of why you were advised to use Table Output -- that's what it's designed to do: INSERT INTO dbo.product_type_temp_ravi (columns) VALUES (?, ?, ?, ?)
  33. If you are turning off Identity / PK checking,...

    If you are turning off Identity / PK checking, then you can't be sure that you're not going to insert an additional row within one step.
    You will need to build in checks for yourself that the row...
  34. Replies
    1
    Views
    83

    Assuming this is a transform, you could change...

    Assuming this is a transform, you could change the "Number of Copies" on B to a >1 value. Make sure that the hop from A to B is set to distribute rather than copy.

    However you do run the risk of...
  35. Replies
    5
    Views
    120

    Apparently I can't count today :P And this...

    Apparently I can't count today :P


    And this line will need to be 5
  36. According to your screenshot, it's doing a...

    According to your screenshot, it's doing a select, not an Insert.


    Use the correct steps, and life will be a lot easier. The step you are looking for is Table Output, but you will need to define...
  37. Replies
    4
    Views
    156

    Change your excel input to not read them as...

    Change your excel input to not read them as Integers but as strings. In the format column, put in "#" (without the quotes)
    This will leave blanks as blanks, 12 will stay as 12, but 3 will not...
  38. Replies
    5
    Views
    120

    It's because PDI makes the assumption that...

    It's because PDI makes the assumption that headers are at the top of the file.

    Delete the top three lines of your file (just for design... TRUST me here)
    Now use Text File Input as you have been...
  39. Turn the Proxy off, and then make sure that the...

    Turn the Proxy off, and then make sure that the IP settings of the SQL server is on.
    Proxy servers complicate things and make it a lot harder to figure out what is going on.

    Why it works with PRD...
  40. Try File -> Open URL I know that doesn't make...

    Try File -> Open URL
    I know that doesn't make sense, but it should allow you to navigate to your KTR file and open it.
  41. I would expect not. Dzmitry missed the comment...

    I would expect not. Dzmitry missed the comment about being on PDI 4.1, which didn't include a spoondebug.bat.

    Can can create one by copying spoon.bat to spoondebug.bat and changing a line near...
  42. Or just fix it in the Format field later.

    Or just fix it in the Format field later.
  43. Please make sure to read the errors. I'm...

    Please make sure to read the errors.

    I'm betting that when you run the transformation against the slave server yourself, you aren't running it as user1, but rather as some other user.
    the...
  44. @Ravinder1483 ... Did you try the steps from...

    @Ravinder1483 ... Did you try the steps from here: http://forums.pentaho.com/showthread.php?180542-MS-SQL-Database-Connection-Malformed-Reply&p=398804#post398804
  45. If you have a ktr file, try just Open File. If...

    If you have a ktr file, try just Open File.

    If you have an XML that has multiple KTRs inside it, then use the Import XML
  46. If your "Yesterday" a parameter to the report?...

    If your "Yesterday" a parameter to the report?
    If so, there's a thread around here about having to overload the parameter, because parameters are scheduled with a defined string.
  47. Replies
    7
    Views
    302

    Your other option to stop getting this error is...

    Your other option to stop getting this error is to stop using a Proxy server.
  48. It's already in your error:

    It's already in your error:
  49. Wow... I haven't seen 3.2 in a LONG LONG time. ...

    Wow... I haven't seen 3.2 in a LONG LONG time.

    The error in the message is saying that on Line 24 of your script, you are missing a (
    What more information are you looking for?
  50. Thread: Exeute sql step

    by gutlez
    Replies
    7
    Views
    174

    You're not being particularly clear here. You...

    You're not being particularly clear here.
    You also don't indicate if that solved your issue.
Results 1 to 50 of 2827
Page 1 of 57 1 2 3 4