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

KettleGenericFileSystemConfigBuilder - NPE when passing invalid parameter value to sftp

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 7.0.0 GA, 7.1.0 GA, Master
    • Fix Version/s: 8.0.0 GA
    • Component/s: Step, Virtual File System (VFS)
    • Labels:
      None
    • Environment:
      8.0-QAT build #132
    • Story Points:
      0
    • 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:
      Tatooine (Maint)
    • Operating System/s:
      Mac OSX El Capitan
    • Steps to Reproduce:
      Hide
      1. Download JDBC driver (ngdbc.jar) from https://pentaho.box.com/v/SAP-HANA-driver and copy it to "data-integration/lib"
      2. Download the attached transformation
      3. Start Spoon and open the transformation
      4. Ensure the connection to the SAP Hana db is working - Go to the "View" tab and edit the "SAP-Hana-Connection". Click on the test button. It should be successful. In case it fails, please check the updated connection info in http://iwiki.pentaho.com/display/QA/Engineering+Test+Databases . Contact EngOps if needed.
      5. Close the Database Connection dialog.
      6. Edit the SAP HANA Bulk Loader step and execute the SQL script.
      7. Run the transformation

      Actual Result
      A NullPointerException is thrown to the logs.

      Expected Result
      Transformation should run successfully.
      NOTE: If you run the same transformation in 6.1.0.1 GA, it runs successfully.

      Show
      Download JDBC driver (ngdbc.jar) from https://pentaho.box.com/v/SAP-HANA-driver and copy it to "data-integration/lib" Download the attached transformation Start Spoon and open the transformation Ensure the connection to the SAP Hana db is working - Go to the "View" tab and edit the "SAP-Hana-Connection". Click on the test button. It should be successful. In case it fails, please check the updated connection info in http://iwiki.pentaho.com/display/QA/Engineering+Test+Databases . Contact EngOps if needed . Close the Database Connection dialog. Edit the SAP HANA Bulk Loader step and execute the SQL script. Run the transformation Actual Result A NullPointerException is thrown to the logs. Expected Result Transformation should run successfully. NOTE: If you run the same transformation in 6.1.0.1 GA, it runs successfully.

      Description

      When configuring the SAP HANA Bulk Loader step to use "Remote Files", it throws a NullPointerException:

      SAP HANA Bulk Loader.0 - HanaBulkDataOutput.open(): remoteDataFile = /home/devuser/saphana/data.csv
java.lang.NullPointerException
	at org.pentaho.di.core.vfs.configuration.KettleGenericFileSystemConfigBuilder.setParameter(KettleGenericFileSystemConfigBuilder.java:129)
	at org.pentaho.di.core.vfs.configuration.KettleSftpFileSystemConfigBuilder.setParameter(KettleSftpFileSystemConfigBuilder.java:121)
	at org.pentaho.di.core.vfs.KettleVFS.buildFsOptions(KettleVFS.java:196)
	at org.pentaho.di.core.vfs.KettleVFS.getFileObject(KettleVFS.java:131)
	at org.pentaho.di.core.vfs.KettleVFS.getFileObject(KettleVFS.java:106)
	at org.pentaho.di.core.vfs.KettleVFS.getOutputStream(KettleVFS.java:318)
	at org.pentaho.di.trans.steps.hanabulkloader.HanaBulkDataOutput.open(SourceFile:94)
	at org.pentaho.di.trans.steps.hanabulkloader.HanaBulkLoader.processRow(SourceFile:239)
	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
	at java.lang.Thread.run(Thread.java:745)

      Full log attached.

      I double-checked and the file exists on that directory.
      Also, if we run this transformation with the same settings in 6.1.0.1 GA, the transformation runs successfully.
      This is throwing a NPE in 7.0.0.0 GA, 7.1.0.0 GA and 8.0-QAT-132.

        PractiTest Integration




          Attachments

            Issue Links

            relates to

            Bug - A problem which impairs or prevents the functions of the product. PDI-15501 SFTP VFS provider does not get/attempt to perform public key authentication

            • Urgent - An issue that causes severe impact in the ability to use Pentaho in a production environment. This issue halts normal business operations and a viable documented workaround is not available.
            • Closed

            Improvement - An improvement or enhancement to an existing feature or task. PDI-16385 Inconsistencies in SAP HANA Bulk Loader step dialog and Documentation

            • Unknown - Priority Unknown or Unassigned
            • Open

              Activity

                People

                Assignee:
                pavel_hrakovich Pavel Hrakovich (Inactive)
                Reporter:
                paula Paula Clemente
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: