Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Unknown type 0 specified

  1. #1
    Join Date
    Aug 2011
    Posts
    8

    Exclamation Unknown type 0 specified

    I'm getting following error when running my job via Kitchen. It runs fine when executed manually in Spoon.

    ERROR 18-11 15:01:25,847 - Update task date - Unexpected error
    ERROR 18-11 15:01:25,848 - Update task date - org.pentaho.di.core.exception.KettleValueException:
    SiteTypeID - : Unknown type 0 specified.


    at org.pentaho.di.core.row.ValueMeta.getString(ValueMeta.java:1356)
    at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:194)
    at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:615)
    at org.pentaho.di.trans.steps.update.Update.processRow(Update.java:240)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
    at java.lang.Thread.run(Thread.java:745)
    And the thing is, I'm not using this field here, which is my last step in the transformation.

    Name:  2016-11-18_1315.jpg
Views: 221
Size:  22.2 KB

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Do right-click on that last step and select "Show input fields".
    If no datatype is given for field SiteTypeID you should know what to do.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Aug 2011
    Posts
    8

    Default

    Its String type

    Name:  2016-11-18_1815.jpg
Views: 210
Size:  30.1 KB

  4. #4
    Join Date
    Aug 2011
    Posts
    8

    Default

    But weird as it is - the origin step was showing data step as "-".
    Not sure how this got applied. Setting this as string and then will monitor it next week.
    Thanks.

    Name:  2016-11-18_1819.png
Views: 211
Size:  12.6 KB

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.