Profile

Juan Sierra Pons

Juan Sierra Pons

Contact Details

Juan Sierra Pons

My Content

1 to 20 of 49 total

RE: Web Service Call wth Complex Types

Posted By Juan Sierra Pons 10-25-2023 08:22
Found In Egroup: Pentaho \ view thread
Hi, In these cases it is better to get the data using a well known tool like Postman, curl, etc.Once you are sure you are using the right calls then translate it to Pentaho's right step Hope it helps Best regards -------------------------------------------------------------------------------------- Juan ...

RE: Login prompt on kettle status page

Posted By Juan Sierra Pons 08-21-2023 07:10
Found In Community: Pentaho \ view thread
I have the same configuration Carte+SSL in 9.3 and I haven't seen this behavior. Can you share your configuration? Does the same  behavior happens without the SSL?

RE: Using S3 REST API to upload file using Pentaho REST Client

Posted By Juan Sierra Pons 08-08-2023 08:46
Found In Egroup: Pentaho \ view thread
Can you share the error log? In the worse case you can use curl to send the query to the API and call the curl using Pentaho's Shell (Linux) or CMD steps (Windows).  ------------------------------ Juan Sierra Pons Systems Engineer Juan Sierra Pons ------------------------------

RE: Does Pentaho 9.4 support JDK 17

Posted By Juan Sierra Pons 08-04-2023 08:41
Found In Egroup: Pentaho \ view thread
Components Reference - Hitachi Vantara Lumada and Pentaho Documentation ------------------------------ Juan Sierra Pons Systems Engineer Juan Sierra Pons ------------------------------

RE: Issue with JNDI (SQL Server) after move from PDI 9.1 to 9.4

Posted By Juan Sierra Pons 08-04-2023 08:39
Found In Community: Pentaho \ view thread
I think your problem is with the java version as 20 is not supported Components Reference - Hitachi Vantara Lumada and Pentaho Documentation

RE: Carte as a Windows Service

Posted By Juan Sierra Pons 07-21-2023 02:31
Found In Egroup: Pentaho \ view thread
Same as you would do from the command line. eg: Program Script: E:\(PATH)\pdi-ce-9.3.0.0-428\data-integration\Carte.bat pwd\slave-9000.xml Add arguments (optional): pwd\slave-9000.xml ------------------------------ Juan Sierra Pons Systems Engineer Juan Sierra Pons ----------------------------- ...

RE: Carte as a Windows Service

Posted By Juan Sierra Pons 07-20-2023 10:23
Found In Egroup: Pentaho \ view thread
I made it work using this link https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/386803558/Carte+as+a+Windows+Service with java11 and PDI 9.3 There is another option that is launch the carte.bat from the windows task scheduler when the server reboots ------------------------------ Juan ...

RE: Decimal values are getting rounded off

Posted By Juan Sierra Pons 07-20-2023 10:20
Found In Egroup: Pentaho \ view thread
It might be a problem with your locales and how decimal values are handled with a "." or a "," ------------------------------ Juan Sierra Pons Systems Engineer Juan Sierra Pons ------------------------------

RE: SSL on Pentaho Carte server 6.0

Posted By Juan Sierra Pons 06-14-2023 07:20
Found In Community: Pentaho \ view thread
HI, I used this  link https://help.hitachivantara.com/Documentation/Pentaho/9.3/Products/Set_Up_a_Carte_Cluster to configure mine. Probably it should work too on 6.0 Hope it helps

RE: Is FTPES supported by Pentaho 9.3? (Explicit FTP over SSL/TLS)

Posted By Juan Sierra Pons 05-31-2023 08:54
Found In Community: Pentaho \ view thread
Finally I will use an script step and use curl inside. curl works on linux and windows and supports FTPES https://www.lewisroberts.com/2010/08/06/scripting-ftpes-explicit-tlsssl-with-curl/

Is FTPES supported by Pentaho 9.3? (Explicit FTP over SSL/TLS)

