Profile

Dirk Sachse

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: Weird behaviour of Database Value Lookup and Views

Posted By Dirk Sachse 02-20-2020 08:08
Found In Community: Pentaho \ view thread
The problem was an incomplete ORDER BY within a view. The SQL engine gave a different result after every run.

Weird behaviour of Database Value Lookup and Views

Posted By Dirk Sachse 02-18-2020 18:59
Found In Community: Pentaho \ view thread
I m using the Database Value Lookup step on a View in MS SQL Server. The step returns incorrect values in certain records. If I reproduce the query in SQL, everything is fine. I m comparing 4 fields, 2 of which are date values, where I try to find a matching record. Also the results are never the same. ...

SAIKU 3.17 on Pentaho 8.2 -> Save Files doesnt show folders

Posted By Dirk Sachse 10-30-2019 12:59
Found In Community: Pentaho \ view thread
If I want to save a SAIKU report, I dont see any subfolders.   This issue has been reported in this jira ticket: https://jira.pentaho.com/browse/BISERVER-13666   The problem still exists in Pentaho 8.2 and SAIKU 3.17.   Is anyone else having this behavior? #ReportingandAnalytics #Pentaho

RE: How do I pass a parameter in an URL?

Posted By Dirk Sachse 09-17-2019 07:39
Found In Community: Pentaho \ view thread
I found the solution. You have to use POST instead of GET when using parameters.   Like this:   wget --no-proxy http://cluster:cluser@127.0.0.1:8081/kettle/executeJob/?job=/opt/pentaho/INSERT_VALUTA.kjb --post-data VALUTA_DATE=2019-09-01

How do I pass a parameter in an URL?

Posted By Dirk Sachse 09-11-2019 14:01
Found In Community: Pentaho \ view thread
Hi,   I need to pass a parameter via an url.   This URL is working:   http://cluster:cluser@127.0.0.1:8081/kettle/executeJob/?job=/opt/pentaho/INSERT_VALUTA.kjb   The job gets executed. But now I need to pass a parameter. The parameter name is: VALUTA_DATE The value is like this: 2019-09-01   How do ...

RE: Truncate table in Table Output step

Posted By Dirk Sachse 07-08-2019 05:01
Found In Community: Pentaho \ view thread
I did some testing and I monitored the database server and I saw that Pentaho does a transaction rollback if there is a failure. So it first truncates the table, but reverts it when an insert fails.

Truncate table in Table Output step

Posted By Dirk Sachse 06-27-2019 14:25
Found In Community: Pentaho \ view thread
How does Truncate table in the Table Output step work?  The documentation says:  Select if you want the table to be truncated before the first row is inserted into the table If I interpret that correctly, the table should be truncated before a row is inserted. Now what happens if the insert fails?  From ...

RE: pdi-osgi-bridge-activator NullPointerException

Posted By Dirk Sachse 06-19-2019 14:14
Found In Community: Pentaho \ view thread
java version 1.8.0_144 Java(TM) SE Runtime Environment (build 1.8.0_144-b01)Java HotSpot(TM) 64-Bit Server VM (build 25.144-b01, mixed mode)

pdi-osgi-bridge-activator NullPointerException

Posted By Dirk Sachse 06-17-2019 15:05
Found In Community: Pentaho \ view thread
Hi, I just set up a fresh pentaho BI Server and I get this error in catalina.out: ERROR: Bundle pdi-osgi-bridge-activator [184] Error starting mvn:pentaho/pdi-osgi-bridge-activator/8.2.0.0-342 (org.osgi.framework.BundleException: Activator start error in bundle pdi-osgi-bridge-activator [184].)java. ...

RE: pentaho server 8 running scheduled jobs twice

Posted By Dirk Sachse 05-31-2019 13:50
Found In Community: Pentaho \ view thread
Sorry, I forgot: Pentaho 8.2.0.0.342 That behaviour is 100% reproducible right now.

RE: pentaho server 8 running scheduled jobs twice

