Search Options
Skip to main content (Press Enter).
Sign In
Skip auxiliary navigation (Press Enter).
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Communities
General Discussion
My Communities
Explore All Communities
Products
Solutions
Services
Developers
Champions Corner
Customer Stories
Insights
Customer Advocacy Program
Badge Challenges
Resources
Resource Library
Hitachi University
Product Documentation
Product Downloads
Partners Portal
How To
Get Started
Earn Points and Badges
FAQs
Start a Discussion
Profile
My Contributions
List of Contributions
Profile
Luis Villegas
This individual is no longer active. Application functionality related to this individual is limited.
Contact Details
×
Enter Password
Enter Password
Confirm Password
Luis Villegas
This individual is no longer active. Application functionality related to this individual is limited.
Profile
Connections
Contacts
Contributions
Badges
List of Contributions
My Content
1 to 14 of 14 total
search criteria =
ALL
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. ...
© Hitachi Vantara LLC 2023. All Rights Reserved.
Powered by Higher Logic