Posted By Juan Sierra Pons 05-29-2023 05:15
Found In Community: Pentaho \ view thread
Hi From FTP, FTPs, FTPes, SFTP explained FTPES (port 21) Explicit FTP over SSL/TLS. This starts out as plain FTP over port 21, but through special FTP commands is upgraded to TLS/SSL encryption. This upgrade usually occurs before the user credentials are sent over the connection. FTPES is a somewhat ...

RE: Pentaho performs very slow when unzipping files in a mounted samba share

Posted By Juan Sierra Pons 02-27-2023 04:54
Found In Egroup: Pentaho \ view thread
Hi @Carlos Lopez  Is there any plan to upgrade the Apache Commons VFS library? It seems that this upgrade would fix these kind of slowness problems. http://web.archive.org/web/20221205205204/https://forums.pentaho.com/threads/98127-Using-Samba-smbclient-in-Kettle/ There are some things going on ...

RE: IO Error when PDI 9.4 connect AWS RDS Oracle 19C

Posted By Juan Sierra Pons 02-20-2023 02:59
Found In Egroup: Pentaho \ view thread
@Tony lang, Just in case the problem is elsewhere try setting the trustServerCertificate to true in your JNDI and remove the other SSL certificate related options: trustServerCertificate=true This will trust server's certificate and do not check anything else. Check if this works You can also: ...

RE: Unable to run job from jenkins,

Posted By Juan Sierra Pons 01-23-2023 09:03
Found In Egroup: Pentaho \ view thread
Hi, I think you are facing an user permissions problem. Most probably you are running Spoon with your user and Jenkins is being run as a different user. eg: Administrator, NT AUTHORITY\SYSTEM, etc check that jenkins user can read the different files: jobs, transformations, .kettle (folder) Hope it ...

RE: Carte (PDI 9.3) on Windows taking to much time accepting Jobs

Posted By Juan Sierra Pons 01-20-2023 08:49
Found In Community: Pentaho \ view thread
There is no improvement. At this moment the only workaround is to increase the timeout to ensure the job id is returned :(

RE: OJDBC driver problem

Posted By Juan Sierra Pons 01-20-2023 01:55
Found In Egroup: Pentaho \ view thread
Can you provide the name of the JDBC driver you are using? Have you tested the same JDBC driver with another tool that uses JDBC drivers? eg: squirrelSQL http://www.squirrelsql.org/ ------------------------------ Juan Sierra Pons Systems Engineer Juan Sierra Pons ------------------------------

RE: Carte (PDI 9.3) on Windows taking to much time accepting Jobs

Posted By Juan Sierra Pons 01-19-2023 04:54
Found In Community: Pentaho \ view thread
I have modified the jetty options increasing the acceptors , etc My jetty now looks like this:                    4          4          2      The linux carte slaves are working perfectly with the default values. Let's see how it goes

Carte (PDI 9.3) on Windows taking to much time accepting Jobs

Posted By Juan Sierra Pons 01-19-2023 01:41
Found In Community: Pentaho \ view thread
Hi I have a cluster of Carte servers on Linux that works perfectly. As I have some Jobs that are Windows OS dependent, I have created a carte server on Windows to run them. Both OS have the same Java 11 version and are running the same PDI 9.3 version. Also both servers are not overloaded regarding CPU/MEM ...

Carte & Jetty Server Parameters

Posted By Juan Sierra Pons 12-05-2022 02:41
Found In Egroup: Pentaho \ view thread
Good morning, I am trying to tune Jetty's carte related parameters. But there is no much information out there Set Up a Carte Cluster acceptors The number of thread dedicated to accepting incoming connections. The number of acceptors should be below or equal to the number of CPUs. acceptQueueSize ...

RE: unable to connect file repository and also i cant save and rename new KTR and KJB on Pentaho-9.3

Posted By Juan Sierra Pons 11-29-2022 02:26
Found In Egroup: Pentaho \ view thread
Have you tried to reproduce it with other user? (to really start fresh) Which java version are you using? If you renamed the installation folder there is a chance that caching is the root cause https://forums.pentaho.com/threads/207678-Changing-Pentaho-Folder-name-and-Karaf/?p=436862#post436862 Have  ...