Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Restart Carte server every 24 hours on Windows VM server

    Hi,

    Has somebody here a .bat file or other idea on how to restart the Carte server on a Windows VM every 24 hours? I have noticed that after running it for 6-7 days, it starts to get "GC overhead...
  2. Convert table input result to verbose output to use in mail body

    Hi,

    Is there an easy way to take the data from a Table Input step and convert it somehow to get the verbose output like when running SQLs in the console?



    Order Ref ASIN Location ...
  3. HTTP Status 401 - http://localhost:8190/localhost/kettle/registerPackage Unauthorized

    Hi,

    I am testing PDI 8.3 and started my carte server on the localhost. When starting a job from Spoon and sending it to the carte server, I get the error message

    HTTP Status 401 -...
  4. For reference, I ended up putting it all in a...

    For reference, I ended up putting it all in a WGET command and saved the output to a text file that I parsed afterwards. Not sexy but it works :)

    In case somebody needs it later, here the Java...
  5. Call RT REST web service to retrieve ticket list

    Hi,

    I have a ticket system based on RT and that also provides retrieving all the data via REST call (https://rt-wiki.bestpractical.com/wiki/REST#Abstract).
    I have used the REST client and HTTP...
  6. Replies
    5
    Views
    445

    Ah, got it. What threw me off is that it does not...

    Ah, got it. What threw me off is that it does not show the date in a 'proper' date format in the preview tab so by just looking at that you cannot tell that it actually converted it to a date type....
  7. Replies
    5
    Views
    445

    In the attachment you can see that I am actually...

    In the attachment you can see that I am actually using a Data Grid as input (data type is Integer). I have also tried it with data type String or to use a Select step in between to convert from...
  8. Replies
    5
    Views
    445

    Integer to date conversion does not work

    Hi all,

    I want to do something very simple: I get the a date from my database as Integer in the format yyyyMMdd e.g. 20171213 for today's date. Now I want to convert that to a real date with the...
  9. Bloody *#!* ... Found the issue ... my SELECT...

    Bloody *#!* ...

    Found the issue ...
    my SELECT also included



    SELECT name
    , current_timestamp()
    FROM customer
  10. Table Input with Oracle and values from previous step fails

    Hi,

    I have a Table Input step that is reading data from a Postgres database and returning just a single column and row in a string format

    2017-11-30 15:29:02

    I want to pass that value on to...
  11. Replies
    8
    Views
    1,647

    Probably but at least we are on the safe side if...

    Probably but at least we are on the safe side if somebody runs a SQL with now() and hasn't specified the timezone for the JVM prior.
  12. Replies
    4
    Views
    494

    Do you accept donations to a charity as a token...

    Do you accept donations to a charity as a token of gratitude?!
  13. Replies
    4
    Views
    494

    Read data from XML

    Hi,

    I want to use the Get Data from XML step to parse the attached XML file and extract this piece of information:


    <property name="odaDriverClass">org.postgresql.Driver</property>
    ...
  14. Replies
    8
    Views
    1,647

    Looks like we are going with adjusting the time...

    Looks like we are going with adjusting the time zone on the database server and the start up option of the JVM.
    Thanks!
  15. Replies
    8
    Views
    1,647

    I have just tried to run this SQL INSERT INTO...

    I have just tried to run this SQL

    INSERT INTO db_amz.timestamps_complete
    (order_no, cutoff_time)
    VALUES('max100', '1970-01-01 16:00:00 -06:00');

    and that does exactly what I want.

    Then I...
  16. Replies
    8
    Views
    1,647

    That is correct.

    That is correct.
  17. Replies
    8
    Views
    1,647

    Apply time zone information to time value

    Hi,

    I have a Date field with the information:

    2017-11-09 16:00:00

    From a business perspective, I know that that is the valid time for the time zone

    America/Chicago (UTC-06:00)
  18. Replies
    0
    Views
    618

    Properly configure Carte as a service

    Hi,

    I am trying to set up Carte as a service according to http://wiki.pentaho.com/display/EAI/Carte+as+a+Windows+Service but there seems to something wrong in my YASJW wrapper.conf file because I...
  19. Replies
    33
    Views
    15,607

    Had the same issue again - from one day to the...

    Had the same issue again - from one day to the other it just disappeared. Exchanging the log4j.xml solved the issue.
  20. Replies
    6
    Views
    20,517

    Awesome hint! Thanks so much! Bobse

    Awesome hint! Thanks so much!

    Bobse
  21. Replies
    2
    Views
    892

    Ok, so I managed to inject the segments by...

    Ok, so I managed to inject the segments by pre-building them in a JavaScript step but that seems a little bit cumbersome. Is there another approach to look into?
  22. Replies
    2
    Views
    892

    Inject XML segment into existing XML file

    Hi,

    I am using the Add XML and XML Join steps to build my own XML file. Now I have the problem that at one point in the XML file there should be segment like


    ...
  23. Replies
    3
    Views
    562

    I found the issue: looks like as if the job or...

    I found the issue: looks like as if the job or Shell entry was corrupt. After I created a new job and recreated the entries, all worked fine.

    And cd P: had the desired effect since it switched...
  24. Replies
    3
    Views
    562

    Shell entry does not execute script

    Hi,

    I have a Shell entry with this script


    @echo on
    cd P:
    Set BIRT_HOME=P:\server
    %BIRT_HOME%\ReportEngine\genReport.bat -f pdf -o "P:\pentaho\output\reports\client\copacker\cpacker.pdf" -F...
  25. Nilesh, As per your question in the PM, here...

    Nilesh,

    As per your question in the PM, here the attachment.

    Max

    15798
  26. marabu, The metadata step did the trick!...

    marabu,

    The metadata step did the trick! Combined with some String replacements and concatenation it works like a charm now! :)
    Thanks!

    Bobse
  27. Automatically trim all fields before Table Output step

    Hi,

    I am querying multiple different tables from a DB2 database with a simple

    SELECT * FROM ${param_lib}.${param_table}

    query and then want to transfer the data over to my local Postgres...
  28. Believe me, I was confused too the first time I...

    Believe me, I was confused too the first time I saw it, but this is the structure for one of our EDI messages and I cannot change it :/

    As I said, I think it would be possible to achieve this by...
  29. Using current entry name in logging settings as variable

    Hi,

    Is it possible to use the actual entry name per variable in the field 'Name of logfile' in the 'logging settings' tab of the Transformation entry in a job?

    14393

    Bobse
  30. Hi marabu, I have attached my 'real world'...

    Hi marabu,

    I have attached my 'real world' problem (XML_original_situation.xml) and the desired final result (XML_final_result.xml), which is not exactly what I have described above but my guess...
  31. Nobody got an idea or is it simply not possible?

    Nobody got an idea or is it simply not possible?
  32. Using UDJC or Java Script step to compare different rows

    Hi,

    I am looking for a way to cycle through a rowset, compare the values between rows and under certain conditions, adjust values in one of the row's fields.

    For example, set Value C to Y where...
  33. Yes, that would work. But I would have to trigger...

    Yes, that would work. But I would have to trigger that somehow in Access manually which is not an option here since I can only reach the file via network file sharing.
  34. Tried that already, problem is, that the file...

    Tried that already, problem is, that the file itself is much larger than the single table I am querying and therefore the copying takes a long time too. Prior zipping or database compression was also...
  35. Thanks for the info! Thing is, that we have to...

    Thanks for the info!

    Thing is, that we have to load the MS Access database over a network and for some reason the performance is really bad. When activating the performance monitoring, you can see...
  36. Read data from a query in a MS Access 2007 database

    Hi all,

    Is it possible to use a query of a MS Access 2007 database as data input? The MS Access input step seems only to be able to read from tables, but not from queries.
    Thanks for any hint!
    ...
  37. Thanks for pointing me in that direction :D...

    Thanks for pointing me in that direction :D
    Found the 'bug': it was actually the Date local flag: if you set it to 'en' and not 'en_US', it works like charme :)
  38. Ok, but to counter that I have set explicitly the...

    Ok, but to counter that I have set explicitly the Date locale flag to en_US since that is the formatting of the Tomcat log.
  39. Hi, 1) Tried to add the Z, no difference. 2)...

    Hi,

    1) Tried to add the Z, no difference.
    2) Done, here the result:

    ...
  40. BTW, I have just tried to execute it via Kitchen...

    BTW, I have just tried to execute it via Kitchen and produced the same error.
  41. Actually, it IS parseable when executed locally...

    Actually, it IS parseable when executed locally in Spoon. Only when executed in Carte, it does not work. I have tried your idea with the text output and here is one of the lines that get are...
  42. Carte treats transformation different than Spoon

    Hi,

    I have noticed something interesting: when processing my Apache Tomcat log, Carte treats the transformation other than Spoon.
    In Spoon, the transformation works fine and the Select step...
  43. You have to put it in front of the URL when you...

    You have to put it in front of the URL when you are calling the carte server in your browser.
  44. Just add cluster:cluster@ before your IP address...

    Just add cluster:cluster@ before your IP address 127.0.0.1
  45. Do you maybe have to use addTrans prior...

    Do you maybe have to use addTrans prior startTrans?
  46. Thanks! :)

    Thanks! :)
  47. My guess: you have to remove the .ktr suffix in...

    My guess: you have to remove the .ktr suffix in the URL

    see: http://forums.pentaho.com/showthread.php?160338-Date-over-web-service-with-repository-gives-error-quot-cannot-find-transformation-quot
  48. Replies
    4
    Views
    865

    Hi Matt, Thanks for the link, that was new to...

    Hi Matt,

    Thanks for the link, that was new to me :) And I must say, I am impressed, the performance is far better! :)
    Would be nice though if it was more adjustable, but so far it's really good!...
  49. Replies
    4
    Views
    865

    Integrate BIRT ReportEngine into UDJC step

    Hi,

    I am trying to integrate this java class into the UDJC step in order to achive the following:



    Read data to determine the different report paths
    Hand the paths over to the step
    ...
  50. Ok, guess I'll have to write a small JAVA script...

    Ok, guess I'll have to write a small JAVA script instead to compile the complete URL and then pass that one on to the step.
    Thanks for the info!
Results 1 to 50 of 99
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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