Profile

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 ...

RE: Help with Excel Writer Compatibility errors

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 ...

RE: Pentaho Kettle locking up while running TransformAnalyzer

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 : )

RE: ERROR [BlueprintContainerImpl] Unable to start blueprint container for bundle org.apache.karaf.features.core due to unresolved dependencies [(&(url.handler.protocol=mvn)(objectClass=org.osgi.service.url.URLStreamHandlerService))]

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?

multi_part_upload_demo_w_sample_xml

Posted By Andrew Cave 07-06-2022 19:44
Found In Library: Pentaho

Multi-part HTTP upload of a file using a UDJC step

RE: plugin issue

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 ...

RE: ERROR [BlueprintContainerImpl] Unable to start blueprint container for bundle org.apache.karaf.features.core due to unresolved dependencies [(&(url.handler.protocol=mvn)(objectClass=org.osgi.service.url.URLStreamHandlerService))]

Posted By Andrew Cave 07-06-2022 19:14
Found In Community: Pentaho \ view thread

It appears to missing the jar org.osgi.core-6.0.0.jar in data-integration\lib\ Can you confirm if it is there

Andrew Cave

Contact Details

Andrew Cave

My Content

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

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

RE: Problem with MSAD integration

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

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

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

RE: Connection to repository is closed and job fails

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

RE: email from basic authentication to modern autentication

RE: Connection to repository is closed and job fails

RE: Connection to repository is closed and job fails

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

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

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

RE: Help with Excel Writer Compatibility errors

RE: Pentaho Kettle locking up while running TransformAnalyzer

RE: ERROR [BlueprintContainerImpl] Unable to start blueprint container for bundle org.apache.karaf.features.core due to unresolved dependencies [(&(url.handler.protocol=mvn)(objectClass=org.osgi.service.url.URLStreamHandlerService))]

multi_part_upload_demo_w_sample_xml

RE: plugin issue

RE: ERROR [BlueprintContainerImpl] Unable to start blueprint container for bundle org.apache.karaf.features.core due to unresolved dependencies [(&(url.handler.protocol=mvn)(objectClass=org.osgi.service.url.URLStreamHandlerService))]