Profile

Sparkles Sparkles

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

Contact Details

My Content

1 to 20 of 20 total

RE: Unexpected error during job metadata load

Posted By Sparkles Sparkles 03-21-2019 13:13
Found In Community: Pentaho \ view thread
That sounds very good the way you describe it. I would like to see if youre able to debug write to log the variable $(Internal.Entry.Current.Directory). Is this used as the path for the other jobs/transformations too? Im sorry Im not able to provide more useful help here, I havent seen your error before. ...

RE: Unexpected error during job metadata load

Posted By Sparkles Sparkles 03-19-2019 18:27
Found In Community: Pentaho \ view thread
When did the error appear? When you added the subjob Workflow? How is the path configured for this subjob? Is it possible to replace that subjob with an empty job that only logs some debug text to log?

RE: Unexpected error during job metadata load

Posted By Sparkles Sparkles 03-18-2019 12:18
Found In Community: Pentaho \ view thread
Remove all steps. Then add first step only. See if it executes without error. Then add 1 more step, incrementally checking for errors. Is it possible to find which step (if any) causes this error?

RE: Cleaning the Pentaho BI Mondrian Cache from PDI

Posted By Sparkles Sparkles 03-07-2019 12:59
Found In Community: Pentaho \ view thread
Yes we have Mysql as the bottom database and Mondrian on top of that. We ended up switching to Tableau using the same Mysql database. Tableau has its own problems, but not with the caching and not seeing newly arrived facts.

RE: Cleaning the Pentaho BI Mondrian Cache from PDI

Posted By Sparkles Sparkles 03-06-2019 14:06
Found In Community: Pentaho \ view thread
We dropped Mondrian years ago because of problems with caching. It became a nightmare to manage, riddled with bugs or unforeseen situations.

RE: How to run a Job using Kettle.bat file?

Posted By Sparkles Sparkles 02-25-2019 13:56
Found In Community: Pentaho \ view thread
I heard some comments version 8.1 got bugs related to variables. Id stay away from that version.

RE: SQL Statement using variables in PDI

Posted By Sparkles Sparkles 02-22-2019 14:42
Found In Community: Pentaho \ view thread
Ok thanks, you are right it doesnt matter with the semi-colon. I guess it doesnt matter to explicitly declare the end when its only a single query. But the double quotes sounds very strange to me. Take this example: SELECT * FROM TEST_TABLE WHERE ID = 1; This query is returning all rows where the String ...

RE: Hello i need populate Oracle table with Oracle Bulk Loader, using Oracle bulk loader i my transformation, but not working with no errors  =[........ it is not possible in version CE ?

Posted By Sparkles Sparkles 02-22-2019 10:49
Found In Community: Pentaho \ view thread
Are you not supposed to give data rows to the oracle step? Where is your data youre trying to insert?

RE: SQL Statement using variables in PDI

Posted By Sparkles Sparkles 02-20-2019 16:04
Found In Community: Pentaho \ view thread
You should make yourself some improved practices when working with SQL. 1) Never use space in names (column names, table names, database names...) And when you ask your question here, you quickly jumped from one example to another. I suggest sticking to one example at the time. In your second example ...

RE: SQL Statement using variables in PDI

Posted By Sparkles Sparkles 02-20-2019 12:21
Found In Community: Pentaho \ view thread
This is a different case? Are you not supposed to finish the sql query with a semi-colon? This query would ONLY return rows IF the variable serial has the value Serial Number.

RE: Copy rows to result behavior

Posted By Sparkles Sparkles 02-20-2019 10:25
Found In Community: Pentaho \ view thread
I have never found any satisfying documentation for the dirty details of result rows. It seems like nobody knows exactly how this works. Only way to find out is test yourself. Thats what I did. What I found was similar to what you describe here. For example if you in a transformation get the result rows ...

RE: SQL Statement using variables in PDI

Posted By Sparkles Sparkles 02-20-2019 10:22
Found In Community: Pentaho \ view thread
Just a couple of notes depending of versions, dialects etc. If I was to reference a column which is the same as a reserved keyword (name), I would encapsulate it like this: `name`. Also if I were to take an equal test like you have in with the where, Id encapsulate it in single or double quotes like ...

RE: Get string from month integer

Posted By Sparkles Sparkles 02-18-2019 15:14
Found In Community: Pentaho \ view thread
Why not do this using SQL instead? I use the date as a variable for this SQL, handled on job level: INSERT INTO DIM_DATE (ID, `YEAR`, `QUARTER`, `MONTH`, `WEEK`, `DAY`, `DATE`, YEAR_NAME, QUARTER_NAME, MONTH_NAME, WEEK_NAME, DAY_NAME) SELECT      $(DIM_DATE) AS ID,      YEAR(from_unixtime($(DIM_DATE))) ...

RE: How to add custom fields to pentaho logging tables

Posted By Sparkles Sparkles 02-14-2019 08:07
Found In Community: Pentaho \ view thread
I thought the default log table (tables?) was made generic for all transformations? Or is it 1 table per transformation? What would your columns be for other transformations, null? Sounds like you need to edit the source code and compile your own version if you want different behavior from the standard ...

RE: Which step use to load data in the fact table with PDI?

Posted By Sparkles Sparkles 02-11-2019 15:17
Found In Community: Pentaho \ view thread
I didnt understand much of that hehe, maybe Im on an older version. I dont have a palette on creation or elsewhere. I go to Design tab next to View tab, that has a list of available steps. When I need to insert rows, I would go to Output-->Table output. There is no lookup in database, but I do find a ...

RE: Which step use to load data in the fact table with PDI?

Posted By Sparkles Sparkles 02-11-2019 11:43
Found In Community: Pentaho \ view thread
Happy you solved it, didnt understand how you solved it but thats less important.

RE: Which step use to load data in the fact table with PDI?

Posted By Sparkles Sparkles 02-10-2019 18:32
Found In Community: Pentaho \ view thread
Populating a fact table should be the same as populating a dimension table? Youre looking for a step that can convert incoming fields into an sql INSERT query? Ive used Table output to populate more than 40 fact tables. Works like a charm. If you need something more fancy, Execute SQL script works good ...

RE: How to determine all levels of parent-child-relationships?

Posted By Sparkles Sparkles 02-01-2019 12:36
Found In Community: Pentaho \ view thread
Since you liked it so much, I made a version for you that will work out of the box. Downgrading java syntax can be quite painful, so I made it ready for you. Steps: 1) Create a new User Defined Java Class step 2) Make sure the previous step produce rows with fields child (String) and parent (String) ...

RE: How to determine all levels of parent-child-relationships?

Posted By Sparkles Sparkles 01-31-2019 16:11
Found In Community: Pentaho \ view thread
This was actually a fun exercise to do in java! I made a simplified version if we can guarantee some rules: Each node can have 0-1 parent Each node can have 0-1 child No circular references Each row includes exactly 1 unique child and 0-1 unique parent If you want multiple to support multiple children ...

RE: How to determine all levels of parent-child-relationships?

Posted By Sparkles Sparkles 01-30-2019 12:25
Found In Community: Pentaho \ view thread
How can E be a root node and be nobodys child when B is explicitly stated as being the parent of E?