Profile

Andrew Cave

BizCubed Pty Ltd

Contact Details

BizCubed Pty Ltd

My Content

1 to 20 of 50+ total

RE: PDI 9.2 / 9.3: Oracle Bulk Loader: Error because CTL-file not found: blanks replaced by %20

Posted By Andrew Cave 05-25-2022 18:56
Found In Community: Pentaho \ view thread
have you tried putting quotes around the file-name with the spaces?

RE: Problem with PDI 9.3 CE and Ubuntu 22.04: "SWT on GTK 2.x detected. It is recommended to use SWT on GTK 3.x and Webkit2 API."

Posted By Andrew Cave 05-24-2022 01:37
Found In Community: Pentaho \ view thread
Hi Teresa Per https://help.hitachivantara.com/Documentation/Pentaho/9.3/Setup/Components_Reference "Linux requires libwebkitgtk-1.0" To get it 1. sudo nano /etc/apt/sources.list 2. Add this entry to the file and save: deb http://cz.archive.ubuntu.com/ubuntu bionic main universe sudo apt-get update sudo ...

RE: Error from Concat fields in PDI CE 9.3.0.0-428

Posted By Andrew Cave 05-24-2022 01:36
Found In Egroup: Pentaho \ view thread
Hi Antonio I tried it on 93EE without a problem.   Try running it using Azul OpenJDK11 instead of 8 ( add export JAVA_HOME=/Path/to/java11 to the spoon.bat/command/sh file If that doesn't work, can you come back with the OS, and how long the fields you're concatenating are as well. ----------- ...

RE: No class registered for id pentaho-cdf-dd Pentaho 9.1.0.0-324

Posted By Andrew Cave 05-23-2022 19:04
Found In Community: Pentaho \ view thread
Hi Marlon Have you turned on ctools per https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/CTools/Activate_CDE ?

RE: s3 file output Step connect timed out us-west-2

Posted By Andrew Cave 05-17-2022 19:52
Found In Egroup: Pentaho \ view thread
Hi Vince Try adding echo "currentuser=$USER  " > /tmp/awscheck.log echo "homedir=$HOME" >> /tmp/awscheck.log echo ` aws configure list` >> /tmp/awscheck.log to the shell script and then check the output in /tmp/awscheck.log    Just to confirm that all the environment variables have been set on ...

RE: Error connecting to Mysql 8 with caching_sha2_password enabled

Posted By Andrew Cave 05-11-2022 21:17
Found In Egroup: Pentaho \ view thread
I'm using the MySQL driver.  I put the postgresql-42.2.5.jar and the mysql-connector-java-5.1.41-bin.jar in the folder (or the current ones of each) caching_sha2_password is  used by default on MySQL8 (because it's more secure).  However, I do know that you can set the protocol to mysql_native_password ...

RE: Error connecting to Mysql 8 with caching_sha2_password enabled

Posted By Andrew Cave 05-11-2022 00:01
Found In Egroup: Pentaho \ view thread
Hi Claudio I've been connecting to MySQL 8 databases for the past three years.  I just confirmed it works in 9.2 and 9.3 I've tried to use a generic database connection but it changes the format of the result of the select queries. That is the result of a Table input item seems to be different from ...

RE: s3 file output Step connect timed out us-west-2

Posted By Andrew Cave 05-10-2022 19:16
Found In Community: Pentaho \ view thread
Hi Vince So in the file it reads ~/.aws/config [default] region=eu-west-2 and that file is in the home directory of the account that is running the pentaho instance? try running the transformation with Debug logging on and see where Kettle is trying to read the config from.

RE: Kafka consumer step will not read messages

Posted By Andrew Cave 05-10-2022 19:03
Found In Egroup: Pentaho \ view thread
Hi Vince The problem is that the version of the plugin you are using is calling subTransExecutor() in this class https://github.com/pentaho/pentaho-kettle/blob/master/engine/src/main/java/org/pentaho/di/trans/streaming/common/BaseStreamStep.java In the previous commit on kettle, the function subTransExecutor() ...

RE: Kafka consumer step will not read messages

Posted By Andrew Cave 05-09-2022 20:49
Found In Egroup: Pentaho \ view thread
hmmmm...that doesn't tell us much.  It looks like it is trying to access a private method in a class. https://github.com/pentaho/pentaho-kettle/blob/master/engine/src/main/java/org/pentaho/di/trans/streaming/common/BaseStreamStep.java   at line 235 looks like it should be trying to use getSubTransExecutor() ...

