Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Error serializing row to byte array

  1. #1
    Join Date
    Apr 2008
    Posts
    18

    Default Error serializing row to byte array

    Hi - I downloaded 3.1.0-M2 this am - am having a problem with a dimension lookup/update step.

    The first execution runs fine (inserts all data). I leave that data in the table, and run a second time with the same input data. The second execution is getting an "Error serializing row to byte array" message:

    1st run - normal completion
    2008/06/02 14:09:16 - org.pentaho.di.ui.spoon.trans.TransGraph - Transformation opened.
    2008/06/02 14:09:16 - Spoon - Launching transformation [PopulateTenantDim]...
    2008/06/02 14:09:16 - Spoon - Started the transformation execution.
    2008/06/02 14:09:16 - PopulateTenantDim - Dispatching started for transformation [PopulateTenantDim]
    2008/06/02 14:09:16 - PopulateTenantDim - Nr of arguments detected:0
    2008/06/02 14:09:16 - PopulateTenantDim - This is not a replay transformation
    2008/06/02 14:09:16 - PopulateTenantDim - This transformation can be replayed with replay date: 2008/06/02 14:09:16
    2008/06/02 14:09:16 - PopulateTenantDim - Initialising 4 steps...
    2008/06/02 14:09:16 - Dimension lookup/update.0 - Connected to database...
    2008/06/02 14:09:16 - Join Rows (cartesian product).0 - Starting to run...
    2008/06/02 14:09:16 - Get run_datetime.0 - Starting to run...
    2008/06/02 14:09:16 - Get run_datetime.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2008/06/02 14:09:16 - Get Tenant Data.0 - Starting to run...
    2008/06/02 14:09:16 - Dimension lookup/update.0 - Starting to run...
    2008/06/02 14:09:16 - Get Tenant Data.0 - Finished reading query, closing connection.
    2008/06/02 14:09:16 - Get Tenant Data.0 - Finished processing (I=237, O=0, R=0, W=237, U=0, E=0)
    2008/06/02 14:09:16 - Join Rows (cartesian product).0 - Finished processing (I=0, O=0, R=238, W=237, U=0, E=0)
    2008/06/02 14:09:16 - Dimension lookup/update.0 - Finished processing (I=237, O=237, R=237, W=237, U=0, E=0)
    2008/06/02 14:09:16 - Spoon - The transformation has finished!!
    2nd run - serializing error
    2008/06/02 14:09:41 - org.pentaho.di.ui.spoon.trans.TransGraph - Transformation opened.
    2008/06/02 14:09:41 - Spoon - Launching transformation [PopulateTenantDim]...
    2008/06/02 14:09:41 - Spoon - Started the transformation execution.
    2008/06/02 14:09:41 - PopulateTenantDim - Dispatching started for transformation [PopulateTenantDim]
    2008/06/02 14:09:41 - PopulateTenantDim - Nr of arguments detected:0
    2008/06/02 14:09:41 - PopulateTenantDim - This is not a replay transformation
    2008/06/02 14:09:41 - PopulateTenantDim - This transformation can be replayed with replay date: 2008/06/02 14:09:41
    2008/06/02 14:09:41 - PopulateTenantDim - Initialising 4 steps...
    2008/06/02 14:09:41 - Dimension lookup/update.0 - Connected to database...
    2008/06/02 14:09:41 - Get run_datetime.0 - Starting to run...
    2008/06/02 14:09:41 - Get Tenant Data.0 - Starting to run...
    2008/06/02 14:09:41 - Dimension lookup/update.0 - Starting to run...
    2008/06/02 14:09:41 - Join Rows (cartesian product).0 - Starting to run...
    2008/06/02 14:09:41 - Get run_datetime.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2008/06/02 14:09:41 - Get Tenant Data.0 - Finished reading query, closing connection.
    2008/06/02 14:09:41 - Get Tenant Data.0 - Finished processing (I=237, O=0, R=0, W=237, U=0, E=0)
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : Unexpected error :
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : java.lang.RuntimeException: Error serializing row to byte array
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:735)
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.addToCache(DimensionLookup.java:1026)
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:425)
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:183)
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2444)
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1271)
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : Caused by: java.lang.RuntimeException: tenant_eff_date Date : There was a data type error: the data type of java.lang.String object [2007-09-17 00:00:00] does not correspond to value meta [Date]
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : at org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:2015)
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:442)
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:728)
    2008/06/02 14:09:41 - Dimension lookup/update.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/02 13:57:17) : ... 5 more
    2008/06/02 14:09:41 - Dimension lookup/update.0 - Finished processing (I=1, O=0, R=1, W=0, U=1, E=1)
    2008/06/02 14:09:41 - PopulateTenantDim - Transformation detected one or more steps with errors.
    2008/06/02 14:09:41 - PopulateTenantDim - Transformation is killing the other steps!
    2008/06/02 14:09:41 - Join Rows (cartesian product).0 - Finished processing (I=0, O=0, R=238, W=237, U=0, E=0)
    2008/06/02 14:09:41 - Spoon - The transformation has finished!!


    Is the error mine?
    Thanks for the help,
    Kim
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2008
    Posts
    18

    Default

    oh sorry - am running on Vista with MySql.

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.