Posted By Dirk Sachse 05-31-2019 13:45
Found In Community: Pentaho \ view thread
Hello Sergio Ribeiro, I am using CentOS 7. CentOS Linux release 7.5.1804 (Core) NAME=CentOS LinuxVERSION=7 (Core)ID=centosID_LIKE=rhel fedoraVERSION_ID=7PRETTY_NAME=CentOS Linux 7 (Core)ANSI_COLOR=31CPE_NAME=cpe:/o:centos:centos:7HOME_URL= https://www.centos.org/BUG_REPORT_URL= https://bugs.centos.org/ ...

RE: pentaho server 8 running scheduled jobs twice

Posted By Dirk Sachse 05-31-2019 11:39
Found In Community: Pentaho \ view thread
I have the exact same problem. It does only happen when I use the execute now button. The jobs run within 16 seconds apart. This must be a bug. Has anyone an idea on how do deal with it?

RE: Unhide files in PUC?

Posted By Dirk Sachse 04-05-2019 14:27
Found In Community: Pentaho \ view thread
I guess I ran into this problem: https://jira.pentaho.com/browse/BISERVER-13785

Unhide files in PUC?

Posted By Dirk Sachse 04-05-2019 13:57
Found In Community: Pentaho \ view thread
I have a file in a folder, and the file is hidden. If I am logged in as admin I click on View -> Show Hidden Files. If I log in as a different user, I dont see that option in the View menu. As an admin user, I could click on the properties of a file and untag Hidden. But if I do that, I get an error: ...

Uploading files via REST API

Posted By Dirk Sachse 02-27-2019 15:55
Found In Community: Pentaho \ view thread
Hi, I would like to upload files via the REST API and I m not sure if it even works. The documentation says: repo/files/(pathId ) PUT Creates a new file with the provided contents at a given path. Example Request: PUT pentaho/api/repo/files/:jmeter-test:test_file_1.xml PUT data: 1 This PUT body does ...

Replace Number (0) with NULL

Posted By Dirk Sachse 02-19-2019 13:00
Found In Community: Pentaho \ view thread
How do I replace a number (like 0) with NULL in PDI 8.2. I was thinking something like Replace in String. I would like to not do it with a Java Script step if possible. Thanks! #Kettle #PentahoDataIntegrationPDI #Pentaho

RE: How do I delete scheduler jobs via REST API?

Posted By Dirk Sachse 02-18-2019 09:40
Found In Community: Pentaho \ view thread
You have to restart the server to see the changes. This is before the restart: REST call: curl -H Accept: application/json --noproxy * -k -s --basic -u admin:password -X GET http://localhost:8080/pentaho/api/scheduler/getJobs | jq .job[] | .jobId Response: admin\tCBS_2_DWH_001\t52ca3816-3136-11e9-a0df-54ee75cd09eb ...

How do I delete scheduler jobs via REST API?

Posted By Dirk Sachse 02-15-2019 15:59
Found In Community: Pentaho \ view thread
This is how I get a list of all scheduled jobs: curl -H Accept: application/json --noproxy * -k -s --basic -u admin:password -X GET http://localhost:8080/pentaho/api/scheduler/getJobs | jq .job | grep jobId Output looks like this:     jobId: admin\tCBS_2_DWH_001\t52ca3816-3136-11e9-a0df-54ee75cd09eb, ...

RE: How do I get a list of directories and files via the REST API?

Posted By Dirk Sachse 02-15-2019 15:44
Found In Community: Pentaho \ view thread
Hi, I had a few things wrong, but I got it worked out. Like this: curl -s -u admin:password -X PUT -H Content-Type: text/plain --data xxxxx http://localhost:8080/pentaho/api/repo/files/delete

How do I get a list of directories and files via the REST API?

Posted By Dirk Sachse 02-15-2019 09:23
Found In Community: Pentaho \ view thread
Hi, I would like to remove files and directories via the REST API. I think I got a basic understanding of how to do it, but I m not sure what I am doing wrong. This is my API call: curl -H Accept: application/xml  -s --noproxy * -k -s  --basic -u admin:password  -X GET http://localhost:8080/pentaho/ ...