Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: SCD: Error serializing row to byte array

  1. #1
    Join Date
    Jun 2013
    Posts
    5

    Default SCD: Error serializing row to byte array

    I was having some troubles with the SCD step today.
    My data is in an Oracle DB, all options set correctly (using a sequence for the technical key).

    When I run for the first time the SCD, it caused the following error :

    Code:
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - Changing the type of the technical key from TYPE_BIGNUMBER to an TYPE_INTEGER
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - lookup row : [312079], [2013/02/12 13:49:28.000], [2013/02/12 13:49:28.000]
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) : Unexpected error
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) : java.lang.RuntimeException: Error serializing row to byte array
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) :     at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:848)
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) :     at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.addToCache(DimensionLookup.java:1464)
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) :     at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:449)
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) :     at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:234)
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) :     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) :     at java.lang.Thread.run(Thread.java:722)
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) : Caused by: java.lang.RuntimeException: ACCOUNT_STATUS_ID Integer : There was a data type error: the data type of java.math.BigDecimal object [4] does not correspond to value meta [Integer]
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) :     at org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:2066)
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) :     at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:478)
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) :     at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:841)
    2013/06/12 16:00:37 - Dimension Lookup / Update.0 - ERROR (version 4.4.1-sq, build 1 from 2013-04-24 17.32.10) :     ... 5 more
    The row ACCOUNT_STATUS_ID is defined like that in my Oracle database :
    Code:
    "ACCOUNT_STATUS_ID" NUMBER NOT NULL ENABLE

    I don't know what I can do to fix this transformation problem.

    Thanks in advance for any help,

    Yvan

  2. #2
    Join Date
    Jul 2009
    Posts
    476

    Default

    I think the quickest solution is to change ACCOUNT_STATUS_ID in Oracle from NUMBER to INTEGER, and then try again. If I remember correctly, the NUMBER datatype can have up to 38 digits to the right of the decimal place, so it's not a good datatype to use for anything. NUMBER(x,y) where x is the number of digits, and y is the number of digits to the right of the decimal, is better, but for an SCD step, you really should use INTEGER for the technical key.

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.