Saturday, September 19, 2015

Pentaho Common Errors : Error converting data while looking up value

Error Message

Stream lookup.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Unexpected error
Stream lookup.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
Stream lookup.0 - Error converting data while looking up value
Stream lookup.0 -


Stream lookup.0 - Unexpected conversion error while converting value [prod_id String(15)<binary-string>] to an Integer
Stream lookup.0 - java.lang.String cannot be cast to [B
Stream lookup.0 -
Stream lookup.0 -     at org.pentaho.di.trans.steps.streamlookup.StreamLookup.lookupValues(StreamLookup.java:267)
Stream lookup.0 -     at org.pentaho.di.trans.steps.streamlookup.StreamLookup.processRow(StreamLookup.java:446)
Stream lookup.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
Stream lookup.0 -     at java.lang.Thread.run(Unknown Source)
Stream lookup.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
Stream lookup.0 - Unexpected conversion error while converting value [prod_id String(15)<binary-string>] to an Integer
Stream lookup.0 - java.lang.String cannot be cast to [B
Stream lookup.0 -
Stream lookup.0 -     at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:1783)
Stream lookup.0 -     at org.pentaho.di.core.row.value.ValueMetaBase.convertDataCompatible(ValueMetaBase.java:3581)
Stream lookup.0 -     at org.pentaho.di.trans.steps.streamlookup.StreamLookup.lookupValues(StreamLookup.java:265)
Stream lookup.0 -     ... 3 more
Stream lookup.0 - Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to [B
Stream lookup.0 -     at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:1723)
Stream lookup.0 -     ... 5 more
Stream lookup.0 - Finished processing (I=0, O=0, R=10001, W=0, U=0, E=1)
trf_Demo_Load_CSV_File - Transformation detected one or more steps with errors.
trf_Demo_Load_CSV_File - Transformation is killing the other steps!


Root Cause

Stream lookup - lookup value match error.
Data type not matching for keys to lookup.

Example :
Data types for prod_id and id not matching.



Resolution

Data types for prod_id and id should be matching.

2 comments:

  1. Does your blog have a contact page? I'm having trouble locating it but, I'd like to shoot you an email. I've got some ideas for your blog you might be interested in hearing. Either way, great blog and I look forward to seeing it expand over time. yahoo email login

    ReplyDelete
  2. Accordingly, you ought to take steps to protect the confidentiality of your password. canada mortgage calculator Commercial real estate loans are fairly considered illiquid assets. mortgage payment calculator canada

    ReplyDelete