Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error with Stream Lookup stepStream Lookup

  1. #1

    Default Error with Stream Lookup stepStream Lookup

    I have 2 tables, The first table has an ID and also the second table has an ID and a corresponding Name to that ID. I want the name to Id replace the in the next step of my transformation... I tried using the stream lookup step but it throws errorsName:  Capture.jpg
Views: 38
Size:  38.6 KBName:  Capture.jpg
Views: 38
Size:  38.6 KB.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    It is impossible to read your image.
    Copy and paste your error message.
    -- Mick --

  3. #3

    Default

    Hi!!!
    Sorry for the inconvenience...


    2016/04/19 16:27:31 - Stream lookup 2.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error
    2016/04/19 16:27:31 - Stream lookup 2.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : java.lang.RuntimeException: Error serializing row to byte array
    2016/04/19 16:27:31 - Stream lookup 2.0 - at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:921)
    2016/04/19 16:27:31 - Stream lookup 2.0 - at org.pentaho.di.trans.steps.streamlookup.StreamLookup.addToCache(StreamLookup.java:350)
    2016/04/19 16:27:31 - Stream lookup 2.0 - at org.pentaho.di.trans.steps.streamlookup.StreamLookup.readLookupValues(StreamLookup.java:214)
    2016/04/19 16:27:31 - Stream lookup 2.0 - at org.pentaho.di.trans.steps.streamlookup.StreamLookup.processRow(StreamLookup.java:416)
    2016/04/19 16:27:31 - Stream lookup 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    2016/04/19 16:27:31 - Stream lookup 2.0 - at java.lang.Thread.run(Thread.java:745)
    2016/04/19 16:27:31 - Stream lookup 2.0 - Caused by: java.lang.RuntimeException: subTypeValue String<binary-string> : There was a data type error: the data type of java.lang.String object [Copper ores] does not correspond to value meta [String<binary-string>]
    2016/04/19 16:27:31 - Stream lookup 2.0 - at org.pentaho.di.core.row.value.ValueMetaBase.writeData(ValueMetaBase.java:2326)
    2016/04/19 16:27:31 - Stream lookup 2.0 - at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:532)
    2016/04/19 16:27:31 - Stream lookup 2.0 - at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:914)
    2016/04/19 16:27:31 - Stream lookup 2.0 - ... 5 mor

    Thnx in advance
    Shreyas

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.