Profile

Andrew Cave

BizCubed Pty Ltd

Contact Details

BizCubed Pty Ltd

My Content

1 to 20 of 50+ total
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 ...
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 ...
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 ...
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
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 ------------------------------
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 ...
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.  ...
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 ...
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)
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 ----------- ...
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 ...
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
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
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 ...
Posted By Andrew Cave 08-09-2022 19:32
Found In Community: Pentaho
\ view thread
Hi Chiara. Look at that sheet, you're using an Excel table with defined headers, but when you're writing  out the data, you're overwriting the header line AND changing the header names.  As excel effectively usings those as database column names, you're changing the table definition too unexpectedly ...
Posted By Andrew Cave 07-07-2022 19:21
Found In Community: Pentaho
\ view thread
Hi Enrique You've got the DataLineage plugin turned on.   You can view the doco at https://help.hitachivantara.com/Documentation/Pentaho/9.3/Products/Data_lineage and you can see how to turn it on.  And I presume turning it off is doing the opposite : )
Posted By Andrew Cave 07-06-2022 23:45
Found In Community: Pentaho
\ view thread
OK.  Can you give some more info on the system. which version of Pentaho which version of Java are you using what OS are you and what version is it at what point does this error occur is it on the desktop or the server version?
Posted By Andrew Cave 07-06-2022 19:44
Found In Library: Pentaho
Multi-part HTTP upload of a file using a UDJC step
Posted By Andrew Cave 07-06-2022 19:23
Found In Egroup: Pentaho
\ view thread
Hi From what I can see in the code, the jdbc connector is not working as expected.   It appears to be using a really old version of the snowflake jdbc code .  Maybe try converting the database connect to a Generic one and specify the driver name stuff instead ------------------------------ Andrew ...