RE: Kafka consumer step will not read messages

Posted By Andrew Cave 05-08-2022 20:02
Found In Egroup: Pentaho \ view thread
Hi Vince It's a bit hard to tell without seeing what you've done in the transformation, but I presume you have set it up according to the reference Kafka Consumer and have a 'get records from Stream' step going ? Also, try this video Kafka components in Pentaho .   Does a very nice job in covering ...

RE: Error connecting to Mysql 8 with caching_sha2_password enabled

Posted By Andrew Cave 05-08-2022 19:39
Found In Egroup: Pentaho \ view thread
Hi Claudio It's a bit hard to tell from this, and I'm not familiar with xactions either (thought they'd been deprecated actually). Make sure you haven't got the  mysql5 driver under tomcat/webapps/WEB-INF/lib or tomcat/lib , stop the server, clear the karaf cache ( under pentaho-server/pentaho-sol ...

RE: Cannot import KTR / KJB files to Pentaho repository

Posted By Andrew Cave 05-03-2022 01:58
Found In Egroup: Pentaho \ view thread
RepositoryMeta is null usually occurs because there is something screwy with the repository itself - i.e. it can't find it.   Check the repository defined in .kettle/repositories.xml is the one you can see at the bottom of (server)/pentaho/kettle/status  ( which is set in pentaho-server/pentaho-solu ...

RE: Dynamic authentication token in KTR Rest Client

Posted By Andrew Cave 05-02-2022 22:13
Found In Community: Pentaho \ view thread
Hi Marek Password is not available in the PUC, though you can get the current user with pentaho/api/session/userName  The authentication is handled by Spring security and it hashes the password itself before storing. You can pass variables to the ktr via the REST interface and I suppose you could set ...

RE: Carte cluster not load balancing transformation between the slaves while using the API

Posted By Andrew Cave 04-20-2022 19:49
Found In Community: Pentaho \ view thread
It's really unclear documentation isn't it.  From this old post by Diethard Steiner http://diethardsteiner.blogspot.com/2013/03/creating-clustered-transformation-in.html   it looks like a cluster schema needs to be set up as well - which you can only do from a transformation (weird?) Another reference ...

RE: Carte cluster not load balancing transformation between the slaves while using the API

Posted By Andrew Cave 04-19-2022 20:36
Found In Community: Pentaho \ view thread
Hi Juan et al Have you set up the files for the dynamic clustering as per this page  https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/Data_Integration/Carte_Clusters/Setup ?

RE: Upload a CSV file to AWS S3 using Pentaho

Posted By Andrew Cave 04-19-2022 20:32
Found In Egroup: Pentaho \ view thread
Hi Saket Try adding the intermediate certificate with the root certificate before importing it to the keystore.  Google 'certificate chaining' for how-tos. ------------------------------ Andrew Cave Systems Engineer BizCubed Pty Ltd Australia ------------------------------

RE: Various issues when migrating to 9.2 from 8.3

Posted By Andrew Cave 04-12-2022 13:54
Found In Egroup: Pentaho \ view thread
Hi Satish The problem will be that the plugins on the marketplace only go up to 8.2 (I don't know why) and I presume Spoon is looking for plugins for version 9.     However, the older ones still seem to work ok.   So you can manually transfer them from your old install or download them via the web and ...

RE: Cannot import KTR / KJB files to Pentaho repository

Posted By Andrew Cave 04-12-2022 03:29
Found In Egroup: Pentaho \ view thread
There is a file called ImportHandlerMimeTypeDefinitions.xml in pentaho-solutions/system that has the import types defined.   I've never had to touch it before though. You might also trying zipping the files up first then uploading them (PUC autmatically unzips).  Also in the Upload dialog, under Advanced ...

RE: Cannot import KTR / KJB files to Pentaho repository

Posted By Andrew Cave 04-11-2022 21:23
Found In Egroup: Pentaho \ view thread
Hi Marek It's failing to create the file in /home/admin  .  Are you logging in as admin when you are importing?   Have you tried importing via  PDI ?  You should have an option to set some heavier logging when you are doing an import via the PUC too. ------------------------------ Andrew Cave Systems ...