Profile

Luis Villegas

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 14 of 14 total

RE: Is there a way to prevent PDI from trying to connect to a DB connection when loading a transformation step?

Posted By Luis Villegas 03-29-2021 20:53
Found In Community: Pentaho \ view thread
Almost forgot...on some occasions, if I try clicking on the UI while its loading/frozen, Ill get the following error in the log:   org.eclipse.swt.SWTException: Failed to execute runnable (org.eclipse.swt.SWTException: Widget is disposed)at org.eclipse.swt.SWT.error(Unknown Source)at org.eclipse.swt ...

RE: Is there a way to prevent PDI from trying to connect to a DB connection when loading a transformation step?

Posted By Luis Villegas 03-29-2021 17:50
Found In Community: Pentaho \ view thread
There are no queries in the logs. It happens when attempting to connect to the database, and it doesnt happen for every step, just some.   The most common ones are the Table Output steps and Dimension lookup/update steps. Example: When I open a Dimension Lookup step that points to one of these Databases ...

Is there a way to prevent PDI from trying to connect to a DB connection when loading a transformation step?

Posted By Luis Villegas 03-09-2021 23:04
Found In Community: Pentaho \ view thread
EDIT: This is the same thing as this issue from 2010 thats marked as fixed: https://jira.pentaho.com/browse/PDI-3023         Im on PDI 8.3, and Im connecting to a remote repo.   When working on Transformations, Im using DB connections that cant be accessed locally. This is fine, since I test the ETLs ...

RE: Pentaho 9.1 Scheduler Stops Running Jobs After 10 Runs

Posted By Luis Villegas 11-05-2020 01:16
Found In Community: Pentaho \ view thread
I ended up installing 8.2 onto the same EC2 server (in an adjacent folder in the home directory), and hooked the server up to all the same endpoint connections to the same DB and everything. Pentaho 8.2 ran just fine, and continued the scheduler right where it left off. I watched the Quartz DB and verified ...

RE: Pentaho 9.1 Scheduler Stops Running Jobs After 10 Runs

Posted By Luis Villegas 11-03-2020 17:12
Found In Community: Pentaho \ view thread
I verified that changing the Quartz config to have 50 threads will allow up to 50 jobs to run before needing a restart. Thats only about 2 hours of jobs for us, though.

Pentaho 9.1 Scheduler Stops Running Jobs After 10 Runs

Posted By Luis Villegas 11-03-2020 06:08
Found In Community: Pentaho \ view thread
I have a new Pentaho 9.1 server set up, and I imported all the jobs and transformations from our Pentaho 8.2 repository. I set up the schedules through the browser using the Manage Schedules page, and they seemed to be running fine.   Unfortunately, after 10 jobs have run, the scheduler just stops running ...

RE: Kettle Jobs Won't Run Transformations

Posted By Luis Villegas 09-04-2019 21:39
Found In Community: Pentaho \ view thread
To get it to work, I had to do the following workaround: In PDI, add a new Slave Server. I did this by opening the job Im working on, right click on Slave Server folder on the left hand side and select new. Use the connection details of the Pentaho Repo youre already using Create a new Run Configuration ...

Timezone Wrong on Pentaho 8.3 Server

Posted By Luis Villegas 08-31-2019 00:55
Found In Community: Pentaho \ view thread
TL;DR:   Im not sure if this is config error or a bug, but the timezones on our Pentaho BI server (8.3) arent working as expected. When scheduling a job, I have to select UTC timezone, but use EDT times. For example: My timezone is EDT, and its 7pm. To schedule a job to run 1 minute from now, I have ...

RE: Kettle Jobs Won't Run Transformations

Posted By Luis Villegas 08-23-2019 20:52
Found In Community: Pentaho \ view thread
So I did everything you suggested. I can run the job remotely from the spoon client by using a Run Configuration where for settings I use Slave Server, but the job still cant find the transformation (without any errors) if I choose Pentaho Server for the Run Configuration. It also doesnt successfully ...

RE: Kettle Jobs Won't Run Transformations

Posted By Luis Villegas 08-23-2019 19:15
Found In Community: Pentaho \ view thread
So the slave-server-config.xml is found on the pentaho server in pentaho-server/pentaho-solutions/system/kettle/slave-server-config.xml   For repositories.xml, I know theres one on my local machine that runs Spoon, and one on the pentaho server. Do both need to match? Are both repositories.xml relevant? ...

RE: Kettle Jobs Won't Run Transformations

Posted By Luis Villegas 08-23-2019 18:55
Found In Community: Pentaho \ view thread
Hello Chris,   I have   Repository name: singleDiServerInstance

RE: Kettle Jobs Won't Run Transformations

Posted By Luis Villegas 08-23-2019 16:04
Found In Community: Pentaho \ view thread
I tried different structures, but just to make it simple to test, I have my job and transformation both in the same folder: /public/development   Ive tried using: $(Internal.Entry.Current.Directory)/transformation_name $(Internal.Job.Repository.Directory)/transformation_name /public/development/transformation_name ...

RE: Kettle Jobs Won't Run Transformations

Posted By Luis Villegas 08-22-2019 15:41
Found In Community: Pentaho \ view thread
Just tried it, still didnt work. The log still says:   2019/08/22 15:37:32 - Transformation - Starting job entry 2019/08/22 15:37:32 - Transformation - Opening transformation: [null] in directory [/public/transformations] 2019/08/22 15:37:33 - Transformation - Starting transformation...(file=null, n ...

Kettle Jobs Won't Run Transformations

Posted By Luis Villegas 08-22-2019 02:40
Found In Community: Pentaho \ view thread
Ok, Ive been ripping my hair out with this, and cant find anything anywhere.   Ive got a Pentaho Server (8.3 CE) running on an AWS EC2 server. I have PDI 8.3 on my local computer. I set up a Pentaho Repository on the Pentaho Server.   Ive created a bunch of transformations, and they all run without issue. ...