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.
Pentaho Kettle Data Integration Installation for Windows, Pentaho Data Integration ( PDI ) - Generic Design Guidelines
Subscribe to:
Post Comments (Atom)
-
This step can be used to perform various types of aggregations such as sum, average, min, max e.t.c. Input data always need to be sorted for...
-
The Get Filenames step allows you to retrieve information associated with filenames in the file system. The obtained file name is added to ...
-
Error Message Error connecting to database [ORA_TEST_JDBC] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while tr...
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
ReplyDeleteAccordingly, 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