Profile

Antonio Petrella

UNOG

Contact Details

UNOG

My Content

1 to 16 of 16 total

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

Posted By Antonio Petrella 08-02-2022 09:54
Found In Egroup: Pentaho \ view thread
Hello Carlos,   thank you for taking the time and trying different configurations. I believe that you meant PDI 9.3 EE. I have observed this problem on PDI 9.3 CE. In any case, I was unable to solve the problem. The tests performed by others suggest a local system (mine) configuration. But it's difficult ...

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

Posted By Antonio Petrella 05-30-2022 05:34
Found In Egroup: Pentaho \ view thread
Thank you again for these tests Stephen. I'll try to better examine my environment. I need also to understand how the TextFileOutput call happens from the Concat Fields. ------------------------------ Antonio Petrella Data Service Manager UNOG ------------------------------

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

Posted By Antonio Petrella 05-26-2022 03:12
Found In Library: Pentaho

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

Posted By Antonio Petrella 05-26-2022 03:12
Found In Egroup: Pentaho \ view thread
Hi Stephen,  Thank you for taking the time and looking into this strange behavior. Please find attached the test transformation. I tried to run it from Spoon and from the command line using pan on Windows 10 with OpenJDK 11.0.15 and got the failure. As said, if I configure the Concat fields ...

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

Posted By Antonio Petrella 05-24-2022 04:47
Found In Egroup: Pentaho \ view thread
Hi Andrew,    Thank you for your reply. I tested a very simple transformation ( Generate rows -> Concatenate Fields -> Log ) on two test environments that I have and the results are: - on Linux, the test transformation works without problems on PDI CE 9.3 (even with AdoptOpenJDK 8) - on Windows ...

Error from Concat fields in PDI CE 9.3.0.0-428

Posted By Antonio Petrella 05-23-2022 11:40
Found In Egroup: Pentaho \ view thread
Hello everyone,    I have noticed that in PDI CE 9.3 (on Open jdk 8) the Concat Fields component throws an error if in the Advanced tab the option Fast data dump (no formatting) is unchecked. With such option unchecked it goes into error even if the Length of Target Field is provided (is not 0 but a ...

RE: Pentaho DI Community Edition slow on purpose?

Posted By Antonio Petrella 04-04-2022 02:55
Found In Egroup: Pentaho \ view thread
Hi Robert,    the 10000 is the default limit of the rowset size. Beyond that limit PDI starts caching. You may try to see what happens if you increase it.  (with the transformation loaded on Spoon click Edit -> Settings -> Miscellaneous tab -> Nr of rows in rowset option). In any case, I've also ...

RE: PDI 9.2 - Carte

Posted By Antonio Petrella 03-17-2022 08:49
Found In Community: Data Management & Analytics​ \ view thread
Hi, it seems like pdi version 9.2 requires the repository parameter. I solved / worked around it by providing an empty one in the list of GET parameters  Just add &rep= to your Carte URI

PDI 9.2 carte serving back a malformed xml

Posted By Antonio Petrella 12-08-2021 05:03
Found In Community: Pentaho \ view thread
Hi all,   I have a transformation called from Carte through the executeTrans endpoint that serves back an xml to Carte via the XML output component configured with the "Pass output to servlet" checked. In PDI 9.0 this was working fine and I received from carte the XML created in the XML output component ...

RE: i18n in report called from PDI

Posted By Antonio Petrella 10-18-2021 08:35
Found In Community: Pentaho \ view thread
For these interested heres how I managed: built on the fly the name of the resource file in the resource-identifier attribute using the input language parameter.

i18n in report called from PDI

Posted By Antonio Petrella 10-15-2021 13:29
Found In Community: Pentaho \ view thread
Hi, Im generating report through a Kettle Transformation (Pentaho reporting output component). Is there a way to trigger the appropriate i18n resource through a report input parameter?   I think the question can also be: is there a way to configure the environment variables of a report (Im thinking about ...

RE: Configuring PDI transformation as report data source

Posted By Antonio Petrella 10-04-2021 07:02
Found In Community: Pentaho \ view thread
Found out the way to do it through relative path. For those interested check the old forum post:   https://forums.pentaho.com/threads/231306-Directory-variable-in-PRD/

Configuring PDI transformation as report data source

Posted By Antonio Petrella 09-28-2021 15:46
Found In Community: Pentaho \ view thread
Hello, is it possible to create report through Report Designer with a Pentaho Data Integration data source and in the File field provide the path to the PDI transformation using environment variables like $(Internal.Entry.Current.Directory)?   Or is there any way to read the path or the transformation ...

Hi all, I just wanted to know whether there is a way (or a plan to add the support) to connect to a MongoDB cluster with TLS and also using x.509 certificate authentication in the BigData/MongoDB input and MongoDB output steps. Thanks!

Posted By Antonio Petrella 07-26-2021 07:45
Found In Community: Pentaho \ view thread
#Kettle #PentahoServer #PentahoDataIntegrationPDI #Pentaho

RE: DI - MongoDB Aggregation broken with MongoDB 3.6

Posted By Antonio Petrella 01-14-2019 10:17
Found In Community: Pentaho \ view thread
Did a bit of research and it seems that the support for the mandatory cursor in the aggregation framework (in mongoDB from version 3.6) starts with PDI 8.1.0 (Components Reference - Pentaho Documentation). I have tested with 8.2.0.0 and MongoDB 4.0 and it works.

RE: DI - MongoDB Aggregation broken with MongoDB 3.6

Posted By Antonio Petrella 01-11-2019 13:31
Found In Community: Pentaho \ view thread
Hello,   has anyone found a solution for this problem without downgrading to MongoDB < 3.6 (Im using PDI 8.0)? Ive recently upgraded from 3.4 to 4.0 so downgrading MongoDB is definitely not an option for me... Thanks, Antonio