Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 4 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. MS SQLEXPRESS connection using named pipes

    Hello Everyone!

    Something happened to my MS SQL EXPRESS and now it is not registered properly in the system and I cannot access it through IP address. I can access it through named pipes:...
  2. Thank you, marabu! I totally forgot about Lazy...

    Thank you, marabu!

    I totally forgot about Lazy conversion. As far as I remember, there was JIRA ticket to change default settings to uncheck "Lazy conversion"

    Regards,
  3. Thank you, Mick!

    Thank you, Mick!
  4. Cannot open 5.0.1 transformation in 4.2.1

    Hello Everyone,

    I created transformation in PDI 5.0.1 and tried openning it in PDI 4.2.1, but no luck. It is by design?

    Regards,
  5. If field value is null... converting value error

    Hello Everyone,

    I atteched an example of using "If field value is null" utility. The error I receive (while previewing) is
    "Unexpected conversion error while converting value [Value...
  6. Connection to MS SQL Express 2012 - my table does not show up

    Hello Everyone,

    I am connecting to MS SQL Express 2012 using JDBC (Native). In Database connection I specify the database which I would like to connect and test it successfully, however when I...
  7. Replies
    5
    Views
    883

    Thank you, marabu and yacno! marabu was right....

    Thank you, marabu and yacno!

    marabu was right. I did not expect that different centuries are accommodated in a such a way.

    I have not thought about using Calculator to this task. I ended up...
  8. Hi fanner71, Were you able to resolve the...

    Hi fanner71,

    Were you able to resolve the issue? I am having the same problem.

    Regards,
  9. Replies
    0
    Views
    2,131

    JDBC Connection MS SQL Express

    Hello,

    I am trying to set up Database connection in Table output.

    I need to connect to MS SQL Express 2012. I am using MS SQL Server and Native(JDBC) options and I am getting the following...
  10. Replies
    5
    Views
    883

    Thank you, marabu! I looked at example and I...

    Thank you, marabu!

    I looked at example and I do not think it applies to me. My year is in the form "11", there is no way for PDI to know whether it is "1911" or "2011", so I guess I have to...
  11. Replies
    5
    Views
    883

    Padding year

    Hello Everyone,

    I have data in the format "01/17/11" and I would like to convert it to format "01/17/2011". I read date as a string and cut necessary digits. I tried to pad year "11" with "20",...
  12. Thank you, Slawo! Would I be able to do batch...

    Thank you, Slawo!

    Would I be able to do batch processing and constraint error analysis with ODBC or any other drivers?

    In addition, I defined error handling (simply writing to a file) and when...
  13. Check UNIQUE constraint and error analysis

    Hello Everyone,

    I would like Table Output to ignore error due to violation of unique constraint (or maybe ingnore all error due to constraint that exist in the table). I guess the only way to do...
  14. Replies
    2
    Views
    805

    Convert date "Feb 03, 2012" format

    Hello everyone,

    I have a string of the form "Feb 03, 2012". Does anybody know how to covert it to date without Modified Java Script Value.

    Regards,
    Alex
  15. Replies
    2
    Views
    1,994

    Thank you!

    Thank you!
  16. Replies
    2
    Views
    1,994

    Mail java error message

    Hello everyone,

    I am working on reproducing the following error message, but maybe somebody could give me a hint where to look


    ERROR 28-01 04:23:57,016 - Mail - Problem while sending...
  17. Replies
    5
    Views
    4,192

    Cool! It worked. Also worked...

    Cool!

    It worked. Also worked if(AND([NAME]<>""; "Sofa"=[Name]);7;11)

    Thank you, Darrell!

    P.S I still have a feeling that IF should be redefined, otherwise we always have to check for Null...
  18. Replies
    5
    Views
    4,192

    Thank you, darrell.nelson. I tried it and still...

    Thank you, darrell.nelson. I tried it and still got an error. I wonder what is the philosophy behind java choice?

    I filed JIRA, but it was closed, since there is IFNA function, I wonder what this...
  19. Replies
    5
    Views
    4,192

    Null in If formula

    Hello everyone!

    I have following formula if([Name]="Sofa";7;11). Whenever [Name]=null, I am getting an error message. Is this normal behavior? I searched the web for similar issues, but cannot...
  20. Replies
    3
    Views
    7,918

    Thank you, guys! Disabling batch insert helped!

    Thank you, guys!

    Disabling batch insert helped!
  21. Replies
    3
    Views
    7,918

    Data truncation -error

    Hello everyone!

    I am loading data from text file to DB and getting an error "Data truncation" below. Apparently database expect something different from what I am providing. Currently the only way...
  22. Replies
    14
    Views
    2,230

    Do you think it would make sense to check...

    Do you think it would make sense to check enclosure in pair with field separator?
  23. Replies
    14
    Views
    2,230

    Thank you for pointing it out! I did not set...

    Thank you for pointing it out! I did not set limit length to 5, PDI did it by itself. Now everything works.

    You explanation regarding data transport is very helpful! Seems like enclosure is just...
  24. Replies
    14
    Views
    2,230

    Still there is something strange about how PDI...

    Still there is something strange about how PDI handles quotes. I attached another example. In input and output there are no enclosures with quotes, but output gets distorted.
  25. Replies
    14
    Views
    2,230

    Thank you, gutlez! What is SED? So do you...

    Thank you, gutlez!

    What is SED?

    So do you think it is normal behavior of PDI?
  26. Replies
    6
    Views
    2,648

    http://jira.pentaho.com/browse/PDI-7204 Good...

    http://jira.pentaho.com/browse/PDI-7204

    Good to know! ;-)
  27. Replies
    14
    Views
    2,230

    No, the field separator is TAB, so I believe it...

    No, the field separator is TAB, so I believe it is a case for JIRA.

    Now I guess I know what around, I need to remove quotes manually with java script, I just need to figure out the details.


    ...
  28. Replies
    6
    Views
    2,648

    Filed JIRA.

    Filed JIRA.
  29. Replies
    14
    Views
    2,230

    You are absolutely right, gutlez! Thank you! ...

    You are absolutely right, gutlez! Thank you!

    Could you tell me how you troubleshot this issue?

    Do you think I should file jira for this?

    What would you recommend as a work-around? I cannot...
  30. Replies
    6
    Views
    2,648

    Thank you and sorry for late response. I...

    Thank you and sorry for late response.

    I tried to make sure that there are no empty fields (see new attachment), but still getting an error. I will try to file JIRA if nobody else replies.
    ...
  31. Replies
    14
    Views
    2,230

    Extra quotes in output

    Hello everyone!

    In attached transformation (in CombinedSecurityMasterDetailsPDI.txt) half of the records end up enclosed in quotes and half do not. It seems inconsistent. Does anybody have guess...
  32. Replies
    6
    Views
    2,648

    Convert to string and cut substring

    Hello Everyone,

    In the attached example I convert to string column "$Year" and then extract last digit. It looks like conversion to string fails both in CSV input and and Select value step.

    I...
  33. Replies
    9
    Views
    2,516

    Thank you, Matt! No luck with smb either. I...

    Thank you, Matt!

    No luck with smb either. I tried reading about smb, but there is not much around about it. Do you know where I can get more info on smb before I try it again within PDI?
    ...
  34. Replies
    9
    Views
    2,516

    Any other ways to specify network drive so that...

    Any other ways to specify network drive so that PDI would understand?

    Thank you, gutlez!
  35. Replies
    9
    Views
    2,516

    I am not sure... I have job schedule in...

    I am not sure...

    I have job schedule in Windows Scheduler on Win Server 2003. Does Windows Scheduler run as a service?

    So does it make any sense to include mapping command into batch file, if...
  36. Replies
    9
    Views
    2,516

    This is so sad... Does EE offer any alternatives?...

    This is so sad... Does EE offer any alternatives?

    Can I map drive in the command file where I use kitchen? Something like net use x: \\unc\path\path?
  37. Replies
    9
    Views
    2,516

    UNC and Win Server - Help me understand

    Hello everyone,

    It seems like CSV input does not want to understand UNC names. For example \\179.58.88.01\folder1\folder2\

    I googled this issue, but what I found is hard to understand. Is this...
  38. Replies
    4
    Views
    2,445

    Thank you very much, Darrell! I got it to...

    Thank you very much, Darrell!

    I got it to work. I never used "verify" button before, great to know!
  39. Replies
    4
    Views
    2,445

    not a silly question! I checked spam folder. It...

    not a silly question! I checked spam folder. It has nothing.

    Okay, I created gmail.com account
    Username: John.Smith.Test.137
    Password: secretword

    And I attached the transformation. If...
  40. Replies
    4
    Views
    2,445

    Mail transformation step

    Hello everyone,

    I am trying to use mail transformation step. As an output I receive the following (see below), but the e-mail does not arrive.

    I used mail job successfully before and when...
  41. Replies
    4
    Views
    1,090

    Thank you, gutlez! I am looking at Event...

    Thank you, gutlez!

    I am looking at Event Viewer on server right now. I tried running batch file with PDI job in it without any scheduling and unfortunately event viewer did not record anything,...
  42. Replies
    4
    Views
    1,090

    Win Server 2003 and Scheduling PDI jobs

    Hello everyone,

    I scheduled a job using Windows Server 2003 scheduler and it ran fun, while I was logged into server, and when I scheduled and logged out it did not run.

    I did similar staff...
  43. I am still trying to understand why do you need...

    I am still trying to understand why do you need success step? It seems to work without it.
  44. Excellent! I only came up with executing two...

    Excellent!

    I only came up with executing two jobs consecutively and reading the results and executing one job in parallel without continuation. You solution is more efficient, since it does not...
  45. Proceed only if both of previous two jobs are succesful

    Hello Everyone,

    I have JobA and JobB. I have hop from JobA to JobC and hop from JobB to JobC. I would like to execute JobC only if both JobA and JobB were successful. I cannot put JobA and JobB...
  46. Replies
    2
    Views
    853

    Thank you, Mick! I will try it. However, I am...

    Thank you, Mick!
    I will try it. However, I am surprised that CSV input behaves differently from Text input. Seems like a bug.
  47. Replies
    2
    Views
    853

    Enclosure and quotes

    Hello everyone,

    I have text file with tab as a separator and where text fields are enclosed in quotes. It looks like PDI consider quotes as separator as well (slightly different). For example if...
  48. As far as I understand. You have to drag filter...

    As far as I understand. You have to drag filter step on existing hop and PDI will ask you incorporate filter. Then true will go where hop goes and false will go nowhere.
  49. Replies
    3
    Views
    10,139

    Great! Thank you! It worked with add constant...

    Great! Thank you! It worked with add constant component.

    Now I am thinking, after this transformation I get an extra field from calculator (the one that contains appended string), I can replace...
  50. Replies
    3
    Views
    10,139

    Append character to a string

    Hello everyone!

    I have a string, for example "illustration". I would like to add word "Super" in-front of it, so the result would look like
    "Superillustration". Does anybody know the appropriate...
Results 1 to 50 of 171
Page 1 of 4 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.