Pentaho Server : Single VM on vmware.
MariaDB Columnstore 1.1.5 Architecture (under Vmware) :
2 Um and 3 Pm with Oracle Linux 7.5.
Description
Hi,
I try to save the pdi transformation on the pentaho server repository but failed and in the pentaho server logs not founding errors.
The output error is : Please contact your administrator for assistance.
Outside the repository (under filesystem), the transformation is saved correctly.
I use the Pentaho Server 8.1 CE and PDI CE (kettle) 8.1.
Thanks,
Regards.
Nicola Battista
Thanks Nicola for reporting this, you might update the MCOL-1554 case with the above information. Thank you!
Nicola
added a comment - Hi,
I've opened a ticket jira at Pentaho:
https://jira.pentaho.com/browse/PDI-17599?page=com.atlassian.jira.plugin.system.issuetabpanels%3Aall-tabpanel
This is the answer :
jbleuel Jens Bleuel made changes - Yesterday
Closing as Won't fix, this is an issue of the MariaDB developed ColumnStore - Pentaho Data Integration - Data Adapter:
https://mariadb.com/kb/en/library/columnstore-streaming-data-adapters/#columnstore-pentaho-data-integration-data-adapter
Looks like they have issues with (or have not implemented) the saveRep() loadRep() methods, see "Serialize Step Settings":
https://help.pentaho.com/Documentation/8.1/Developer_Center/PDI/Extend/000
Thanks Nicola for reporting this, you might update the MCOL-1554 case with the above information. Thank you!
Nicola sorry for the delay, there is a lot going on here.
Thank you for all your effort and contact with Pentaho.
I'll try to patch it in for our ColumnStore 1.2.2 GA release.
Jens Röwekamp (Inactive)
added a comment - Hi,
Nicola sorry for the delay, there is a lot going on here.
Thank you for all your effort and contact with Pentaho.
I'll try to patch it in for our ColumnStore 1.2.2 GA release.
Hi Jens,
Thank you very much for the support.
We really need these features to develop our ETLs and as a result the patch will be released first and we could use MariaDB Columnstore as the Data Warehouse / Bigdata system for production.
Best Regards.
Nicola Battista
Nicola
added a comment - Hi Jens,
Thank you very much for the support.
We really need these features to develop our ETLs and as a result the patch will be released first and we could use MariaDB Columnstore as the Data Warehouse / Bigdata system for production.
Best Regards.
Nicola Battista
Updated the routines to save and load from Pentaho server repository.
Tested the develop branch with PDI 8.1 and 7 and Pentaho Server 8.1, as well as the transaction execution from the server side. (Operating system Windows 10)
For QA:
Build the plugin or get it from buildbot
Install the plugin in PDI 7 and 8.1 and Pentaho Server 8.1 (pentaho-server\pentaho-solutions\system\kettle\plugins)
Start PDI and connect to the pentaho server
Create some sample transformations and save them on the server
Execute the sample transactions from the server
Download the sample transactions from the server (via http fronted) and open them in PDI from the file system
Jens Röwekamp (Inactive)
added a comment - Updated the routines to save and load from Pentaho server repository.
Tested the develop branch with PDI 8.1 and 7 and Pentaho Server 8.1, as well as the transaction execution from the server side. (Operating system Windows 10)
For QA:
Build the plugin or get it from buildbot
Install the plugin in PDI 7 and 8.1 and Pentaho Server 8.1 (pentaho-server\pentaho-solutions\system\kettle\plugins)
Start PDI and connect to the pentaho server
Create some sample transformations and save them on the server
Execute the sample transactions from the server
Download the sample transactions from the server (via http fronted) and open them in PDI from the file system
Hi,
Are there news?
Thanks,
Regards.