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 :

for IT the said...

I have read your blog its very attractive and impressive. I like it your blog.

Java Training in Chennai Core Java Training in Chennai Core Java Training in Chennai

Java Online Training Java Online Training JavaEE Training in Chennai Java EE Training in Chennai

Oskar Glauber said...

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

Post a Comment

UA-46724997-1