Profile

Andrew Cave

BizCubed Pty Ltd

Contact Details

BizCubed Pty Ltd

My Content

1 to 20 of 50+ total

RE: Unable to run job from jenkins,

Posted By Andrew Cave 01-22-2023 17:42
Found In Egroup: Pentaho \ view thread
If the Jenkins is not running under your username then it won't be able to find your plugins directory.    In addition the KETTLE_HOME may not be set.   Try copying the necessary files out to a folder that Jenkins can reach and also set the KETTLE_HOME var to this directory in the Kitchen.bat file ...

RE: The Network Adapter could not establish the connection

Posted By Andrew Cave 01-22-2023 17:29
Found In Egroup: Pentaho \ view thread
Hi Thiago I think the problem is the oracle driver name is hard-coded into Pentaho - there is the same problem with MySQL 8 drivers - and  'sun.jdbc.odbc.JdbcOdbcDriver'  is not the name of the driver anymore.  The error "rro de ES: The Network Adapter could not establish the connection" is usually ...

RE: Getting error; Admin user issue, Pentaho configuration with LDAP

Posted By Andrew Cave 12-18-2022 17:14
Found In Egroup: Pentaho \ view thread
Hi Jagdeesh You should try installed a copy of OpenLDAP, finding your admin user in there and then comparing the search string to the one you've entered into Pentaho. LDAP search is tricky. Regards ------------------------------ Andrew Cave Systems Engineer BizCubed Pty Ltd Australia ----------- ...

RE: [Get a file with FTPS] failling with Get a file with FTPS - java.net.SocketException: Socket is closed

Posted By Andrew Cave 10-11-2022 18:18
Found In Egroup: Pentaho \ view thread
Did you make the certificate  trusted when you added it to the keystore? Add -Djavax.net.ssl.trustStore=/path/to/truststore -Djavax.net.ssl.trustStorePassword=truststorepassword to the start-pentaho.sh to point to the truststore and -Djavax.net.debug=all to get the (extremely verbose) logging ...

RE: Pentaho Data Integration carte - custom API read JSON body

Posted By Andrew Cave 09-29-2022 19:40
Found In Community: Pentaho \ view thread
I am puzzled as to how you are making the call.    Reading it in the Inspect window and having the HTTP method changed is weird. How exactly are you making the call to pentaho and on what page are you reading the request contents on.   As an aside loggers by default don't log the body of a POST mess ...

RE: Pentaho Data Integration carte - custom API read JSON body

Posted By Andrew Cave 09-28-2022 20:00
Found In Community: Pentaho \ view thread
Yeah.  You can send multiple parameters in the body too.   If they are named in the transformation parameters they'll get passed in. curl --request POST \ --url https://host:port/pentaho/kettle/executeTrans/ \ --header 'Authorization: Basic whatever' \ --header 'Content-Type: application/x-www-form-urlencoded' ...

RE: CARTE not refresing logs for a while in long running jobs

Posted By Andrew Cave 09-20-2022 19:03
Found In Community: Pentaho \ view thread
Hi Juan Apparently the Pentaho logging behaviour is a compromise between logging completeness and application performance.  In addition, I think the status applet queries the log4j buffer for it's current state. TO get the most complete logs, set up a logging file on the job/trans executers at the top ...

RE: How to handle corrupted data in INPUT DATA side (text file input)

Posted By Andrew Cave 09-18-2022 19:16
Found In Community: Pentaho \ view thread
Hi Sampath For simple line errors, you can ignore the errors and check the error lines later as shown. It looks like you've got some zipped data in there - I you need to unzip it you'll need to change the format from CSV as the line feed is not a good line delimiter.  Probably treat it as a binary file ...

RE: Problem with MSAD integration

Posted By Andrew Cave 09-15-2022 21:09
Found In Egroup: Pentaho \ view thread
Hi Marcial You need to map the Pentaho adminstrator role to the AD group that you want to be the Administrator group LDAP Security Hitachi Vantara Lumada and Pentaho Documentation remove preview LDAP Security To use Lightweight Directory Access Protocol (LDAP) for user security, you ...

RE: Pentaho Data Integration carte - custom API read JSON body

Posted By Andrew Cave 08-29-2022 19:13
Found In Community: Pentaho \ view thread
Hi Mini I describe how to use a CDE form to send JSON to a Transformation here https://bizcubed.com/ctools-using-a-pentaho-cde-form-as-an-input-form-part-1 and  here https://bizcubed.com/ctools-using-a-pentaho-cde-form-as-an-input-form-part-2 regards

RE: Problems upgrading MSSQL's JDBC to 11.2 and how to set properly encrypt=false in the JDBC URL

Posted By Andrew Cave 08-24-2022 20:43
Found In Egroup: Pentaho \ view thread
Alas I don't think there is, ------------------------------ Andrew Cave Systems Engineer BizCubed Pty Ltd Australia ------------------------------

RE: Unable to find plugin with ID 'Kettle' in 9.3.0.0-428

Posted By Andrew Cave 08-23-2022 19:24
Found In Community: Pentaho \ view thread
HI Marius That xml file should exist in (INSTALL)\pentaho-server\tomcat\webapps\pentaho\WEB-INF\classes   the files in classes folder on the server should be \docs \org logging.properties log4j2.xml classic-engine.properties drilldown-profile.xml kettle-password-encoder-plugins.xml kettle-registry-extensions.xml ...

RE: Connection to repository is closed and job fails

Posted By Andrew Cave 08-23-2022 19:13
Found In Egroup: Pentaho \ view thread
Hi Martin Create a new job, join a Transform executor entry to the Start entry.  Point that entry to a new transformation that contains your xml parser joined to a single 'copy rows to results' step. Back in the job, join another transform executor to the last one and point it to another new entry.  ...

RE: Problems upgrading MSSQL's JDBC to 11.2 and how to set properly encrypt=false in the JDBC URL

Posted By Andrew Cave 08-23-2022 19:11
Found In Egroup: Pentaho \ view thread
Hi Juan You could add "encrypt=false" to the connection Options dialog which has the same effect but is neater, or construct a full JDBC string and use a Generic Database connection instead. The more complex one is to find the code for the connector plugin jar in the pentaho git repo, adjust it yourself ...

RE: email from basic authentication to modern autentication

Posted By Andrew Cave 08-22-2022 19:41
Found In Community: Pentaho \ view thread
Hi Albert You might try the technique here https://www.cdata.com/kb/tech/office365-jdbc-pentaho-report-designer.rst but adjusted for pentaho (tip: use generic database connection so you can define the jdbc string)

RE: Connection to repository is closed and job fails

Posted By Andrew Cave 08-21-2022 19:11
Found In Egroup: Pentaho \ view thread
From the doco idle_session_timeout : If this value is specified without units, it is taken as milliseconds. So you've set the timeouts to 30 seconds. Valid units are "ms", "s", "min", "h", and "d" ------------------------------ Andrew Cave Systems Engineer BizCubed Pty Ltd Australia ----------- ...

RE: Connection to repository is closed and job fails

Posted By Andrew Cave 08-18-2022 19:43
Found In Egroup: Pentaho \ view thread
From https://www.postgresql.org/docs/current/runtime-config-client.html idle_session_timeout (integer) Terminate any session that has been idle (that is, waiting for a client query), but not within an open transaction, for longer than the specified amount of time. If this value is specified without ...

RE: Team, does we have PentahoCE latest version or existing version which has log4j version above 2.17.1 version?

Posted By Andrew Cave 08-18-2022 19:13
Found In Community: Pentaho \ view thread
Hi Rajiv Pentaho CE 9.3 has 2.17.1 .  CE versions are only updated on dot releases (9.4,9.5).   So if you want to have a later release of log4j you'll need to just replace the existing jar with a new version and run it.    It will probably work, but I've never tried. Regards Andrew Cave

RE: PDI/Spoon does not show dialog windows and other effects

Posted By Andrew Cave 08-18-2022 19:08
Found In Egroup: Pentaho \ view thread
Here's the easiest solution https://stackoverflow.com/questions/62301866/how-to-install-the-libwebkitgtk-package-on-ubuntu-20-04-lts Andrew Cave Analytics Consultant M. +61 430 365 773 T. +61 2 9007 7887 E. andrew.cave@bizcubed.com.au www.bizcubed.com.au

RE: Add Checksum output problem when changing Java or Pentaho version

Posted By Andrew Cave 08-14-2022 21:20
Found In Egroup: Pentaho \ view thread
Hi Adam I'd be very carefully checking that the data is coming through in exectaly the same way in the old install and the new.   If you are including floats in the data for the hash, then CPU/OS factors may vary slightly. You might try hashing a row after forcing them to definite values  and see if ...