Profile

Petr Prochazka

P.V.A. systems s.r.o.

Contact Details

P.V.A. systems s.r.o.

My Content

1 to 20 of 50+ total
Posted By Petr Prochazka 02-23-2024 08:48
Found In Egroup: Pentaho
\ view thread
OK, you run external Python via Shell job entry. I don't known Python too deep, so I can not help you with this problem. IMHO script doesn't work correctly. You can try run from command line this: C:\Program Files\Pentaho Server\pentaho-server\tomcat\bin>python "D:\KN_BI_MASTER\Pentaho_pipelines_e_scripts\1. ...
Posted By Petr Prochazka 02-23-2024 06:58
Found In Egroup: Pentaho
\ view thread
OK, could you provide full stack trace of exception? Excel file is loaded from Python script, right? ------------------------------ Petr Prochazka Systems Engineer P.V.A. systems s.r.o. ------------------------------
Posted By Petr Prochazka 02-23-2024 06:57
Found In Egroup: Pentaho
\ view thread
HI @Praveen Shibu, this is interesting exception: 2024-02-23 01:14:53,413 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] could not get database metadata java.sql.SQLException: Access denied for user 'hibuser'@'127.0.0.1' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ...
Posted By Petr Prochazka 02-23-2024 05:31
Found In Egroup: Pentaho
\ view thread
Hi, JAR is available here. ------------------------------ Petr Prochazka Systems Engineer P.V.A. systems s.r.o. ------------------------------
Posted By Petr Prochazka 02-23-2024 05:19
Found In Community: Pentaho
\ view thread
IMHO this depends on used JRE, not modified trans files. I have experience that when changed JRE version, after sometimes cache is broken.
Posted By Petr Prochazka 02-23-2024 05:19
Found In Egroup: Pentaho
\ view thread
Hi Lucas, how is start server, as windows service or standalone via bat file? IMHO it's account permission to remote disk drive. ------------------------------ Petr Prochazka Systems Engineer P.V.A. systems s.r.o. ------------------------------
Posted By Petr Prochazka 02-23-2024 05:16
Found In Egroup: Pentaho
\ view thread
Hi Laroy, IMHO this depends on used JDBC driver. I checked in v9.4 MariaDB driver v3.1.4 and tables are sorted. ------------------------------ Petr Prochazka Systems Engineer P.V.A. systems s.r.o. ------------------------------
Posted By Petr Prochazka 02-23-2024 05:05
Found In Community: Pentaho
\ view thread
Hi Stefan, logging setttings is in trans/job properties dialog. In tab Logging select type of logging and fill required parameters. And click on SQL button below.
Posted By Petr Prochazka 02-22-2024 06:04
Found In Egroup: Pentaho
\ view thread
Hi Praveen, there are two things which can raise this exception. Bad configuration or kar is not compatible with CE server. But could you provide clean logs after start? Timestamps in log are strange. And pls attach catalina.log and pentaho.log too. ------------------------------ Petr Prochazka ...
Posted By Petr Prochazka 02-20-2024 06:25
Found In Egroup: Pentaho
\ view thread
HI @Praveen Shibu, pls provide full stack trace of exception. ------------------------------ Petr Prochazka Systems Engineer P.V.A. systems s.r.o. ------------------------------
Posted By Petr Prochazka 02-19-2024 05:08
Found In Community: Pentaho
\ view thread
Hi Leo, I don't known how is behaviour of OSGi when you delete any his files when is running. But if you run PDI on Windows, files can be locked by running process. data-1 means first instance of OSGi in PDI. If you run PDI twice then is created data-2 directory with cache for second instance. So if ...
Posted By Petr Prochazka 02-17-2024 17:53
Found In Community: Pentaho
\ view thread
You can delete all data-n directories, if server is stopped.
Posted By Petr Prochazka 02-16-2024 15:49
Found In Community: Pentaho
\ view thread
Hi Leo, try delete OSGi cache. Delete directory karaf/caches in system directory.
Posted By Petr Prochazka 02-13-2024 11:33
Found In Egroup: Pentaho
\ view thread
Teradata JDBC driver logs to standard output with enabled logging, info is here. So try check logs/spoon.log file for more details. ------------------------------ Petr Prochazka Systems Engineer P.V.A. systems s.r.o. ------------------------------
Posted By Petr Prochazka 02-13-2024 03:01
Found In Egroup: Pentaho
\ view thread
Hi Andy, this depends on specific JDBC driver. What vendor and version is it? ------------------------------ Petr Prochazka Systems Engineer P.V.A. systems s.r.o. ------------------------------
Posted By Petr Prochazka 02-12-2024 12:41
Found In Community: Pentaho
\ view thread
Hi Frank, IMHO problem is Java 17. This version is not supported by PDI v9.4. Supported versions are Java 1.8 or Java 11. And pls provide full stack trace of error, where is exception is raised. Add Karaf, this can relate with previous part.
Posted By Petr Prochazka 02-09-2024 10:06
Found In Community: Pentaho
\ view thread
Or you can use first query with another parameters, use step Table input.
Posted By Petr Prochazka 02-09-2024 10:02
Found In Community: Pentaho
\ view thread
Yes of course. :-) You can use this steps. Group by - require rows sorted by group fields Memory group by - consume all rows, after push rows by group fields with aggregations.
Posted By Petr Prochazka 02-09-2024 08:34
Found In Community: Pentaho
\ view thread
But results of 2 queries are not same. First query all token_id and group by origin_contract_id, but second call for every token_id and returns row(s). IMHO if you group by all rows after join by origin_contract_id, you get expected values as first query.
Posted By Petr Prochazka 02-09-2024 08:10
Found In Community: Pentaho
\ view thread
Hi @Alejandro Ramos Alvarez, how is grouped by code?Could you post screen of result and what you expected? How is set join step? And be careful, Database Join step returns only first row of result set. My fault, it's another step.