Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: PDI 7.1.0 - Execute shell script for each input row - Fails if no rows passed

  1. #1
    Join Date
    Aug 2011
    Posts
    236

    Default PDI 7.1.0 - Execute shell script for each input row - Fails if no rows passed

    Hi,

    Testing migrating to PDI 7.1.0. I have a process as below.

    Name:  foreach.JPG
Views: 195
Size:  17.9 KB

    The first transformation copies rows to results and the second 'executes for every input row' and I have 'Copy previous results to args' checked.

    If there are no rows sent - version 7.0.0 it works fine, but in 7.1.0 it fails with 'null point exception'.

    jira_get_changelog.sh - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unexpected error running shell [/home/etl/datascience/etl/scripts/jira_get_changelog.sh] : java.lang.NullPointerException

    Anyone else come across this? If so, any solution?

    Thanks,
    PDI 8.0.0
    MySQL - 5.6.27
    Redshift - 1.0.1485
    PostgreSQL 8.0.2
    OS - Ubuntu 10.04.2

  2. #2
    Join Date
    Aug 2011
    Posts
    236

    Default

    Hi,

    Solution found (for me at least) - I just moved the Execute shell script into the transformation (changed to 'execute process')

    Just in case someone else encounters the same issue.

    Thanks.
    PDI 8.0.0
    MySQL - 5.6.27
    Redshift - 1.0.1485
    PostgreSQL 8.0.2
    OS - Ubuntu 10.04.2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.