Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-11353

Dimension Lookup/Update Step Fails with MySQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 5.0.1 GA, 5.0.6 GA, 5.1.0 GA
    • Fix Version/s: 5.3.0 GA
    • Component/s: Step
    • Labels:
      None
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      2014/08/28 10:27:05 - Dimension lookup/update.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Unexpected error
      2014/08/28 10:27:05 - Dimension lookup/update.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : java.lang.RuntimeException: Error serializing row to byte array
      2014/08/28 10:27:05 - Dimension lookup/update.0 - at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:948)
      2014/08/28 10:27:05 - Dimension lookup/update.0 - at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.addToCache(DimensionLookup.java:1507)
      2014/08/28 10:27:05 - Dimension lookup/update.0 - at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:691)
      2014/08/28 10:27:05 - Dimension lookup/update.0 - at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:220)
      2014/08/28 10:27:05 - Dimension lookup/update.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      2014/08/28 10:27:05 - Dimension lookup/update.0 - at java.lang.Thread.run(Thread.java:745)
      2014/08/28 10:27:05 - Dimension lookup/update.0 - Caused by: java.lang.RuntimeException: date_from Timestamp : There was a data type error: the data type of java.util.Date object [Mon Jan 01 00:00:00 EST 1900] does not correspond to value meta [Timestamp]
      2014/08/28 10:27:05 - Dimension lookup/update.0 - at org.pentaho.di.core.row.value.ValueMetaTimestamp.writeData(ValueMetaTimestamp.java:559)
      2014/08/28 10:27:05 - Dimension lookup/update.0 - at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:548)
      2014/08/28 10:27:05 - Dimension lookup/update.0 - at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:943)
      2014/08/28 10:27:05 - Dimension lookup/update.0 - ... 5 more

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                chriskozlowski Chris Kozlowski
              • Votes:
                0 Vote for this issue
                Watchers:
                12 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 24h
                  24h