Profile

Marc Stroo

Invisi

Contact Details

Invisi

My Content

1 to 16 of 16 total

Where are older versions of PDI?

Posted By Marc Stroo 11-06-2023 13:07
Found In Egroup: Pentaho \ view thread
Because the current 9.4 edition of PDI has removed the option to create a database repository, I want to download an older version for my new client, e.g. 9.3. But how much I look, it is gone. Hitachi only seems to offer the 9.4 version, and on Sourceforge it seems that the PDI (and other Pentaho software) ...

RE: Won't create database repository

Posted By Marc Stroo 10-31-2023 08:35
Found In Community: Pentaho \ view thread
An alternative is to install version 9.3. I am unaware of the differences between 9.3 and 9.4, but for most work the 9.3 version is just fine. This is my last day at the client, so no need to check it anymore here. I will test it on my home development machine later.

RE: Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Marc Stroo 10-31-2023 08:26
Found In Community: Pentaho \ view thread
I wonder if you can arrange it that this is set at the connection level? Then you have to do it only once, instead of at every SELECT query that you have.

RE: Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Marc Stroo 10-31-2023 08:23
Found In Community: Pentaho \ view thread
The transaction isolation level works!

RE: Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Marc Stroo 10-31-2023 08:15
Found In Community: Pentaho \ view thread
I put a WITH (NOLOCK) after each of the 3 tables I use in my query and still it stays idle when I run the query without limiting the number of rows. When I do a top n in the first query part (I start with a WITH section), then it runs. When I do a top 500 it runs more or less instantly. When I do a top ...

RE: Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Marc Stroo 10-30-2023 11:10
Found In Community: Pentaho \ view thread
I try adding a blocking step, changing the output step to a dummy step or even only using the table input step and removing the table output step. In all cases it stays idle. It only helps when I add a top n to the query, like top 20 or top 2000. Then the query runs and finishes. If it ha to do with ...

RE: Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Marc Stroo 10-12-2023 03:43
Found In Community: Pentaho \ view thread
I just notice that turning on that setting of sharing the connection actually causes the issue that writing to the table stops happening. So that surely solves nothing, sadly.

RE: Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Marc Stroo 10-12-2023 03:39
Found In Community: Pentaho \ view thread
Another thing that I notice is that it seems to occur when I am rerunning a transformation that has previously produced some output. One thing I do in the input query is do a LEFT JOIN on the output table. May that also cause some issue? And may that get solved by changing the setting you mention, where ...

RE: Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Marc Stroo 10-12-2023 03:27
Found In Community: Pentaho \ view thread
Thank you for the feedback. I am hesitant to put up an example here, as the client uses home built custom software, so I can spread company secrets by posting a query on their data here. I use a clean PDI 9.4 install and all I do is just table in, table out, no alterations, on my new work laptop provided ...

RE: Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Marc Stroo 10-05-2023 09:16
Found In Community: Pentaho \ view thread
All I do is Table Input to Table Output. The SELECT statement is exactly in the format needed for the INSERT of the output block. So it's the most basic version of extract and load possible.

RE: Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Marc Stroo 09-29-2023 03:59
Found In Community: Pentaho \ view thread
Thank you for the reply with the additional questions. I have the driver mssql-jdbc-12.4.0.jre8. I don't use integrated windows security, but a normal user and password. The integrated security wat giving issues and when I will run it scheduled, I think a normal user works better.

Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Marc Stroo 09-28-2023 02:46
Found In Community: Pentaho \ view thread
At my client with a test of PDI 9.4 CE it often happens that transformations stay at idle. It already happens that when I have the SQL entry open of my table in block, that when I want to close it, it freezes and I have to do a forced close through Windows. This hampers my demonstration to the client ...

Transformation stays idle with SQL Server table source PDY CE 9.4

Posted By Marc Stroo 09-27-2023 09:16
Found In Community: Pentaho \ view thread
At my current client they use SQL Server 2016 as database for both table source and target with PDI 9.4 on Windows. Now when I run some very simple transformations, they stay on idle. Also when closing the SQL editor of the table in step, this won't close and I have to force close it. What is the source ...

RE: Won't create database repository

Posted By Marc Stroo 09-27-2023 09:13
Found In Community: Pentaho \ view thread
When I run your transformation, I get this error: 2023/09/27 15:12:17 - Upgrade.groovy.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error 2023/09/27 15:12:17 - Upgrade.groovy.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) ...

RE: Won't create database repository

Posted By Marc Stroo 09-27-2023 09:04
Found In Community: Pentaho \ view thread
I am using version 9.4, which is the latest version at the time of my download, about a month ago. Thank you for your reply. Does this mean that your transformation is the only way to create repositories from version 9.4 on?

Won't create database repository

Posted By Marc Stroo 09-25-2023 07:27
Found In Community: Pentaho \ view thread
With my current client I try to create a database repository for PDI, on SQL Server 2016. I have added the repository info and created a connection. Then nothing happens and when I try to connect it says I can't. The log gives this message: No repository exists on the specified connection.   To create ...