We are running daily job through pentaho data integration tool. It was working fine till months ago. But now we are getting the below error when we try to run it. I have checked the database is working fine when I connect it through sql developer. Can anybody help why we face the below issue. Error connecting to database: (using class…(Show moreShow less)
Hi Ana, Thanks for your reply. I have tested the Database job and I got the below error: Error connecting to database: org.pentaho.di.core.exception.kettleDatabaseException: Error occurred while trying to connect to database Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) IO error: Connect identifier was empty.…
Hi, I have integrated kettle with Eloqua. But am not able to retrieve more than 50000 records even on using 'OFFSET'. As i am a beginner, Can anyone help me out or suggest me what could be done to make the offset work and extract more records from Eloqua. It would be great if i can get some documentations regarding this.
Hi: I have been trying to use the MAPD jdbc driver with other tools (Squirrel SQL) and it works fine but for some reason when I put he JAR file in the lib folder for Spoon it does not pick it up. I contacted MAPD and they told me to ask on this forum why the JAR is not picked up as it should by Spoon. Any idea on how to resolve this issue? I…(Show moreShow less)
Hi: I created a generic jdbc connection after putting the JAR in the lib folder. and it works. Here is a screenshot of the config. Replace <server-id> with your server name. Future improvement: It will be great to have mapd show up in the connection type box instead of creating a generic database connection.
Hi all, I am having problems with PDI when I try to pass result rows from one transformation to another using Parameters/Variables. I attach you the files, cause I can't figure it out what is wrong with it. I've been searching for a solution for the last three days with no success so I am a little bit frustrated hehehe Explanation of the…(Show moreShow less)
The good news is that this is already solved and patched in the upcoming 220.127.116.11. If you build the RC tag you will get it. I used this and extracted the classes and 'upgraded' my 18.104.22.168-ee forcefully. I really love Java for that ability. So we are testing our ETL slowly to make sure no other regressions pop up. So far so good.
Hey, I set up the db connection but I find nowhere the option "create repository for connection"... I am working with pentaho 8.1. In former editions, you're right, the option existed... When I set up a new repository with an existing and functionning db connection I have only two options : connect (but the repository tables do not exist) or…
Hi All, Could you please help me in finding a solution to a problem. I'm using Pentaho Kettle v 6.1 for my data integration. Source sytem would be json file whose size would vary based on the data load on the source system from 10kb to 1gb or more ( in peak hours) per 15 mins. Could you please let me know if it is feasible to create…(Show moreShow less)
Hi! I'm running a Python script via the Shell step. The problem is that everything that the script logs out, goes through via stderr so I get a ERROR message in every line, but there's actually no error, the executions ends OK. Any ideas? I'm running Kettle - Spoon 22.214.171.124 Example: 2018/07/13 10:57:59 - DWH_1086_APP_POPUP_EVENT - exec(5, 0,…(Show moreShow less)
I recently upgraded to 8.1 PDI(community edition) from 7.1. The Mongo Input step was all working fine in the older version. But in the new version I am getting the below error. com.mongodb.MongoCursorNotFoundException: Query failed with error code -5 and error message 'Cursor 141094656064 not found on server xx.xx.xx.xx:27017' on server…(Show moreShow less)