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.
3 comments :
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
Great Article Artificial Intelligence Projects
Project Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
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
Post a Comment