Profile

Juan Sierra Pons

Juan Sierra Pons

Contact Details

Juan Sierra Pons

My Content

1 to 20 of 40 total

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

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-25-2022 02:19
Found In Egroup: Pentaho \ view thread
I don't think it is a good practice putting  your code inside Pentaho's installation folder Create your folder outside the Pentaho installation folder and try from scratch from there ------------------------------ Juan Sierra Pons Systems Engineer Juan Sierra Pons ------------------------------

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-25-2022 01:06
Found In Egroup: Pentaho \ view thread
I think it is not normal that both are set as default true Can you please check that you have read/write permissions on both folders? KTR_KJB_WORKOUTS KTR_KJB I would rename repository.xml to repository.xml and create a new one from scratch in your /home/logesh/kettle_test as it looks like ...

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-24-2022 08:20
Found In Egroup: Pentaho \ view thread
Can you share your repositories.xml removing any sensitive data (if any) ------------------------------ Juan Sierra Pons Systems Engineer Juan Sierra Pons ------------------------------

RE: HOW TO decode CDATA block from Carte's API reply?

Posted By Juan Sierra Pons 11-16-2022 04:56
Found In Egroup: Pentaho \ view thread
Attaboy! @Petr Prochazka thanks for your time and sharing your knowledge echo H4sIAAAAAAAAADMyMDTRNzTUNzRXMDC3MjS2MjJQ0FVIKc3NrYzPyk8CsoNLEotKFPLTFEDc1IrU5NKSzPw8Xi4j4nRm5qUrpOaVFFUqRLuE+vpGxhKj0y0zL7M4IzUFYieybgWNotTi0pwS2+iSotLUWE1iTPNCdrhCGtRsXi4AOMIbLPwAAAA= |base64 -d | gunzip 2014/11/17 07:13:20 ...

HOW TO decode CDATA block from Carte's API reply?

Posted By Juan Sierra Pons 11-16-2022 03:41
Found In Egroup: Pentaho \ view thread
Hi, I am requesting data to Carte's API and I cannot decode the /jobstatus/logging_string XPATH It looks like this: xmllint.exe popo.xml -xpath /jobstatus/logging_string |head An example can be found here Developer center Hitachi Vantara Lumada and Pentaho Documentation remove preview ...

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

Posted By Juan Sierra Pons 11-03-2022 04:38
Found In Community: Pentaho \ view thread
@Alan Hope The -L can be used with curl to allow curl to follow 302 redirections -L, --location (HTTP) If the server reports that the requested page has moved to a different location (indicated with a Location: header and a 3XX response code), this option will make curl redo the request on the new place. ...

Jetty version from PDI 9.3 and CVE-2020-27216

Posted By Juan Sierra Pons 10-31-2022 03:39
Found In Egroup: Pentaho \ view thread
Hi I have been recently aware of this CVE-2020-27216: CVE-2020-27216 Detail Current Description In Eclipse Jetty versions 1.0 thru 9.4.32.v20200930, 10.0.0.alpha1 thru 10.0.0.beta2, and 11.0.0.alpha1 thru 11.0.0.beta2O, on Unix like systems, the system's temporary directory is shared between all ...

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

Posted By Juan Sierra Pons 10-11-2022 06:15
Found In Egroup: Pentaho \ view thread
By using the SpoonConsole.bat instead I can get more logs: 2022/10/11 12:09:36 - Get a file with FTPS - Start of FTPS job entry 2022/10/11 12:09:36 - Get a file with FTPS - Opened FTPS connection to server [SERVER.com] 2022/10/11 12:09:36 - Get a file with FTPS - set passive FTPS connection mode 2022/10/11 ...

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

Posted By Juan Sierra Pons 10-11-2022 03:49
Found In Egroup: Pentaho \ view thread
I think this issue could be related with the SSL/TLS certificate as it is expired :( I have imported using keytool the expired certificate just in case with no luck. Filezilla client show a warning related the expired SSL/TLS certificate but allows you to ignore it and continue Any Idea how to bypass ...