Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-8751

MonetDB is unavailable after PDI is installed with the installer and an Instaview is created.

    Details

    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      Windows 7

      Description

      Reproduction:

      • Install PDI on Windows 32
      • Use defaults. PDI should start with the Instaview perspective.
      • Create a CSV based Instaview usingour customer-100.txt sample data file.
        Change delimiter to a semicolon (, "get fields", click "ok"

      Error dialog is displayed with "Could not create table: instaview_20121016021800594. Reason: An error occurred: Error occured while trying to connect to the database Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Unable to connect (localhost:50006): Connection refused: connect ".

      I quit spoon, restarted and followed the same Instaview creation. Same result.

        Issue Links

          Activity

          Hide
          rfellows Rob Fellows added a comment -

          Slawo, I suspect this is related to another case that I've been working on that isn't available in the current RC2 build. If you could answer a few questions it would help to determine if what you are seeing is related.

          1. Have you run any previous version of PDI/Instaview before the installed version?
          On the startup of the Instaview plugin, we create a shared connection that the templates make use of. However, before that shared connection was only being created if it did not already exist. By default, that connection was setting the port to connect on to 50000. The new installer is installing it's own version of MonetDB to the pentaho install folder and setting it to run on 50006. So, as you can imagine, if you have run this before the shared connection was created on port 50000 and now that you have run the installer it expects the port to bo 50006 but since we don't overwrite the shared connection if it already exists, then we have a conflict.

          2. if you open the ~/.kettle/shared.xml file and look for the AgileBI connection, do you see the port setting set to 50000?
          there are 2 different xml tags to look at <port>50000</port> and <attribute><code>PORT_NUMBER</code><attribute>50000</attribute></attribute>

          2a. if yes to #2: if you either delete that shared connection from the shared.xml file or or update the port settings to 50006 and restart the application, does it work?

          Assign this case back to me with your answers, please.

          Show
          rfellows Rob Fellows added a comment - Slawo, I suspect this is related to another case that I've been working on that isn't available in the current RC2 build. If you could answer a few questions it would help to determine if what you are seeing is related. 1. Have you run any previous version of PDI/Instaview before the installed version? On the startup of the Instaview plugin, we create a shared connection that the templates make use of. However, before that shared connection was only being created if it did not already exist. By default, that connection was setting the port to connect on to 50000. The new installer is installing it's own version of MonetDB to the pentaho install folder and setting it to run on 50006. So, as you can imagine, if you have run this before the shared connection was created on port 50000 and now that you have run the installer it expects the port to bo 50006 but since we don't overwrite the shared connection if it already exists, then we have a conflict. 2. if you open the ~/.kettle/shared.xml file and look for the AgileBI connection, do you see the port setting set to 50000? there are 2 different xml tags to look at <port>50000</port> and <attribute><code>PORT_NUMBER</code><attribute>50000</attribute></attribute> 2a. if yes to #2: if you either delete that shared connection from the shared.xml file or or update the port settings to 50006 and restart the application, does it work? Assign this case back to me with your answers, please.
          Hide
          schodnicki Slawomir Chodnicki (Inactive) added a comment - - edited

          Hey Rob, here's my answers:

          1. Of Course I have run the nightlies as well as both RCs on that machine
          2. The port is set to 50000 in shared.xml
          2a. Deleted the connection and the problem seems to be gone

          Thanks!

          Show
          schodnicki Slawomir Chodnicki (Inactive) added a comment - - edited Hey Rob, here's my answers: 1. Of Course I have run the nightlies as well as both RCs on that machine 2. The port is set to 50000 in shared.xml 2a. Deleted the connection and the problem seems to be gone Thanks!
          Hide
          rfellows Rob Fellows added a comment -

          this is a duplicate issue - PDI-8765.

          Show
          rfellows Rob Fellows added a comment - this is a duplicate issue - PDI-8765 .
          Hide
          rfellows Rob Fellows added a comment -

          will be available in the 4.8.0-GA RC3 build of the installers

          Show
          rfellows Rob Fellows added a comment - will be available in the 4.8.0-GA RC3 build of the installers
          Hide
          bbruce Brandon Bruce (Inactive) added a comment -

          closed as a dupe

          Show
          bbruce Brandon Bruce (Inactive) added a comment - closed as a dupe

            People

            • Assignee:
              Unassigned
              Reporter:
              sflatley Sean Flatley (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: