java.lang.RuntimeException: xidlist String : There was a data type error: the data type of java.lang.StringBuilder object ["xid","xid","xid","xid","xid","xid","xid","xid","xid","xid"] does not correspond to value meta [String]

Pentaho BI Platform Tracking | Dan Keeley (codek) | 5 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    {noformat} 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : Unexpected error 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : java.lang.RuntimeException: xidlist String : There was a data type error: the data type of java.lang.StringBuilder object ["xid","xid","xid","xid","xid","xid","xid","xid","xid","xid"] does not correspond to value meta [String] 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:2066) 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:478) 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at org.pentaho.di.trans.steps.joinrows.JoinRows.cacheInputRow(JoinRows.java:417) 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at org.pentaho.di.trans.steps.joinrows.JoinRows.processRow(JoinRows.java:281) 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at java.lang.Thread.run(Thread.java:662) {noformat}

    Pentaho BI Platform Tracking | 5 years ago | Dan Keeley (codek)
    java.lang.RuntimeException: xidlist String : There was a data type error: the data type of java.lang.StringBuilder object ["xid","xid","xid","xid","xid","xid","xid","xid","xid","xid"] does not correspond to value meta [String]
  2. 0

    {noformat} 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : Unexpected error 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : java.lang.RuntimeException: xidlist String : There was a data type error: the data type of java.lang.StringBuilder object ["xid","xid","xid","xid","xid","xid","xid","xid","xid","xid"] does not correspond to value meta [String] 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:2066) 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:478) 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at org.pentaho.di.trans.steps.joinrows.JoinRows.cacheInputRow(JoinRows.java:417) 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at org.pentaho.di.trans.steps.joinrows.JoinRows.processRow(JoinRows.java:281) 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/08/15 09:47:47 - Join Rows (cartesian product).0 - ERROR (version 4.3.0, build 1 from 2012-02-28 07.19.40 by buildguy) : at java.lang.Thread.run(Thread.java:662) {noformat}

    Pentaho BI Platform Tracking | 5 years ago | Dan Keeley (codek)
    java.lang.RuntimeException: xidlist String : There was a data type error: the data type of java.lang.StringBuilder object ["xid","xid","xid","xid","xid","xid","xid","xid","xid","xid"] does not correspond to value meta [String]
  3. 0

    Reproduction: 1. Run the attached DDL in MySQL to create the dimension table. 2. Open the attached transformation with Spoon and make sure the database connection that is used can connect to the database used in step 1. 3. Run the transformation. It should work as the table is empty. 4. Change the value of the "data_field" in the "Generate Rows" step. 5. Run the transformation. It should fail with: Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : Unexpected error Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : java.lang.RuntimeException: Error serializing row to byte array Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:848) Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.addToCache(DimensionLookup.java:1408) Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:622) Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:232) Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/06/06 13:17:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/06/06 13:17:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : Caused by: java.lang.RuntimeException: version String(20) : There was a data type error: the data type of java.lang.Long object [1] does not correspond to value meta [String(20)] 2012/06/06 13:17:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:2066) 2012/06/06 13:17:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:478) 2012/06/06 13:17:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:841)

    Pentaho BI Platform Tracking | 5 years ago | Sean Flatley
    java.lang.RuntimeException: Error serializing row to byte array
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Reproduction: 1. Run the attached DDL in MySQL to create the dimension table. 2. Open the attached transformation with Spoon and make sure the database connection that is used can connect to the database used in step 1. 3. Run the transformation. It should work as the table is empty. 4. Change the value of the "data_field" in the "Generate Rows" step. 5. Run the transformation. It should fail with: Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : Unexpected error Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : java.lang.RuntimeException: Error serializing row to byte array Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:848) Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.addToCache(DimensionLookup.java:1408) Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:622) Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:232) Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/06/06 13:17:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/06/06 13:17:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : Caused by: java.lang.RuntimeException: version String(20) : There was a data type error: the data type of java.lang.Long object [1] does not correspond to value meta [String(20)] 2012/06/06 13:17:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:2066) 2012/06/06 13:17:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:478) 2012/06/06 13:17:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-GA, build 16750 from 2012-04-16 11.52.34 by buildguy) : at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:841)

    Pentaho BI Platform Tracking | 5 years ago | Sean Flatley
    java.lang.RuntimeException: Error serializing row to byte array

    Root Cause Analysis

    1. java.lang.RuntimeException

      xidlist String : There was a data type error: the data type of java.lang.StringBuilder object ["xid","xid","xid","xid","xid","xid","xid","xid","xid","xid"] does not correspond to value meta [String]

      at org.pentaho.di.core.row.ValueMeta.writeData()
    2. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:2066)
      2. org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:478)
      3. org.pentaho.di.trans.steps.joinrows.JoinRows.cacheInputRow(JoinRows.java:417)
      4. org.pentaho.di.trans.steps.joinrows.JoinRows.processRow(JoinRows.java:281)
      5. org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      5 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame