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
Dirk Sachse
This individual is no longer active. Application functionality related to this individual is limited.
Contact Details
×
Enter Password
Enter Password
Confirm Password
Dirk Sachse
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 20 of 20 total
search criteria =
ALL
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/ ...
© Hitachi Vantara LLC 2023. All Rights Reserved.
Powered by Higher Logic