Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1554

PDI CS not work in the Pentaho Sever repository

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 1.1.5
    • 1.1.7, 1.2.1
    • None
    • None
    • 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

      Attachments

        Activity

          nbattista89 Nicola added a comment -

          Hi,
          Are there news?

          Thanks,
          Regards.

          nbattista89 Nicola added a comment - Hi, Are there news? Thanks, Regards.
          nbattista89 Nicola added a comment -

          Hi,
          Are there news?

          Thanks,
          Regards.

          nbattista89 Nicola added a comment - Hi, Are there news? Thanks, Regards.
          nbattista89 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!

          nbattista89 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!
          nbattista89 Nicola added a comment -

          Hi,
          Are there news?

          Thanks,
          Regards.

          nbattista89 Nicola added a comment - Hi, Are there news? Thanks, Regards.

          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.

          jens.rowekamp 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.
          nbattista89 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

          nbattista89 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.rowekamp 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

          build 1.1.7 for CentOS
          and builds 1.1.7 for Windows

          elena.kotsinova Elena Kotsinova (Inactive) added a comment - build 1.1.7 for CentOS and builds 1.1.7 for Windows

          People

            elena.kotsinova Elena Kotsinova (Inactive)
            nbattista89 Nicola
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.