• 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 limit exceede...
  • 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  ...
  • Thread: 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 - http://localhost...
  • PDI Status SVG file not found

    HTTP ERROR: 404Problem accessing /pentaho/content/common-ui/resources/themes/images/run_options.svg. Reason: Not Found
    Kun Jiang
    last modified by Kun Jiang
  • Carte server 8.2 lacks some images at the kettle status page

    PDI version 8.2 community version, start the carte server using the following command: ./carte.sh pwd/carte-config-master-8080.xml visit the kettle status page: http://localhost:8080/kettle/status and th...
    Ze He
    last modified by Ze He
  • pentaho 8.2 mongodb input error

    It's work when I query a few documents, but when it query huge documents, I get error: cursor id not found. I google it and know It need set no time out cursor on find(), but I don't know how to set it on mongodb inp...
    Hui Tan
    last modified by Hui Tan
  • Unable to run PDI AEL Spark Jobs

    Pentaho Data Integration Version: 8.1 Hadoop Version: 2.7.3 Spark Version: 2.4.3   I am trying to use PDI AEL to submit Spark jobs to a Spark cluster. For my Hadoop configuration, I am using the config files p...
    Zach Izzard
    last modified by Zach Izzard
  • Optimal way to join multiple files and output without creating multiple transformations

    I have a task where I need to join multiple files and create a specific output file(s).   At the moment I have created around 10 or so transformations to carry out this task(one for each output file). To me thi...
    B816T5YG
    last modified by B816T5YG
  • error read mail using Email messages input with Gmail address

    Hi, I'm using Pentaho Data Integration version 6.1.   I tring to use "Email messages input" for read email message from Gmail. The test of Connection configuration is Ok. The test of Input folder is ok,  ...
    Fabrizio Agosti
    last modified by Fabrizio Agosti
  • java.lang.ArrayIndexOutOfBoundsException: 1 1

    Hello there,    I try to run a transformation with a CPython script step inside, I already did some of them before very similar with the same inputs and I'm pretty sure the python script is working but I've...
    Victorien DELANGUE
    last modified by Victorien DELANGUE
  • What is the URL format for a connection to HCP from PDI?

    I'm trying to connect to HCP via the Virtual File System. I can't find any documentation on the format of the URL with the hcp protocol. Can anybody provide or point me to the doc?
    C324K41S
    last modified by C324K41S
  • No plugin in the marketplace

    Hi there,    I'm trying to switch from PDI enterprise version to the community edition because my free license is over. For some transformations, I was using python executor and found that in the community ...
    Victorien DELANGUE
    last modified by Victorien DELANGUE
  • Multiple instances of PDI on same machine

    Hi All,   We are trying to install multiple instances of Pentaho DI in same machine. Need your help on below questions   Can we install multiple instances of PDI in same machine? Do we need install two ...
    Prasad Shetty
    last modified by Prasad Shetty
  • Why spoon doesn't read my changed CLASSPATH?

    I want to make easier the upgrading procedure for my PDI. I use some additional library (jar files), like jdbc driver, that are located into E:\DATAINTEGRATION\PDI\lib, where PDI is the program directory of mine...
    Mirko Mozzilli
    last modified by Mirko Mozzilli
  • Truncate table in Table Output step

    How does "Truncate table" in the Table Output step work?  The documentation says:  "Select if you want the table to be truncated before the first row is inserted into the table"   If I interpret that...
    Dirk Sachse
    last modified by Dirk Sachse
  • passing parameter through data grid in pentaho.

    passing parameter through data grid in pentaho. please assist how can i pass this paramter or to resolve it.    
    archana garikapati
    last modified by archana garikapati
  • PDI performance degradation

    Hello, I am analyzing why our ETL process using PDI is gradually performing slower with each execution when put under a heavy load for hours.   This process has been in place for years and has migrated across mu...
    Craig Shatswell
    last modified by Craig Shatswell
  • How to expose job as api using carte sever

    I am able to run transformation via api using carte server   eg : To run transformation via carte server through api http://localhost:8080/kettle/executeTrans/?trans=c:%2Fusers%2Fanukriti.kalkani%2Fdownloads%2F...
    Neha Varshney
    last modified by Neha Varshney
  • How to get the error line Number from CSV File Loading

    Hi,   I have a transformation that loads data from a csv file to a text output file, i have a some bad data in some of the row, I define the error handling output and pass error data to the output, I get the err...
    Swapnil Shelke
    last modified by Swapnil Shelke
  • How to read a html file as input?

    Hi guys,  I'm trying to read a html file (out of http, just a single html file on my desktop folder that is a raw data) but i'm failing miserably.   how can i do this? pdi can help me with this case?  ...
    Leandro Alves
    last modified by Leandro Alves