Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Error during Dimension Lookup/Update

  1. #1

    Default Error during Dimension Lookup/Update

    I am attempting to update a product dimension table and I am receiving the following error

    These records are being written to a MYSQL 5 database the field type in mysql is varchar.

    2007/11/19 14:48:38 - tr_dm_product - Dispatching started for transformation [tr_dm_product]

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : Unexpected error :

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : java.lang.RuntimeException: Error serializing row to byte array

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:727)

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.addToCache(DimensionLookup.java:1012)

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:338)

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:182)

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1243)

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : Caused by: java.lang.ClassCastException: [B cannot be cast to java.lang.String

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:1932)

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:434)

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:720)

    2007/11/19 14:48:40 - Dimension lookup/update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : ... 4 more

    2007/11/19 14:48:40 - tr_dm_product - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : Errors detected!
    2007/11/19 14:48:41 - Spoon - The transformation has finished!!

    Regards

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Edward, please let us know what the transformation is like.
    Post it as an attachment please.

    Thanks in advance,

    Matt

  3. #3

    Default Attachment

    I have included the transformation as an attachemnt
    Attached Files Attached Files

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Turn off Lazy conversion in the "Table Input" step please. I don't think that Oracle is handling this very graceful at the moment.

    Let me know if that solves the problem.

    Thanks,

    Matt

  5. #5

    Default Still Getting Error

    I turned off the lazy conversion on the Database lookup step and I am still receiving an error.

    The error messaged changed. Here is the new message:

    2007/11/20 14:41:38 - Insert / Update.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : java.lang.ClassCastException:
    java.lang.Double cannot be cast to java.math.BigDecimal

  6. #6
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    I'm suspecting somehow that the problem comes from the Oracle database.
    Can you do a preview on the Table Input step and check to see if anything comes up in the log.
    (repeat then after the database lookup step)

    Thanks,

    Matt

  7. #7
    Join Date
    Nov 1999
    Posts
    459

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.