Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Follow User Guide of DI to create transformations, but the error happened

  1. #1
    Join Date
    Apr 2014
    Posts
    1

    Default Follow User Guide of DI to create transformations, but the error happened

    2014/04/29 11:07:55 - Getting Started Transformation - Dispatching started for transformation [Getting Started Transformation]2014/04/29 11:07:55 - Write to Database.0 - Connected to database [Sample Data] (commit=1000)2014/04/29 11:07:56 - Read Postal Codes.0 - Opening file: file:///D:/pdi-ce-5.0.1.A-stable/data-integration/samples/transformations/files/Zipssortedbycitystate.csv2014/04/29 11:07:56 - Read Sales Data.0 - Opening file: file:///D:/pdi-ce-5.0.1.A-stable/data-integration/samples/transformations/files/sales_data.csv2014/04/29 11:07:56 - Filter rows.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error2014/04/29 11:07:56 - Filter rows.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/04/29 11:07:56 - Filter rows.0 - Step [Lookup Missing Zips] is invalid as target.2014/04/29 11:07:56 - Filter rows.0 - 2014/04/29 11:07:56 - Filter rows.0 - at org.pentaho.di.trans.steps.filterrows.FilterRows.processRow(FilterRows.java:114)2014/04/29 11:07:56 - Filter rows.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)2014/04/29 11:07:56 - Filter rows.0 - at java.lang.Thread.run(Thread.java:724)2014/04/29 11:07:56 - Filter rows.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)2014/04/29 11:07:56 - Getting Started Transformation - Getting Started Transformation2014/04/29 11:07:56 - Read Sales Data.0 - Finished processing (I=81, O=0, R=0, W=79, U=0, E=0)2014/04/29 11:07:56 - Getting Started Transformation - Getting Started Transformation2014/04/29 11:07:56 - Lookup Missing Zips.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)2014/04/29 11:07:56 - Read Postal Codes.0 - Finished processing (I=104, O=0, R=0, W=102, U=0, E=0)2014/04/29 11:07:56 - Spoon - The transformation has finished!!2014/04/29 11:07:56 - Getting Started Transformation - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected!2014/04/29 11:07:56 - Getting Started Transformation - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected!

  2. #2
    Join Date
    Oct 2010
    Posts
    369

    Default Step [Lookup Missing Zips] is invalid as target

    Step [Lookup Missing Zips] is invalid as target open filter step and click on lookup step drop down to select ur target step

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.