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) | 4 years ago
  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 | 4 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 | 4 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
  6. 0

    Executing a transformation created under 3.0.4 with 3.1.0M2 returns an exception (see below). Executing the same transformation with 3.0.4 did not throw that exception. The exception is thrown at a database lookup component From the error message it seems obvious that the two types are equal. 'AF' is the first value for country_key read from the set of new values >>>>>>>>>>>>>>>>>>>> Unexpected error : 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : java.lang.RuntimeException: Error serializing row to byte array 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:735) 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : at org.pentaho.di.trans.steps.streamlookup.StreamLookup.addToCache(StreamLookup.java:329) 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : at org.pentaho.di.trans.steps.streamlookup.StreamLookup.readLookupValues(StreamLookup.java:193) 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : at org.pentaho.di.trans.steps.streamlookup.StreamLookup.processRow(StreamLookup.java:396) 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2444) 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : at org.pentaho.di.trans.steps.streamlookup.StreamLookup.run(StreamLookup.java:500) 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : Caused by: java.lang.RuntimeException: country_key String(50)<binary-string> : There was a data type error: the data type of java.lang.String object [AF] does not correspond to value meta [String(50)<binary-string>] 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : at org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:2015) 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:442) 2008/08/12 12:11:05 - lookup current entry.0 - ERROR (version 3.1.0-M2, build 709 from 2008/08/12 11:37:56) : at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:728)

    Pentaho BI Platform Tracking | 8 years ago | Michal Riedmueller
    java.lang.RuntimeException: Error serializing row to byte array

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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