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

MonetDB Bulk Loader error with MonetDB Jan 2014-SP2 bugfix release

    Details

    • Type: Improvement
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 5.1.0 GA, 5.2.1.0, 5.3.0 GA
    • Fix Version/s: 5.4.0 GA
    • Component/s: Step
    • Labels:
    • Story Points:
      2
    • PDI Sub-component:
    • 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.
    • Sprint Team:
      Yoda
    • CI Build:
      #1211 23-may-2014 17:01:16
    • Sprint:
      Sprint 4 - 5.4 (Yoda) 2, Sprint 4 - 5.4 (Yoda) 3

      Description

      After upgrading MonetDB to version Jan 2014-SP2 bugfix release, my transformations stopped woking. With the error:
      An error occurred writing data to the MonetDB API (MAPI) process
      Connection to server lost!

      It seems that in the new version of MonetDB comes this change:
      http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d633b25eb73e

      To make it work again I had to adjust MonetDBBulkLoader.java commenting the second attempt to data.out.writeLine( "" ).

      // write an empty line, forces the flush of the stream
      data.out.writeLine( "" );

      // again...
      error = data.in.waitForPrompt();
      if ( error != null )

      { throw new KettleException( "Error loading data: " + error ); }

      // data.out.writeLine( "" );

      // and again, making sure we commit all the records
      // error = data.in.waitForPrompt();
      // if ( error != null )

      { // throw new KettleException( "Error loading data: " + error ); // }

      if ( log.isRowLevel() )

      { logRowlevel( Const.CR ); }

      Juan Carlos

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                gdavid Golda Thomas
                Reporter:
                j__c__ JC
              • Votes:
                5 Vote for this issue
                Watchers:
                19 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: